BMCTRANS table
This section describes the BMCTRANS table, which contains information that BMC AMI Recovery Manager and Log Master use for transaction recovery. The table contains one row for each execution of Log Master (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 |
STATEa | 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 |