Purpose
Retrieves a list of tables that are affected by a skip transaction request.
Syntax
SESSION SKIP LIST <BCM Session ID> <transaction ID>ON <tdpid>;Parameters
- BCM Session ID
- Assigned Business Continuity Manager session ID.
- Transaction ID
- Assigned Transaction ID.
- tdpid
- Unique identifier (TDPID) of a Teradata Database system.
Usage Considerations
This command returns the list of objects affected if the specified transaction ID is skipped during recovery.
This transaction ID specified must be the transaction ID that is currently blocking recovery of the specified session. If the transaction ID does not match the session's interrupt transaction ID, the following error is returned: "Specified transaction ID does not match expected interrupted transaction ID for session."
Example
bcmadmin> SESSION SKIP LIST 100 436 on flash; Tables affected by transaction ____________________________________ db2inst2.doc_test3 db2inst2.doc_test4 ____________________________________ 2 tables