TAA Tools
DSPDBFSTAT      DISPLAY DATA BASE FILE STATISTICS      TAADBLH

The  Display   Data  Base  File   Statistics  command   displays  usage
statistics  for a physical  file data  member.  Each  dependent logical
file  is also shown.   The system  data base statistics  are used which
are reset at each IPL.

A typical command would be:

             DSPDBFSTAT    FILE(xxx)

The usage  statistics of  the file would  be displayed  along with  the
number of records  in the first member of  any dependent logical files.

DSPDBFSTAT escape messages you can monitor for
----------------------------------------------

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

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

   FILE          The  qualified   name  of  the  physical  file  to  be
                 displayed.   The  library  value  defaults  to  *LIBL.
                 *CURLIB or a specific library may also be used.

   MBR           The member to  be considered.  *FIRST  is the default.
                 A specific member name may be entered.

                 Only  the first member  on any  dependent logical file
                 is considered.

   OUTPUT        How to  output  the results.    * is  the  default  to
                 display the  spooled file  if the  command is  entered
                 interactively.   The spooled file is  deleted after it
                 is displayed.

                 If  the  command  is  entered in  batch  or  *PRINT is
                 specified, the  spooled file  is output and  retained.

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

The file must be a physical file data type (not a source type).

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

The following TAA Tools must be on your system:

     CHKOBJ3         Check object 3
     RSNLSTMSG       Resend last message
     RTVDBFA         Retrieve data base file attributes
     RTVDBR          Retrieve data base file relations
     RTVMBRSTAT      Retrieve member statistics
     RTVSYSVAL3      Retrieve system value 3
     SNDCOMPMSG      Send completion message
     SNDESCINF       Send escape information
     SNDESCMSG       Send escape message

Implementation
--------------

None, the tool is ready to use.

Objects used by the tool
------------------------

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

   DSPDBFSTAT    *CMD                   TAADBLH       QATTCMD
   TAADBLHC      *PGM       CLP         TAADBLHC      QATTCL
   TAADBLHC2     *PGM       CLP         TAADBLHC2     QATTCL
   TAADBLHR      *PGM       RPG         TAADBLHR      QATTRPG
					

Added to TAA Productivity tools September 15, 2006


Home Page Up to Top