TAA Tools

The  Print  Data  Base  File Size  command  prints  a  listing  of  the
physical  members of  a  file and  any  dependent logical  files.   The
sizes  of each are  shown and totaled.   A single  file, generic files,
or all  files  in a  library  or  *LIBL etc  may  be specified.    This
provides a simple  means of determining the amount  of space being used
by specific files and their dependent access paths.

A typical command would be:

             PRTDBFSIZ   FILE(xxx/*ALL)

All  physical data files in the named  library would be processed.  One
line would print  for each member  with the number  of records and  the
size  of the  member.   Each dependent  logical file  would be  printed
with one line and the size for the total file.

If  the  file is  keyed,  each member  size  includes the  size  of the
access path as well as the data.

If multi-format  logical files  exist,  the totals  is shown  with  the
first physical  that has the  logical as a  dependency.  Other  uses of
the file  are described with  a 0 size  value and a  note indicating it
has been previously described.

You may select to print files that are greater than a minimum size.

PRTDBFSIZ escape messages you can monitor for

      TAA9891    No physical files exist to meet the criteria.

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

Command parameters                                    *CMD

   FILE          The   qualified  name  of  the  physical  file  to  be
                 processed.  A generic  name or the special  value *ALL
                 may be entered.

                 The  library  value  defaults  to  *LIBL.    *USRLIBL,
                 *CURLIB, *ALL, or *ALLUSR may be specified.

   TYPE          The  type  of  physical file  to  be  processed.   The
                 default  is  *DATA   to  process   only  'data'   type
                 physical files.

                 *SRC may entered to process only source files.

                 *ALL  may  be  entered  to  process  both  'data'  and
                 source files.

   MINSIZ        The minimum  size of a physical  file to be processed.
                 The default is 0 to select all physical files.

                 A minimum may  be specified in  bytes such as  100000.
                 Because   of   the  method   the   system   uses   for
                 calculating  size,  it  is  possible that  some  files
                 will  appear that are slightly  less than the minimum.

   FLAG          Whether to  flag  certain conditions.   *NONE  is  the
                 default to bypass any flagging.

                 *ALWDUPKEY  may  be  entered  to flag  any  data  base
                 networks  where neither the  physical or any dependent
                 logical files prevent duplicate keys.


You must have *USE authority to the files.


The following TAA Tools must be on your system:

     CHKGENERC       Check generic
     EDTVAR          Edit variable
     RTVDBFA         Retrieve data base file attributes
     RTVSYSVAL3      Retrieve system value 3
     SNDCOMPMSG      Send completion message
     SNDESCMSG       Send escape message
     SNDSTSMSG       Send status message


None, the tool is ready to use.

Objects used by the tool

   Object        Type    Attribute      Src member    Src file
   ------        ----    ---------      ----------    ----------

   PRTDBFSIZ     *CMD                   TAADBJH       QATTCMD
   TAADBJHC      *PGM       CLP         TAADBJHC      QATTCL
   TAADBJHC2     *PGM       CLP         TAADBJHC2     QATTCL
   TAADBJHR      *PGM       RPG         TAADBJHR      QATTRPG

Added to TAA Productivity tools February 28, 2000

Home Page Up to Top