The Scan Access Path command scans a library for access paths and
determines if any key fields exist that match a key length specified
on the command. SCNACCPTH is an option on the SCN2000 command and is
intended for year 2000 considerations.
A typical command would be:
SCNACCPTH LIB(xxx) KEYLEN(6)
The command would scan the library for data base files and determine
the key fields in each access path. The length of each key would be
compared to the KEYLEN value. By default, either a character key of
6 bytes or a decimal key of 6 digits (and 0 decimals) would cause a
line to be printed in the output spooled file. An option exists to
request just *CHAR or *DEC key fields.
Reviewing the spooled file can assist you in determining year 2000
considerations.
For example, by using the spooled file, you could check the other key
fields in the file to see if century information was a high order
key. If not, the programs that use the access path may be exposed to
incorrect processing when the year 2000 occurs.
You can use the DSPWHRUSE tool to determine the programs that use the
file.
The default for KEYLEN is 6. You may also want to check for key
lengths of 2 or 4.
Command parameters *CMD
------------------
LIB The library to be scanned for access paths.
KEYLEN The length of the key to check for. The default is
6. Either a character key of 6 bytes or a decimal
key of 6 digits (and 0 decimals) would cause a line
to be printed in the output spooled file.
KEYTYPE The type of key to check for. The default is *BOTH
meaning to check for both *CHAR and *DEC type key
fields. Either *CHAR or *DEC may be specified to
limit the scan to character or decimal key fields.
Restrictions
------------
The key length can only be determined if the key field exists in the
first 200 fields in a data base file. If less than 200 fields exist,
there is no restriction.
Prerequisites
-------------
The following TAA Tools must be on your system:
RTVSYSVAL3 Retrieve system value 3
SNDCOMPMSG Send completion message
SNDSTSMSG Send status message
Implementation
--------------
None, the tool is ready to use.
Objects used by the tool
------------------------
Object Type Attribute Src member Src file
------ ---- --------- ---------- ----------
SCNACCPTH *CMD TAADBIA QATTCMD
TAADBIAC *PGM CLP TAADBIAC QATTCL
TAADBIAC2 *PGM CLP TAADBIAC2 QATTCL
TAADBIAR *PGM RPG TAADBIAR QATTRPG