TAA Tools

The Display  Empty  Data Base  File command  displays  data base  files
that have  no members.   A flag may  be set if  the data base  file has
not  been used in the last  n days.  An option  exists to list all data
base files.  DSPEMTDBF can  be helpful in cleaning up unused  data base

You  must have  *ALLOBJ special  authority to  use a  library  value of

See the DSPEMTMBR command to display the members that have no data.

A typical command would be:


All data  base files in library ABC that  do not have any members would
be listed.  Any  data base files  that have not  been used in the  last
100 days would be flagged.

DSPEMTDBF escape messages you can monitor for

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

DSPEMTDBF Command parameters                          *CMD

   FILE          The  qualified  name  of  the data  base  file  to  be
                 processed.   A  single file,  a  generic name,  or the
                 special value *ALL may be entered.

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

   FLAGDAYS      The number  of days to  flag the data base  file if it
                 has  not been changed.   The default is  60 days.  The
                 value must be in a range of 0-999.

                 A data  base file  is considered changed  if a  member
                 is  added  or  removed.    Using a  value  provides  a
                 better indication of what is being used.

   ALLDBF        Whether  to  list all  data base  files  regardless of
                 the number of members.

                 *NO is the default to  list only data base files  with
                 no members.

                 *YES may be specified to list all data base files.

   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.


You  must  have *ALLOBJ  special authority  to use  a library  value of


The following TAA Tools must be on your system:

     ADDDAT2         Add date 2
     CHKALLOBJ       Check *ALLOBJ special authority
     EDTVAR          Edit variable
     RTVDBFA         Retrieve data base file attributes
     RTVSYSVAL3      Retrieve system value 3
     SNDCOMPMSG      Send completion message
     SNDESCINF       Send escape information
     SNDESCMSG       Send escape message


None, the tool is ready to use.

Objects used by the tool

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

   DSPEMTDBF     *CMD                   TAADBMZ       QATTCMD
   TAADBMZC      *PGM       CLP         TAADBMZC      QATTCL
   TAADBMZR      *PGM       RPG         TAADBMZR      QATTRPG

Added to TAA Productivity tools October 15, 2010

Home Page Up to Top