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