DSNV406I INDOUBT THREADS -

Explanation

This message marks the beginning of a section of output from the DISPLAY THREAD command, which is part of message DSNV401I.

Information about indoubt and postponed threads (DSNV406I and DSNV431I)

The DISPLAY THREAD command reports the same type of information about indoubt and postponed threads.

Information about indoubt threads begins with a DSNV406I message.

DSNV406I - INDOUBT THREADS -
COORDINATOR               STATUS     RESET URID         AUTHID
text                      text       txt   hex          text
DISPLAY INDOUBT REPORT COMPLETE

Information about postponed abort threads begins with a DSNV431I message.

DSNV431I - POSTPONED ABORT THREADS -
COORDINATOR               STATUS     RESET URID         AUTHID
text                      text       txt   hex          text
DISPLAY POSTPONED ABORT REPORT COMPLETE

Each thread that meets the report criteria is listed on a separate line. Additional information might be provided for individual threads.

COORDINATOR text

The name of the two-phase commit coordinator. The value depends on the type of thread, as follows:

Allied threads

The coordinator name is one of the following values:

• The IMS connection name
• The CICS® connection name
• RRS (for Resource Recovery Services attachment facility connected threads)
• The location name of the local Db2 subsystem.

Additional information is displayed for IMS and CICS connections and for RRS.

Database access threads (DBATs)

The coordinator name is one of the following values:

• location:luname, where location is the relational database name for the coordinator and luname is the SNA LU name for the coordinator.
• location:port, where location is the relational database name for the coordinator and port is the TCP/IP port number for two-phase commit resynchronization for the coordinator.
• <luname>:luname, where luname is the SNA LU name for the coordinator.
• nnn.nnn.nnn.nnn:port , where nnn.nnn.nnn.nnn is the IP address for the coordinator and port is the TCP/IP port number for two-phase commit resynchronization for the coordinator.

If the thread is distributed, additional information is displayed.

STATUS text

The status of the thread.

If the status of a thread for a logical unit of work at a participant is INDOUBT, COMMITTED-H, or ABORTED-H, and the coordinator is a Db2 location that has not cold started, the lack of any information about the thread in a DISPLAY THREAD(INDOUBT) report indicates that the decision at the coordinator was to abort the logical unit of work.

This field can have one of the following values:

ABORT-P

A postponed abort unit of recovery. Objects for which this unit of recovery has backout work pending are inaccessible (restart-pending status) until the abort is completed (for example, by means of the RECOVER POSTPONED command).

ABORT-PSTRT

A postponed abort unit of recovery that is currently undergoing RECOVER POSTPONED processing or automatic Db2 backout processing (requested by restarting with system parameter LBACKOUT = AUTO).

ABORTED

A coordinator status that indicates that Db2 has one or more downstream participants that are using the Presumed Nothing (PN) protocol and might be indoubt. The thread is included in the DISPLAY THREAD output until all downstream PN participants complete indoubt resolution. The detail line V450 lists the downstream participants that have pending resolution. Database locks that were held for the thread are released.

If a participant resolved the indoubt thread with a heuristic decision, and the decision was COMMIT, detail line V452 is displayed. This detail line contains the name of the participant and the heuristic decision that it made. Because the coordinator aborted and the participant committed, this situation indicates heuristic damage. Information about the thread is displayed until it is deleted with the RESET INDOUBT command. The database administrators at all involved locations need to know that heuristic damage occurred and at which location.

ABORTED-H

An indoubt thread that was heuristically resolved with the RECOVER INDOUBT command. Information about the thread is displayed is displayed until the coordinator is informed of the heuristic decision. Additional detail lines might be included in the report.

COMMITTED

A thread that is committed. This status is displayed when Db2 is the coordinator and has downstream participants that might be indoubt. Information about the thread is included in the DISPLAY THREAD output until all downstream participants complete indoubt resolution. Detail line V450 lists the downstream participants that have pending resolution. Database locks that were held for the thread are released.

If a participant resolved the indoubt thread with a heuristic decision, and the decision was ABORT (rollback), detail line V453 is displayed. This detail line contains the name of the participant and the heuristic decision that it made. Because the coordinator committed and the participant aborted, this situation indicates heuristic damage. Information about the thread is displayed until it is deleted with the RESET INDOUBT command. The database administrators at all involved locations need to know that heuristic damage occurred and at which location.

COMMITTED-H

An indoubt thread that was heuristically resolved with the RECOVER INDOUBT command. Information about the thread is displayed until the coordinator is informed of the heuristic decision, and all downstream participants, if any, complete indoubt resolution. Additional detail lines might be included in the report to identify downstream participants that have pending resolution.

INDOUBT

A thread that is indoubt. Information about the thread is displayed until all indoubt resolution responsibilities are complete. Additional detail lines might be included in the report.

RESET txt

If this column contains YES, the thread must be removed from the indoubt display. If necessary, use the RESET INDOUBT command to purge a thread. If this column is empty, the thread does not need to be removed.

URID hex

An RBA of the Db2 recovery log. This point is the beginning of recovery logging for this thread.

AUTHID text

The primary authorization ID that is associated with the thread.

The information about types of threads ends with a REPORT COMPLETE line.