TS_STATUS listed as hundreds or thousands

Document ID : KB000092790
Last Modified Date : 23/04/2018
Show Technical Document Details
Question:
What do the numbers returned by the db2 probe QOS_DB2_TS_STATUS represent?
Answer:
Normal
0x0


Quiesced Share
0x1 


Quiesced Update
0x2
2

Quiesced Exclusive
0x4


Delete Pending
0x00000010
16 

Backup Pending
0x20
32 

Roll Forward in Progress
0x40
64

Roll Forward Pending
0x80
128 

Restore Pending
0x100
256

Disable Pending
0x200
512 

Reorg in Progress
0x400
1024 

Backup in Progress 
0x800
2048 

Storage Must be Defined
0x1000
4096 

Restore in Progress
0x2000
8192

Offline and Not Accessible
0x4000
16384 

Drop Pending
0x8000
32768 

Write Suspended
0x00010000
65536 

Load in Progress
0x20000
131072 

Redistribute in Progress
0x40000
262144 

Movement in Progress
0x00080000
524288 

Storage May be Defined
0x2000000
33554432 

DMS Rebalance in Progress 
0x10000000
268435456 

Table Space Deletion in Progress
0x20000000
536870912 

Table Space Creation in Progress
0x40000000
1073741824