PRTDBFSIZ Print Data Base File Size

PRTDBFSIZ PRINT DATA BASE FILE SIZE TAADBJH
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. Restrictions ------------ You must have *USE authority to the files. Prerequisites ------------- 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 Implementation -------------- 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


PRTDBFSIZ PRINT DATA BASE FILE SIZE TAADBJH
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. Restrictions ------------ You must have USE authority to the files. Prerequisites ------------- 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 Implementation -------------- 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

Last modified on July 15, 2010