You can use command, LIST TABLESPACE to get the list and information on the tablespace of the DB2 database. To get into details, you can include the option SHOW DETAIL. With the option SHOW DETAIL, you will get the following information,
• Tablespace ID
• Name
• Type
• Contents
• State
• Total pages
• Useable pages
• Used pages
• Free pages
• High water mark (pages)
• Page size (bytes)
• Extent size (pages)
• Prefetch size (pages)
• Number of containers
db2 => LIST TABLESPACES SHOW DETAIL
Tablespaces for Current Database
Tablespace ID = 3
Name = PSAPTEMP16
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 10
Useable pages = 10
Used pages = 10
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 16384
Extent size (pages) = 2
Prefetch size (pages) = 8
Number of containers = 4
Tablespace ID = 6
Name = ARA#DDICD
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 51200
Useable pages = 51192
Used pages = 50678
Free pages = 514
High water mark (pages) = 50722
Page size (bytes) = 16384
Extent size (pages) = 2
Prefetch size (pages) = 8
Number of containers = 4
Tablespace ID = 7
Name = ARA#DDICI
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 24576
Useable pages = 24568
Used pages = 22794
Free pages = 1774
High water mark (pages) = 22830
Page size (bytes) = 16384
Extent size (pages) = 2
Prefetch size (pages) = 8
Number of containers = 4
Tablespace ID = 8
Name = ARA#USER1D
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 2048
Useable pages = 2040
Used pages = 524
Free pages = 1516
High water mark (pages) = 524
Page size (bytes) = 16384
Extent size (pages) = 2
Prefetch size (pages) = 8
Number of containers = 4
