The Print Data Base File Exceptions command prints a listing of files
and members where the current status exceeds either a specified
percentage of deleted records, a size of deleted record space (number
of deleted records times record length), or the number of records
exceeds a percentage of record capacity.
A typical command would be entered as:
This is a slow running command and should be submitted to batch.
The deleted record information can assist you in determining the use
The command also checks for other situations. For example, in a
typical data base environment, it is difficult to determine whether
any of the flagged conditions exist. While most users do not have
such conditions, the PRTDBFEXP command provides a method of
The following conditions are flagged:
-- A keyed source file.
-- Use of the FRCACCPTH keyword
-- Use of FRCRATIO of greater than 1.
-- Use of FRCRATIO 1 or greater and journaling.
-- The member contains over 1 million records and
journaling of the access path is not being used.
-- The member contains only deleted records (CLRPFM should
Command parameters *CMD
LIB A single library may be specified or the special
values *LIBL, *CURLIB, *USRLIBL *ALLUSR, *ALL. If
*ALL or *ALLUSR are specified, you must have *USE
authority to the TAADSPADP authorization list.
DLTPCT The threshold delete percentage to check against.
The default is 20%. If the percentage of deleted
records is greater than the specified value, the
member is flagged.
DLTSPACE The threshold delete space to check against. The
default is 10,000,000 bytes. If the number of
deleted records multiplied by the record length
exceeds the value, the member is flagged.
SIZPCT The threshold size percentage to check against. The
default is 90%. If the percentage of number of
records to record capacity exceeds the percentage,
the member is flagged.
PRTFILE The qualified name of the printer file to be used.
QPRINT in *LIBL is the default. The spooled file
name is the library specified. If LIB(*ALL) is
specified, the PRTFILE name is used.
The following TAA Tools must be on your system:
DSPFDA DSPFD with adopt (part of DSPADP tool)
RTVSYSVAL3 Retrieve system value 3
SNDCOMPMSG Send completion message
SNDESCMSG Send escape message
SNDSTSMSG Send status message
None, the tool is ready to use.
Objects used by the tool
Object Type Attribute Src member Src file
------ ----- --------- ---------- -----------
PRTDBFEXP *CMD TAADBFO QATTCMD
Note 1 TAADBFOP QATTDDS
Note 1 TAADBFOL QATTDDS
TAAFDPHY *FILE PF Note 1
TAAFDLGL *FILE PF Note 1
TAAFDMBR *FILE PF Note 1
TAADBFOC *PGM CLP TAADBFOC QATTCL
TAADBFOR *PGM RPG TAADBFOR QATTRPG
Note 1 Two DDS source members are used to create temporary
files. DSPFD of three different types is then used to
create the TAAFDxxx files that reside in TAATOOL. These
are authorized to *PUBLIC as AUT(*ALL) to allow
CRTDUPOBJ to work successfully when PRTDBFEXP is run.
The files are created with a large maximum record