DB2 Developers Guide (5th Edition)

2017-07-07 02:10:07

< Day Day Up >

Tables A.1 and A.2 provide a synopsis of the databases and table spaces used for the sample tables.

Table A.1. Sample Databases

Database Name	Storage Group	Buffer Pool	CCSID
`DSN8D81A`	`DSN8G810`	`BP0`	`EBCDIC`
`DSN8D81L`	`DSN8G810`	`BP0`	`EBCDIC`
`DSN8D81P`	`DSN8G810`	`BP0`	`EBCDIC`

Table A.2. Sample Table Spaces

Table Space Name	Database Name	Buffer Pool	Table Space Type	Lock Size	Compressed
`DSN8S81B`	`DSN8D81L`	`BP0`	`SIMPLE`	`PAGE`	`NO`
`DSN8S81C`	`DSN8D81P`	`BP0`	`SEGMENTED`	`TABLE`	`NO`
`DSN8S81D`	`DSN8D81A`	`BP0`	`SIMPLE`	`PAGE`	`NO`
`DSN8S81E`	`DSN8D81A`	`BP0`	`PARTITIONED`	`PAGE`	`YES`
`DSN8S81P`	`DSN8D81A`	`BP0`	`SEGMENTED`	`ROW`	`NO`
`DSN8S81R`	`DSN8D81A`	`BP0`	`SIMPLE`	`PAGE`	`NO`
`DSN8S81S`	`DSN8D81A`	`BP0`	`SIMPLE`	`PAGE`	`NO`
`DSN8S81L`	`DSN8D81L`	`BP0`	`LOB`	N/A	N/A
`DSN8S81M`	`DSN8D81L`	`BP0`	`LOB`	N/A	N/A
`DSN8S81N`	`DSN8D81L`	`BP0`	`LOB`	N/A	N/A

< Day Day Up >

Категории

Search