DISABLE IRF - Teradata Director Program

Teradata® Director Program Reference

Product
Teradata Director Program
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
bvb1608578422774.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2416
Product Category
Teradata Tools and Utilities

Purpose

Disables TDP internal sessions that are used for Two-phase commit in-doubt resolution.

Syntax



Usage Notes

This command disables the In-doubt Resolution Facility (IRF), which consists of two TDP-internal sessions used for Two-phase commit in-doubt resolution. The result of the DISABLE IRF command is that the two TDP-internal sessions are logged off from the database.

If there are no other sessions logged on and the DISABLE IRF command is completed, the status display on the RDBMS console changes to LOGON/QUIET. This LOGON/QUIET state is necessary for the Reconfiguration program to be run.

Use the DISABLE IRF command to log off the internal sessions, which have the jobname of *TDPINT*. After executing the Reconfiguration program, use the ENABLE IRF command to re-establish the two internal sessions.

If IRF is disabled, then automatic in-doubt resolution and the TDP commands for manual in-doubt resolution (COMMIT, ROLLBACK, and DISPLAY INDOUBT) are rejected. Note that if IRF is disabled, you are still able to use manual in-doubt resolution if you use a CLIv2 application or the TPCCONS utility.

To disable the two internal sessions, you must use this TDP command, DISABLE IRF. Do not use the Performance Monitor command, ABORT SESSIONS, to log off TDP internal sessions.

Example: DISABLE IRF

DISA IRF

Completion Message

TDP0445 sessiontype SESSION ENDED

where sessiontype is either RBM (Resolver Base Module) or LOG. Usually, one message is displayed for the RBM session and one for the LOG session.