Get the Lists and Information on DB2 Tablespace



Share this article :

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

Related posts

List DB2 Database Directory
DB2 Backup, Restore & Recovery Operations Monitoring
Enable / Disable Auto Start of DB2 Administration Server
Find DB2 Database Process Status on Windows & UNIX/Linux
© 2017 ITsiti. All Rights Reserved
Powered by KEEM