Troubleshooting
Problem
Using QRYDOCLIB to determine the number and size of documents (DLOs) on the system.
Resolving The Problem
The QDOC Library has 8500 Folders/Documents. The DASD space used is 510 Megabytes. This is not a heavily used system. What is happening? How can this be cleaned up? Running RGZDLO DLO(*ALL) FLR(*ANY) reorganized 1700 objects and freed 800K.
The best way to determine what is actually in the QDOC library and what documents/folders may be candidates for purging or taking off-line may be to use the QRYDOCLIB command and IBM OS/400 or IBM i5/OS Query or interactive SQL to produce a report showing Folder Name, Document Name, Document Size, and so on.
Use the QRYDOCLIB FLR(*ALL) OUTFILE(YourLib/YourFile) command to produce a database file in any library. Then a query tool can be used (for example, the ACS Run SQL Scripts product) to select the fields, sort, and format the report to meet your requirements. The record layout can be obtained by running: DSPFFD FILE(YourLib/YourFile)
For example:
The best way to determine what is actually in the QDOC library and what documents/folders may be candidates for purging or taking off-line may be to use the QRYDOCLIB command and IBM OS/400 or IBM i5/OS Query or interactive SQL to produce a report showing Folder Name, Document Name, Document Size, and so on.
Use the QRYDOCLIB FLR(*ALL) OUTFILE(YourLib/YourFile) command to produce a database file in any library. Then a query tool can be used (for example, the ACS Run SQL Scripts product) to select the fields, sort, and format the report to meet your requirements. The record layout can be obtained by running: DSPFFD FILE(YourLib/YourFile)
For example:
select * from YourLib.YourFile order by QDLDSZ;
Using the report produced by Query, you should be able to determine what can be purged to free up space on the system.
All of the IBM-supplied folders begin with the letter Q. The WRKFLR command will show them to you. The QIWS*, QPWX*, QRUMBA*, and QWIN* folders are part of Client Access. Others could be part of CODE/400, or other IBM products.
One technique is to create a result field in the query where the substr(flrnam,1,1) function is used to create a new field. Then, a record select statement QFLR *NE 'Q' is added. (QFLR is the result field.) This eliminates all the Q documents and folders from the report.
Using the report produced by Query, you should be able to determine what can be purged to free up space on the system.
All of the IBM-supplied folders begin with the letter Q. The WRKFLR command will show them to you. The QIWS*, QPWX*, QRUMBA*, and QWIN* folders are part of Client Access. Others could be part of CODE/400, or other IBM products.
One technique is to create a result field in the query where the substr(flrnam,1,1) function is used to create a new field. Then, a record select statement QFLR *NE 'Q' is added. (QFLR is the result field.) This eliminates all the Q documents and folders from the report.
[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001jCPAAY","label":"Integrated File System->QDLS"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
13 September 2021
UID
nas8N1019950