TAA Tools
CVTACCPTH          CONVERT ACCESS PATH                    TAAACPT
The Convert  Access Path command  produces an  outfile of physical  and
logical  files  which have  a  4 GB  maximum  access path  limit.   The
outfile  shows  the  percentage of  4GB  each  file is  at  and  can be
checked to identify files approaching that limit.

The outfile name defaults  to ACCPTHP, but the  name can be changed  to
a user  specified name in  a specific library.   A replace  option also
exists.

Some  background on 4GB  access paths: Files created  by older versions
of the OS/400  operating system  usually had ACCPTHSIZ  set to  *MAX4GB
by default.   Also,  many early files  created by  third-party software
vendors were created with *MAX4GB as the default.

When  a *MAX4GB  file access  path size hits  the 4  GB limit,  it will
stop accepting updates and your  application will crash with a  MCH2804
message (MCH2804  - Tried to  go larger than  storage limit for  object
&1).

A typical command would be:

             CVTACCPTH  LIB(LIBTOCHECK) OUTLIB(QTEMP) REPLACE(*YES)

One record  would be written  for each file  found which has  an access
path  defined as  *MAX4GB.   Columns are  shown for 'Access  Path Size'
and 'Access Path % of 4GB'.

When the  'Access Path %  of 4GB' column  shows higher percentages  (75
percent or  greater is a good  guage), one should consider  using CHGPF
or  CHGLF to change the access  path size to 1  Terabyte, which is more
suitable to handle the large file sizes of today without issue.

CVTACCPTH escape messages you can monitor for
------------------------------------------

CPF9822  -  Not  autorized  to  file  ACCPTHP.    You  must  have  *USE
authority to file ACCPTHP.

CPF9802 -  Not autorized  to member.   You  must have *OBJOPR,  *OBJMGT
and *DLT authority to replace the data in the member.

Escape messages from based on functions will be re-sent.

CVTACCPTH Command parameters                       *CMD
-------------------------

   LIB           Library  to search for  files with access  path set to
                 *MAX4GB.   A library  name may  be specified  or  *ALL
                 may be used.

   OUTLIB        Library  for ACCPTHP  file.   A  library  name may  be
                 specified or  the default *LIBL  may be used.   If the
                 ACCPTHP  file does  not already  exist in  the library
                 list, a library must be specified.

   OUTMBR        Member to receive output.   The member of the  ACCPTHP
                 file to  be used.   If the  member does not  exist, it
                 is added.  The default is ACCPTHP.

   REPLACE       Replace  data   in  member.    A  *YES/*NO  value  for
                 whether the member  should be  cleared before  writing
                 records into  it.  The  default is  *YES.  *NO  may be
                 specified to add records to an existing file.


Restrictions
------------

None

Prerequisites
-------------

The following TAA Tools must be on your system:

     DUPTAADBF       Duplicate TAA data base file
     EDTVAR          Edit variable
     RTVDAT          Retrieve date
     SNDCOMPMSG      Send completion message
     SNDESCINF       Send escape information
     SNDESCMSG       Send escape 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
   ------        ----    ---------      ----------    ----------

   CVTACCPTH     *CMD                   TAAACPT       QATTCMD
   TAAACPTC      *PGM       CLLE        TAAACPTC      QATTCL
   TAAACPTR      *PGM       RPGLE       TAAACPTR      QATTRPG
   TAAACPTP      *FILE      PF          TAAACPTP      QATTDDS
   TAAACPTHC     *PNLGRP                TAAACPTHC     QATTUIM
					

Added to TAA Productivity tools April 15, 2020


Home Page Up to Top