ANZDBFKEY (Analyze Database File Keys)

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

ANZDBFKEY Command syntax diagram

 

Purpose

The Analyze Database File Keys (ANZDBFKEY) command produces, from the data created by the ANZDBF command, two reports showing the key structure of the database files.

One report is written to the printer file QPPTANZK. The other report is written to the printer file QPPTANKM. QPPTANZK contains a listing of the access paths (logical files only) and selection criteria for each key field or selection rule. QPPTANKM contains a matrix of the key fields for all logical files based on the physical file.

 

Optional Parameters

FILE

Specifies which physical files to select from the list processed earlier by the Analyze Database File (ANZDBF) command. The report includes all logical files associated with each selected physical file.

*NUMLF: Specifies all physical files that have at least a minimum number of associated logical files. The specific minimum is defined by the NUMLF parameter.

file-name: Specify the name of a particular physical file.

NUMLF

Specifies, if FILE(*NUMLF) is specified, the minimum number of logical files associated with a physical file before that physical file is selected.

5: At least 5 logical files must be associated with a physical file.

file-count: Specify the minimum number of logical files required.

JOB

Specifies the job name of a job submitted for batch processing.

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

ANZDBFKEY: 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 workstation is not available for other use during this time, which could be significant for long jobs.

Example for ANZDBFKEY

ANZDBFKEY   FILE(*NUMLF)  NUMLF(2)

This command produces reports on the keys for all files that refer to physical files with at least two associated logical files.

Error messages for ANZDBFKEY

*ESCAPE Messages

PFR5251

Cannot access data to analyze database file.

PFR9802

Unexpected message monitored.