SESSION SKIP LIST Command | unityadmin | Teradata Unity - SESSION SKIP LIST - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.51
Published
May 2020
Language
English (United States)
Last Update
2020-06-01
dita:mapPath
oic1588030762460.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

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