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