IFCID 203 - DDF Heuristic COMMIT/ROLLBK

This topic shows detailed information about Record Trace - IFCID 203 - DDF Heuristic COMMIT/ROLLBK.

This record reports a heuristic decision that has forced a COMMIT or ROLLBACK for a distributed indoubt thread. The record is produced when a RECOVER INDOUBT command is issued and a remote participant in a distributed thread reports a heuristic rollback or commit during the resynchronization process.

Record trace - IFCID 203 - DDF Heuristic COMMIT/ROLLBK

The field labels shown in the following sample layout of Record Trace - IFCID 203 - DDF Heuristic COMMIT/ROLLBK are described in the following section.


DECISION SOURCE: LOCAL   DECISION REPORTED: COMMIT    REMOTE DECISION LOCATION: 'BLANK'

AFFECTED THREAD:
NETID: USIBMSY   LUNAME: SY00CDB2  INSTANCE: X'A73916396F69'  LUW SEQ:     1  URID: X'0000154E0AA4'

COORDINATOR LOCATION: M05EC00C
PARTICIPANT LOCATIONS:
N/P

DECISION SOURCE

The source of the decision.

Field Name: QW0203LR

DECISION REPORTED

The decision that was reported.

Field Name: QW0203CA

REMOTE DECISION LOCATION

The location, LU name, or IP address ( NNN.NNN.NNN ) of the location that sent the decision.

Field Name: QW0203LO

NETID

The NETID portion of logical unit of work ID (LUWID).

Field Name: QW0203NT

LUNAME

The LU name portion of the logical unit of work ID (LUWID).

Field Name: QW0203LU

INSTANCE

The instance number portion of the logical unit of work ID (LUWID).

Field Name: QW0203IN

LUW SEQ

The LUW sequence number (commit count) portion of the logical unit of work ID (LUWID).

Field Name: QW0203CM

URID

The recovery log RBA (URID) for the thread.

Field Name: QW0203UR

COORDINATOR LOCATION

The location name, LU name, or IP address ( NNN.NNN.NNN) of the coordinator.

Field Name: QW0203CO

PARTICIPANT LOCATIONS

The location name of the participants in this unit of work that were accessed directly by this Db2 subsystem.

Field Name: QW0203PA