The Check Duplicate Access Path command checks for files in one or
more libraries that have a duplicate access path with another
physical or logical file. The system will automatically share an
access path if it can. Complete duplicates and partial duplicates
(where only the high order keys are the same) are listed. The
purpose of CHKDUPAP is to assist in cleaning up objects that are not
needed.
A typical command would be:
CHKDUPAP LIB(xxx)
All logical file members in the library would be accessed and listed.
Any shared access paths would be noted.
Access paths are flagged with %1 that are shared with another access
path and the number of keys are the same.
Access paths are flagged with %2 that are shared, but the number of
key fields differ. This type of file may not be a good candidate for
deletion.
Both keyed access paths and arrival sequence access paths are
considered.
Multi-format logical files are noted, but not checked.
CHKDUPAP escape messages you can monitor for
--------------------------------------------
None. Escape messages from based on functions will be re-sent.
Command parameters *CMD
------------------
LIB The library name to be checked. The special values
*USRLIBL or *ALLUSR may be entered. You must have
*ALLOBJ special authority to use *ALLUSR.
OMITLIBS The name or generic names of libraries to be
omitted. Up to 300 entries may be made. The
default is *NONE.
PRTDBFOPT A print option to control the physical and logical
files that will be listed.
*ALL is the default to print all physical and
logical files.
*ANYDUP will list any logical file that shares an
access path with a previous file and those that are
not checked. This avoids printing any logical file
that has a unique access paths, but includes a
logical file that has an access path which is a
subset of a previous access path. The 'Note' column
will display any %n value. Only the physical files
associated with a logical that is listed will be
printed.
*DUPKEY will list those logical files that fully
share an access path of a previous file and those
that are not checked. The 'Note' column will
display any %1 and %3 values and bypass the %2 notes
which indicate the same access path is shared, but
not the same number of keys. Only the physical
files associated with a logical that is listed will
be printed.
PRTOPT A print option for whether to include the size and
last use date of each logical file.
*BASIC is the default which does not include the
size and last use date.
*EXTENDED may be entered to print 2 extra lines for
each logical file. The first line shows the last
used date and the second line describes the size of
the object.
Restrictions
------------
** You must have *ALLOBJ special authority to specify
LIB(*ALLUSR).
** Multi-format logical files are listed, but not checked.
Prerequisites
-------------
The following TAA Tools must be on your system:
CHKALLOBJ Check *ALLOBJ special authority
EDTVAR Edit variable
EXTLST2 Extract list 2
RTVDBFA Retrieve data base file attributes
RTVSYSVAL3 Retrieve system value 3
SNDCOMPMSG Send completion message
SNDESCINF Send escape information
SNDESCMSG Send escape message
SNDJLGMSG Send job log message
SNDSTSCNT Send status message
SORTDBF Sort data base file
Implementation
--------------
None, the tool is ready to use.
Objects used by the tool
------------------------
Object Type Attribute Src member Src file
------ ---- --------- ---------- ----------
CHKDUPAP *CMD TAADBKO QATTCMD
TAADBKOC *PGM CLP TAADBKOC QATTCL
TAADBKOC2 *PGM CLP TAADBKOC2 QATTCL
TAADBKOC3 *PGM CLP TAADBKOC3 QATTCL
TAADBKOR *PGM RPG TAADBKOR QATTRPG
|
