Below are a list with the more common status of IBM DB2 tablespaces

The most used method to show the status of the tablespaces is, from the console command line:

db2 > list tablespaces show detail

Tablespace ID = 32

Name = JRP#DDICI2

Type = Database managed space

Contents = All permanent data. Large table space.

State = 0x0000

Detailed explanation:

Normal

Total pages = 76552

Useable pages = 76544

Used pages = 74854

Free pages = 1690

High water mark (pages) = 74854

Page size (bytes) = 16384

Extent size (pages) = 2

Prefetch size (pages) = 8

Number of containers = 4

 

DB2 tablespaces status:

               0x0                         Normal

               0x1                         Quiesced : SHARE

               0x2                         Quiesced : UPDATE

               0x4                         Quiesced : EXCLUSIVE

               0x8                        Pending load

               0x10                      Pending delete

               0x20                      Pending backup

               0x40                      Roll Forward in Progress

               0x80                      Roll Forward Pending

               0x100                    Pending restore

               0x100                    Pending recovery (don't used)

               0x200                    Pending disable

               0x400                    Reorganization in progress

               0x800                    Backup in Progress

               0x1000                  Storage Must be Defined

               0x2000                  Restore in Progress

               0x4000                  Offline and Not Accessible

               0x8000                  Drop Pending

               0x2000000         Storage May be Defined

               0x4000000         Storage definition in final 'status'

               0x8000000         Storage definition changed before recovering

               0x10000000       Active DMS

               0x20000000       Drop tables space in progress

               0x40000000       Table Space Creation in Progress

               0x8                     Only for service use