Sample Databases and Table Spaces

 <  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  >  


DB2 Developers Guide
DB2 Developers Guide (5th Edition)
ISBN: 0672326132
EAN: 2147483647
Year: 2004
Pages: 388

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net