00D92024

Explanation

During restart, the state of a logged unit of recovery and the state of the global transaction which the unit of recovery is part of are incompatible.

System action

The restart processing abnormally terminates, which terminates the subsystem. This is to prevent the loss or incorrect processing of a Db2 unit of recovery.

Standard Db2 diagnostic information is recorded in SYS1.LOGREC, and an SVC dump is scheduled.

Operator response

Do not attempt to restart Db2 until the error is resolved. Notify the system programmer and collect the following diagnostic items:
  • Console output from the system on which the job was run, and a listing of the SYSLOG data set for the period of time that spans the failure.
  • SVC dump (or system dump), taken to SYS1.DUMPxx data set, as result of an operator-initiated dump command or SLIP trap exit.
  • A listing of the SYS1.LOGREC data set, obtained by executing IFCEREP1.

System programmer response

Print the BSDS using the Print Log Map (DSNJU004) utility. Find the checkpoint queue in the output listing from DSNJU004.

Next, run the Change Log Inventory (DSNJU003) utility to create a conditional restart record with the CHKPTRBA option specifying the begin checkpoint RBA found in the second entry of the checkpoint queue. Restart Db2 using the conditional restart record found. If the same failure occurs, repeat the conditional process using the next begin checkpoint RBA in the checkpoint queue.

Repeat this process, going down the checkpoint queue until Db2 restarts. This will be prior to the time when the invalid record was written to the log. The restart process then applies all the log records to the end of the log.

If you suspect an error in Db2, you might need to report the problem. For information about identifying and reporting the problem, see Collecting diagnostic data.

Problem determination

The state of the logged unit of recovery is reported in register 1 and the state of the global transaction is provided in register 2. The meanings of these values are shown below.

Unit of recovery state (in register 1):
1
inflight
2
ensure abort
3
commit indoubt
4
ensure commit
Global Transaction State (in register 2):
1
inflight
2
ensure abort
3
commit indoubt
4
ensure commit