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

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval
dita:id
B035-2520
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