DSNR007I RESTART...STATUS TABLE
Explanation
This message precedes a table showing the status of units of recovery (URs) after each restart phase. The message and the table will accompany the DSNR004I, DSNR005I, or DSNR006I message after each nested phase. At the end of the current status rebuild phase, it shows the status of any URs that require processing. At the end of the forward recovery and backoutphases, it shows the status of only those URs which needed processing but were not processed. The table helps to identify the URs that were active when Db2 came down, and to determine the log scope required to bring Db2 up.
The following list describes
each column of the table:
- T
- Connection type. The values could be:
- B
- Batch: a batch program or QMF user.
- I
- Internal: a system service being performed on some user's behalf.
- S
- Subsystem: work that originated from an attached subsystem, either CICS® or IMS/VS.
- CONID
- Connection identifier for related URs. Batch connections are not related to any other connection. Subsystem connections with the same identifier indicate URs that originated from the same subsystem.
- CORRID
- Correlation identifier; unique within a subsystem connection, it relates a UR to a particular CICS or IMS/VS transaction.
- AUTHORIZATION ID
- Authorization identifier of the user for whom this UR was created.
- PLAN
- Name of the plan allocated to the UR.
- S
- Restart status of the UR. When Db2 came
down, the UR was in one of these situations:
- A
- INABORT: The UR was in the 'must-complete' phase of abort, and is yet to be completed.
- C
- INCOMMIT: The UR was in the 'must-complete' phase of commit, and is yet to be completed.
- D
- INDOUBT: The UR had completed the first phase of commit, but Db2 had not received the second phase instruction. The UR must be remembered so it can be resolved when the owning subsystem reattaches.
- F
- INFLIGHT: The UR had not completed the first phase of commit, and will be backed out.
- P
- POSTPONED ABORT: The UR has not yet completed backout. Backout must be completed outside of Db2 restart by means of the -RECOVER POSTPONED command.
- URID
- UR identifier, the log RBA of the beginning of this unit of work. It is the earliest RBA required to process the UR during Restart.
- DAY
- The day the UR was created, in the format 'ddd'. It is approximately the time of the first SQL statement of the application or the first SQL statement following a commit point.
- TIME
- The time the UR was created, in the format 'hh mm ss '. It is approximately the time of the first SQL statement of the application or the first SQL statement following a commit point.