Each row represents status and configuration settings of the recovery domain for the specified application group.
Field | Description | Type, length | Valid values | Column heading |
TSP | Timestamp when record was written |
CHAR (26) | Timestamp | TSP |
STSSYS | System definition where record was written |
CHAR (8) | System definition name |
STSSYS |
INSTLIB | Instance library where record was written |
CHAR (10) | Instance library name |
INSTLIB |
AGNAME | Application group name | CHAR (10) | Application Group name |
AGNAME |
ID | Node name | CHAR (8) | Node name | ID |
NAME | Node name | CHAR (8) | Node name | NAME |
STATUS | Node status for this AG | CHAR (8) |
*ACTIVE *INACTIVE *NONE *UNKNOWN If *CLU (Cluster) AG: *ADDNODPND *CHGPND *CRTPND *DLTCMDPND *DLTPND *ENDCRGPND *INDOUBT *NOTAVAIL *RESTORED *RMVNODPND *STRCRGPND *SWTPND |
STATUS |
CURROLE | Current role for this node for this AG |
CHAR (10) |
*PRIMARY *BACKUP *REPLICATE *PEER *UNDEFINED |
CURROLE |
CURROLESEQ | Current role sequence for this node for this AG |
BINARY (9,0) | integer | CURROLESEQ |
CURPR00001 | Current provide node for this node for this AG |
CHAR (8) | Node name | CURPROVIDER |
CFGROLE | Configured role for this node for this AG |
CHAR (10) |
*PRIMARY *BACKUP *REPLICATE *PEER *UNDEFINED |
CFGROLE |
CFGROLESEQ | Configured role sequence for this node for this AG |
BINARY (9,0) | Integer | CFGROLESEQ |
CFGPR00001 | Configured provide node for this node for this AG |
CHAR (10) | Node name | CFGPROVIDER |