-DISPLAY ARCHIVE command (Db2)

The -DISPLAY ARCHIVE command displays input archive log information.

Abbreviation: -DIS ARC

Environment for -DISPLAY ARCHIVE

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 for -DISPLAY ARCHIVE

To execute this command, you must use a privilege set of the process that includes one of the following privileges or authorities:
  • DISPLAY privilege
  • System DBADM authority
  • 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. Start of changeA logged-on z/OS user ID must be defined in RACF or a similar security server.End of change

Syntax for -DISPLAY ARCHIVE

Read syntax diagramSkip visual syntax diagramDISPLAY ARCHIVE

OUTPUT for -DISPLAY ARCHIVE

The DSNJ322I message displays output from the DISPLAY ARCHIVE command. This output contains information about archive log data sets that are in use for the subsystem or data-sharing member. For data-sharing environments, it does not include information about the entire group.

The output begins with the following lines that describe the basic characteristics of the archive units for reading the archive logs:

DSNJ322I  -DISPLAY ARCHIVE REPORT FOLLOWS- 
                COUNT                   TIME
              (TAPE UNITS)            (MIN,SEC)
name           count                     time
name           count                     time
name
An identifier for the count and time values that follow on the same line.

name can have one of the following values:

DSNZPARM
The count and time values that follow are the values that were specified during Db2 installation. These values correspond to the following subsystem parameters:
  • The count value is from the MAXRTU subsystem parameter.
  • The time value is from the DEALLCT subsystem parameter.
CURRENT
The count and time values that follow are the current values in the Db2 subsystem. These values might be the same as the subsystem parameter values that are listed in the DSNZPARM line. However, if those values were overridden by the SET ARCHIVE command, this line lists those changed values.
count
The maximum number of tape units that can be allocated to concurrently read archive log tape volumes.
time
The length of time that an allocated archive read tape unit can remain unused before it is deallocated. The format is minutes,seconds. Start of changeA time value of 1440 indicates that there is no limit to the length of time.End of change

After the information about archive units, the output contains the following lines:

===============================================
ADDR  STAT  CORR-ID  VOLSER  DATASET_NAME 
addr  status  corr-id  vname   dsname
...
END OF DISPLAY ARCHIVE REPORT.

These lines describe the archive log data sets that are being read. After the heading information, one line is displayed for each archive log data set that is being read. Each of those lines includes the following information:

addr
The physical address of the device that is allocated to read the archive log.
status
The status of the device, which can be one of the following values:
BUSY
The device is actively processing an archive log data set.
PREM
The device is active and allocated for premount.
AVL
The device is inactive and waiting for work.
RCAL
The archive data set is being recalled by HSM.
corr-id
The correlation id that is associated with the user of the device that is being processed. If the status is PREM or AVL, this column might contain *****, which indicates that a current user is not associated with this device.
vname
The name of the archive volume that is mounted at the device address.
dsname
If status is BUSY, PREM or RCAL, the name of the data set on the archive volume that is being processed.

If status is AVL, the name of the data set on the archive volume that was last processed.

KEY LABEL key-label
The key label that was used to encrypt the archive log data set.

If no archive logs are currently being read, the following message is displayed instead of the lines that describe the archive log data sets:

NO ARCHIVE READ ACTIVITY

Usage notes for -DISPLAY ARCHIVE

Data sharing members: Although the command ARCHIVE LOG SCOPE(GROUP) or ARCHIVE LOG MODE(QUIESCE) initiates archive processing for all members of a data sharing group, the command DISPLAY ARCHIVE shows information only for the member for which it is issued. To display input archive log information for all members of a data sharing group, enter the command on each member.

Examples for -DISPLAY ARCHIVE

Example: Displaying information about archive log data sets
Issue the following command to display information about archive log data sets that are in use:
-DISPLAY ARCHIVE

The output is similar to the following output:

DSNJ322I -DISPLAY ARCHIVE REPORT FOLLOWS
              COUNT       TIME
          (TAPE UNITS) (MIN,SEC)
DSNZPARM       2         0,00
CURRENT        2         0,00
===============================
ADDR STAT CORR-ID  VOLSER DATASET_NAME
03B0 BUSY SHEDDEN  A00001 DSNT2AR1.DT25.D04169.T1328583.A0012701
     RCAL 03RCRSC  MIGRAT DSNT2AR1.DT25.D04169.T1334426.A0012704
A99B BUSY 14DRSTRT ARN690 DSNT2AR1.DT25.D04169.T1346176.A0012705
BDDD BUSY 10LPLALR ARN738 DSNT2AR1.DT25.D04170.T1506437.A0012743
END OF DISPLAY ARCHIVE REPORT.                                    

The output is similar to the following if the data set is encrypted:

DSNJ322I -DISPLAY ARCHIVE REPORT FOLLOWS
COUNT TIME
(TAPE UNITS) (MIN,SEC)
DSNZPARM 2 0,00
CURRENT 2 0,00
===============================
ADDR STAT CORR-ID VOLSER DATASET_NAME
03B0 BUSY SHEDDEN A00001 DSNT2AR1.DT25.D04169.T1328583.A0012701
KEY LABEL = DB2SYSTEMKEY01
RCAL 03RCRSC MIGRAT DSNT2AR1.DT25.D04169.T1334426.A0012704
KEY LABEL = DB2SYSTEMKEY01
A99B BUSY 14DRSTRT ARN690 DSNT2AR1.DT25.D04169.T1346176.A0012705
KEY LABEL = DB2SYSTEMKEY01
BDDD BUSY 10LPLALR ARN738 DSNT2AR1.DT25.D04170.T1506437.A0012743
KEY LABEL = DB2SYSTEMKEY02
END OF DISPLAY ARCHIVE REPORT.                                    

The report shows the following information:

  • The subsystem parameter values for MAX RTU (COUNT) and DEALLC PERIOD TIME as recorded in the DSNZPxxx load module
  • Current specifications for the COUNT and TIME parameters
  • Availability status of allocated archive log data sets
  • Volume and data set names that are associated with current archive log read requests
  • KEY LABEL information