-DISPLAY LOG (DB2)

The DB2® command DISPLAY LOG displays log information about, and the status of, the offload task.

Abbreviation: DIS LOG

Environment

This command can be issued from a z/OS® console, a DSN session under TSO, a DB2I panel (DB2 COMMANDS), an IMS™ or CICS® terminal, or a program using the instrumentation facility interface (IFI).

Data sharing scope: Member

Authorization

To execute this command, you must use a privilege set of the process that includes one of the following privileges or authorities:
  • DISPLAY system privilege
  • Start of changeSystem DBADM authorityEnd of change
  • SYSOPR authority
  • SYSCTRL authority
  • SYSADM authority

DB2 commands that are issued from a logged-on z/OS console or TSO SDSF can be checked by DB2 authorization using primary and secondary authorization IDs.

Syntax

>>-DISPLAY LOG-------------------------------------------------><

Usage notes

Start of change Information provided by the DISPLAY LOG command : You can use the DISPLAY LOG command to view the current checkpoint scheduling parameters and information about the current active log data sets and status of the offload task. You can obtain additional information about log data sets and checkpoint information by using the Print Log Map utility (DSNJU004).End of change

Output

Start of changeMessage DSNJ370I indicates the beginning of the output of the command.End of change

Examples

Example: Displaying log information
The following command displays information about the log and the status of any offload tasks.
-DISPLAY LOG

The output is similar to the following output:

Start of change
DSNJ370I - DSNJCOOA LOG DISPLAY
CURRENT COPY1 LOG = DSNC100.LOGCOPY1.DS03 IS 22% FULL
CURRENT COPY2 LOG = DSNC100.LOGCOPY2.DS03 IS 22% FULL 
          H/W RBA = 0000039A9F24, 
          LOGLOAD = 150000
          FULL LOGS TO OFFLOAD = 2 OF 6, 
          OFFLOAD TASK IS (BUSY,ALLC)
          SOFTWARE ACCELERATION IS ENABLED 
DSNJ371I - DB2 RESTARTED 14:06:23 MAY 22, 2011
RESTART RBA 0000039A8000
DSN9022I - DSNJC001 'DIS LOG' NORMAL COMPLETION
End of change

The output provides the following information:

  • The active log data sets are 22% full. If you are running dual logs and the percentages are different, the log data sets are of different sizes. DB2 switches both active logs when one reaches the end of the file. This can result in unused active log space if one log data set is larger than the other.
  • The current LOGLOAD setting is 150000 log records between system checkpoints. You can modify this value using the SET LOG command.
  • Two of the six active log data sets require archiving. The status of the offload task includes the indicator that it is busy, allocating an archive log data set. This might be an indication of an outstanding tape mount on the system console. If the status remains busy and no longer seems to be functioning, you can terminate the task and then restart it using the ARCHIVE LOG CANCEL OFFLOAD command.
  • DB2 was started at 14:06:23 on MAY 22, 2011, and began logging at RBA 0000039A8000.
  • Start of changeSoftware acceleration is enabled for peer-to-peer remote copy.End of change