Tablespace state (TblspState)

This parameter indicates the state of the selected table space as a hexadecimal number (where 0 indicates a normal state).

For a textual equivalent to the numeric value, use the DB2 command, db2tbst. DB2 provides this application in the sqllib/misc directory. For example, the command db2tbst 0x0000 returns State=Normal

Check the pconfig variables stateWarnList and stateAlertList in pso_ruleSet.cfg to check how to config the state of this parameter, depend on values user insert to pconfig variables this parameter will change its state to warn or alarm and display a correspond annotation in its graph.

The value of this parameter if it’s not normal then it will display as decimal and in the annotation the value will be displayed as Hex decimal and will also show the status in the annotation

The following list is the list of table space states with the hex decimal of each state, so customer can get the hex decimal values of any state or any combination of states from here:

NORMAL = 0x0

QUIESCED_SHARE = 0x1

QUIESCED_UPDATE = 0x2

QUIESCED_EXCLUSIVE = 0x4

LOAD_PENDING = 0x8

BACKUP_PENDING = 0x20

ROLLFORWARD_IN_PROGRESS = 0x40

ROLLFORWARD_PENDING = 0x80

RESTORE_PENDING = 0x100

DISABLE_PENDING = 0x200

REORG_IN_PROGRESS = 0x400

BACKUP_IN_PROGRESS = 0x800

STORDEF_PENDING = 0x1000

RESTORE_IN_PROGRESS = 0x2000

OFFLINE = 0x4000

DROP_PENDING = 0x8000

SUSPEND_WRITE = 0x10000

REDIST_IN_PROGRESS = 0x40000

STORDEF_ALLOWED = 0x2000000

STORDEF_FINAL_VERSION = 0x4000000

STORDEF_CHANGED = 0x8000000

REBAL_IN_PROGRESS = 0x10000000

PSTAT_DELETION = 0x20000000

PSTAT_CREATION = 0x40000000

Default parameter attributes