Purpose
Retrieves a list of tables that are affected by a skip transaction request.
Syntax
SESSION SKIP LIST <Unity Session ID> <transaction ID>ON <tdpid>;Parameters
- Unity Session ID
- Assigned Unity 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 that will be 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
unityadmin> SESSION SKIP LIST 100 436 on flash; Tables affected by transaction ____________________________________ db2inst2.doc_test3 db2inst2.doc_test4 ____________________________________ 2 tables