回复 #1 sweetlamb 的帖子

$ db2 connect to sample

Database Connection Information

Database server       = DB2/AIX64 9.1.0
SQL authorization ID = DB2INST1
Local database alias = SAMPLE

$ db2 list tablespaces show detail

         Tablespaces for Current Database

Tablespace ID                      = 0
Name                               = SYSCATSPACE
Type                               = Database managed space
Contents                            = All permanent data. Regular table space.
State                               = 0x0000
Detailed explanation:
   Normal
Total pages                         = 16384
Useable pages                      = 16380
Used pages                         = 9464
Free pages                         = 6916
High water mark (pages)             = 9464
Page size (bytes)                   = 4096
Extent size (pages)                = 4
Prefetch size (pages)             = 12
Number of containers                = 1

Tablespace ID                      = 1
Name                               = TEMPSPACE1
Type                               = System managed space
Contents                            = System Temporary data
State                               = 0x0000
Detailed explanation:
   Normal
Total pages                         = 1
Useable pages                      = 1
Used pages                         = 1
Free pages                         = Not applicable
High water mark (pages)             = Not applicable
Page size (bytes)                   = 4096
Extent size (pages)                = 32
Prefetch size (pages)             = 32
Number of containers                = 1

Tablespace ID                      = 2
Name                               = USERSPACE1
Type                               = Database managed space
Contents                            = All permanent data. Large table space.
State                               = 0x0000
Detailed explanation:
   Normal
Total pages                         = 8192
Useable pages                      = 8160
Used pages                         = 1888
Free pages                         = 6272
High water mark (pages)             = 1888
Page size (bytes)                   = 4096
Extent size (pages)                = 32
Prefetch size (pages)             = 96
Number of containers                = 1

Tablespace ID                      = 3
Name                               = IBMDB2SAMPLEREL
Type                               = Database managed space
Contents                            = All permanent data. Large table space.
State                               = 0x0000
Detailed explanation:
   Normal
Total pages                         = 8192
Useable pages                      = 8160
Used pages                         = 672
Free pages                         = 7488
High water mark (pages)             = 672
Page size (bytes)                   = 4096
Extent size (pages)                = 32
Prefetch size (pages)             = 96
Number of containers                = 1

Tablespace ID                      = 4
Name                               = SYSTOOLSPACE
Type                               = Database managed space
Contents                            = All permanent data. Large table space.
State                               = 0x0000
Detailed explanation:
   Normal
Total pages                         = 8192
Useable pages                      = 8188
Used pages                         = 20
Free pages                         = 8168
High water mark (pages)             = 20
Page size (bytes)                   = 4096
Extent size (pages)                = 4
Prefetch size (pages)             = 12
Number of containers                = 1

Tablespace ID                      = 5
Name                               = TS1
Type                               = Database managed space
Contents                            = All permanent data. Large table space.
State                               = 0x0000
Detailed explanation:
   Normal
Total pages                         = 7680
Useable pages                      = 7648
Used pages                         = 96
Free pages                         = 7552
High water mark (pages)             = 96
Page size (bytes)                   = 4096
Extent size (pages)                = 32
Prefetch size (pages)             = 96
Number of containers                = 1

$

注意查看Page size (bytes)即可。