ANZDBF (Analyze Database Files)

Note: To use this command, have the 5722-PT1 (Performance Tools for iSeries) licensed program installed.

ANZDBF Command syntax diagram

 

Purpose

The Analyze Database Files (ANZDBF) command produces two reports that show the physical and logical files in a set of libraries and the relationships between the files. It saves the information in a database file for further analysis by the Analyze Database File Keys (ANZDBFKEY) command. Both reports (physical to logical file relationships and logical to physical file relationships) are written to the printer file QPPTANZD. Two printer files with the same name are produced. One printer file contains summary data; the other contains detail data. The data is saved in member QAPTAZDR of the database file QPFRDATA/QAPTAZDR.

 

Required Parameters

LIBL

Specifies the libraries that contain the database files on which to report.

 

Optional Parameters

JOB

Specifies the job name used if the job is submitted for batch processing.

Note: If *NONE is specified on the JOBD parameter, this parameter is ignored; job processing is performed interactively.

ANZDBF: The command name is used for the job name.

job-name: Specify the name to be used for any and all batch jobs.

JOBD

Specifies the job description used to submit jobs for batch processing.

The name of the job description can be qualified by one of the following library values:

• *LIBL: All libraries in the job's library list are searched until the first match is found.
• *CURLIB: The current library for the job is searched. If no library is specified as the current library for the job, the QGPL library is used.
• library-name: Specify the name of the library to be searched.

QPFRJOBD: The IBM-supplied job description, QPFRJOBD, is used.

job-description-name: Specify the name of an alternative job description.

Other Single Values

*NONE: A batch job is not submitted; instead, processing continues interactively while the user waits. The user's work station is not available for other use during this time, which could be significant for long jobs.

Example for ANZDBF

ANZDBF   LIBL(APDTA ARDTA)

This command produces reports showing the relationships for all files in the Accounts Payable (APDTA) and Accounts Receivable (ARDTA) data libraries.

Error messages for ANZDBF

*ESCAPE Messages

CPF9801

Object &2 in library &3 not found.

CPF9802

Not authorized to object &2 in &3.

PFR9802

Unexpected message monitored.