DSPEMTDBF DISPLAY EMPTY DATA BASE FILE TAADBMZ |
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
files.
You must have *ALLOBJ special authority to use a library value of
*ALL or *ALLUSR.
See the DSPEMTMBR command to display the members that have no data.
A typical command would be:
DSPEMTDBF FILE(ABC/*ALL) FLAGDAYS(100)
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
entered.
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.
Restrictions
------------
You must have *ALLOBJ special authority to use a library value of
*ALL or *ALLUSR.
Prerequisites
-------------
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
Implementation
--------------
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