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 = 24576
Useable pages = 24572
Used pages = 19960
Free pages = 4612
High water mark (pages) = 19960
Page size (bytes) = 4096
Extent size (pages) = 4
Prefetch size (pages) = 24
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) = 192
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 = 96
Free pages = 8064
High water mark (pages) = 96
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 192
Number of containers = 1
Tablespace ID = 3
Name = MASDATASPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x4000
Detailed explanation:
Offline
Tablespace ID = 4
Name = MASIDXSPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x4000
Detailed explanation:
Offline
Tablespace ID = 5
Name = SYSTOOLSPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 8192