SESSION SKIP LIST - Teradata Unity

Teradata Unity User Guide

Product
Teradata Unity
Release Number
16.10
Published
January 2018
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
anz1496162519675.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

Retrieves a list of tables that will be 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