-DISPLAY ARCHIVE command (Db2)

The Db2 command DISPLAY ARCHIVE displays input archive log information.

Abbreviation: -DIS ARC

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 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 change A logged-on z/OS user ID must be defined in RACF or a similar security server. End of change

Syntax

Output

Message DSNJ322I indicates the beginning of the output of the command.

Usage note

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

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.

Start of change FL 502 The output is similar to the following if the data set is encrypted: End of change

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