SCNACCPTH       SCAN ACCESS PATH                       TAADBIA

 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

Added to TAA Productivity Tools October 1, 1996


Home Page

Last modified on March 10, 2014 © 1995, 2014 - TAA Tools, Inc.