TblspState (DB2_TSP)


Indicates the state of the selected tablespace as a hexadecimal number (where 0 indicates a normal state).

This parameter indicates the state of the selected tablespace as a hexadecimal number (where 0 indicates a normal state). A number greater than 0 indicates a DB2-defined tablespace state.

For a textual equivalent to the numeric value, use the DB2 command, db2tbst. DB2 provides this application in the sqllib/misc directory. See the DB2 product Command Reference for additional syntax details and for a description of the DB2 tablespace states.

Default parameter attributes

Attribute

Default value

Application class

DB2EEE_TSP

Command type

not applicable

Platform

All

Active at installation

yes

Parameter type

Consumer

Scheduling (poll time)

not applicable

Icon style

Graph

Alarm 1 range

not applicable

Alarm 2 range

not applicable

Border range

not applicable

Unit

Number

Annotated?

yes

Value set by

CollTablespace

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC PATROL for DB2 Universal Database 9.0