ENABLE IRF - Teradata Director Program

Teradata® Director Program Reference

Product
Teradata Director Program
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-11
dita:mapPath
xuf1527114222341.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2416
lifecycle
previous
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 Teradata 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 Database 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.