TAA Tools
PRTDBFEXP      PRINT DATA BASE FILE EXCEPTIONS            TAADBFO

The Print Data Base  File Exceptions command prints a  listing of files
and  members  where  the  current  status  exceeds either  a  specified
percentage  of deleted records, a size  of deleted record space (number
of deleted  records  times record  length), or  the  number of  records
exceeds a percentage of record capacity.

A typical command would be entered as:

       PRTDBFEXP     LIB(PRODUCTION)

This is a slow running command and should be submitted to batch.

The deleted  record information can  assist you in determining  the use
of RGZPFM.

The  command  also checks  for  other situations.   For  example,  in a
typical data base  environment, it  is difficult  to determine  whether
any of  the flagged  conditions exist.   While most  users do  not have
such   conditions,  the   PRTDBFEXP  command   provides  a   method  of
periodically checking.

The following conditions are flagged:

         --   A keyed source file.

         --   Use of the FRCACCPTH keyword

         --   Use of FRCRATIO of greater than 1.

         --   Use of FRCRATIO 1 or greater and journaling.

         --   The  member   contains  over   1  million   records   and
              journaling of the access path is not being used.

         --   The member contains  only deleted records  (CLRPFM should
              be used).

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

   LIB           A  single  library may  be  specified  or the  special
                 values  *LIBL,  *CURLIB, *USRLIBL  *ALLUSR, *ALL.   If
                 *ALL or  *ALLUSR  are specified,  you  must have  *USE
                 authority to the TAADSPADP authorization list.

   DLTPCT        The  threshold  delete  percentage to  check  against.
                 The  default is  20%.   If  the percentage  of deleted
                 records is  greater  than  the  specified  value,  the
                 member is flagged.

   DLTSPACE      The  threshold delete  space to  check  against.   The
                 default  is  10,000,000  bytes.    If  the  number  of
                 deleted  records  multiplied  by  the  record   length
                 exceeds the value, the member is flagged.

   SIZPCT        The threshold size  percentage to check against.   The
                 default  is  90%.   If  the  percentage  of number  of
                 records  to  record capacity  exceeds  the percentage,
                 the member is flagged.

   PRTFILE       The qualified  name of the  printer file  to be  used.
                 QPRINT  in *LIBL  is the  default.   The  spooled file
                 name  is  the  library  specified.    If  LIB(*ALL) is
                 specified, the PRTFILE name is used.

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

None.

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

The following TAA Tools must be on your system:

     DSPFDA       DSPFD with adopt (part of DSPADP tool)
     RTVSYSVAL3   Retrieve system value 3
     SNDCOMPMSG   Send completion message
     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
   ------        -----      ---------      ----------     -----------

   PRTDBFEXP     *CMD                      TAADBFO        QATTCMD
      Note 1                               TAADBFOP       QATTDDS
      Note 1                               TAADBFOL       QATTDDS
   TAAFDPHY      *FILE         PF             Note 1
   TAAFDLGL      *FILE         PF             Note 1
   TAAFDMBR      *FILE         PF             Note 1
   TAADBFOC      *PGM          CLP         TAADBFOC       QATTCL
   TAADBFOR      *PGM          RPG         TAADBFOR       QATTRPG

  Note 1        Two DDS source  members  are  used  to create temporary
                files.  DSPFD of three  different types is then used to
                create the TAAFDxxx files that reside in TAATOOL. These
                are  authorized  to   *PUBLIC  as  AUT(*ALL)  to  allow
                CRTDUPOBJ to work  successfully  when PRTDBFEXP is run.
                The files are  created  with  a  large  maximum  record
                capacity.
					

Added to TAA Productivity tools April 1, 1995


Home Page Up to Top