BMCTRANS table
The BMCTRANS table contains information that BMC AMI Recovery Manager for Db2 and BMC AMI Log Master for Db2 use for transaction recovery.
Important
BMCTRANS table is not used with Db2 version 11 and later.
The following table describes the contents of the BMCTRANS table. The table contains one row for each execution of BMC AMI Log Master for Db2 (that is, one row for each log scan performed).
Column Name | Data type | Description |
---|---|---|
USERID | CHAR(8) NOT NULL | Transaction creator |
TRANID | VARCHAR(18) NOT NULL | Transaction ID |
STARTTIME | TIMESTAMP NOT NULL WITH DEFAULT | Transaction start time |
PITRBA | CHAR(6) NOT NULL FORBIT DATA | RBA for point-in-time recovery |
OUTDSNAME | VARCHAR(35) NOT NULL | Output data set prefix for SQL statements or the logical log |
STATE | SMALLINT NOT NULL | Level of recovery analysis performed:
|
PITTIME | TIMESTAMP NOT NULL WITH DEFAULT | Timestamp for the PIT RBA |
SEQNO | SMALLINT NOT NULL | Sequence number of the filter text |
PITWKEST | FLOAT NOT NULL | Work estimate |
FILTERLINE | VARCHAR(1040) NOT NULL | Text of the filter (may span more than one row) |
UNDONUMROWSUPD | FLOAT | Number of unique rows (RIDs) that are selected by the filter of the log scan |
UNDOSUBSEQUPDROWS | FLOAT | Total number of anomaly log records relating to one of the rows (RIDs) selected by the log scan |
UNDOLOGRECROWS | FLOAT | Number of unique rows (RIDs) that are affected by an anomaly log record |
UNDOJOBSTATUS | SMALLINT | Code indicating the status of an UNDO log scan:
|
REDOJOBSTATUS | SMALLINT | Code indicating the status of a REDO log scan:
|
ENDTIME | TIMESTAMP NOT NULL WITH DEFAULT | Transaction end time |
ACTION | SMALLINT | Code indicating what recovery, if any, has been performed on the transaction |
Comments
Log in or register to comment.