Operating system and syntax UNIX / Windows 
-crTXDisplay
Use with Maximum value Minimum value Single-user default Multi-user default
DBS, PROUTIL – – – –

Use Crash Recovery Transaction Display (-crTXDisplay) to display to the screen only (not the log file) the contents of the transaction table prior to the Physical Undo phase of crash recovery. When -crTXDisplay is specified, the progress messages of crash recovery, controlled by -crStatus, include the counter of the current BI cluster. Use this information to cross-reference the transaction table to determine the location in the BI file of the current phase, relative to the remaining transactions. This information can assist you in determining if there are many transactions to back out during crash recovery, or if there is perhaps one long-running transaction.

The transaction display message contains the following:
  • The transaction ID
  • The timestamp when the transaction began
  • The user number that initiated the transaction
  • The counter of the BI cluster that was current when the transaction began

For more information about crash recovery progress messages, see Crash Recovery Status (-crStatus).

For more information about crash recovery, see Crash recovery.