-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
- 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. A logged-on z/OS user ID must be defined in RACF or a similar security server.
Syntax for -DISPLAY 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.
A time value of 1440 indicates that there is no limit to the length of time.
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