ENABLE IRF - Teradata Director Program

Teradata® Director Program Reference - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Director Program
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-17
dita:mapPath
cki1641301536147.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
frc1470439950465
Product Category
Teradata Tools and Utilities

Purpose

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

Syntax



Usage Notes

This command enables 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 ENABLE IRF command is that the two internal sessions are logged on to the database. If no other sessions are logged on, the status display on the RDBMS console changes from “Logon/Quiet” to “Logon.”

The ENABLE IRF command typically is issued after a DISABLE IRF command is completed. See DISABLE IRF.

Enabling IRF allows automatic in-doubt resolution and the execution of TDP commands for manual in-doubt resolution (COMMIT, ROLLBACK, and DISPLAY INDOUBT).

The userid for both sessions defaults to TDPUSER, but can be changed using the SET USERID command. By default, the userid is in EBCDIC, but a different character set can be specified using the SET CHARSET command. The current userid and character set can be displayed using the DISPLAY TDP command. When a specified character set is not available, the following error message displays:

TDP0394 CHARACTER SET charactersetname IS NOT AVAILABLE.

Example: ENABLE IRF

ENA IRF

Completion Message

TDP0444 type SESSION ESTABLISHED
where type is either:
  • RBM (Resolver Base Module) or
  • LOG

Usually, one message is displayed for the RBM session and another is displayed for the LOG session.

If the database rejects one of the sessions, the following message provides the specific error code:

TDP0427 UNEXPECTED ERROR/FAILURE PARCEL, CODE=nnnn FOR THE type SESSION

For example, if 'nnnn' is 3004, the userid was not defined to the database system.