If you are creating, moving and deleting document library objects you are bound to accumulate a lot of documents that do not belong to any folder. I refer to them as unassigned documents. These documents belonging to folder *NONE occupy a lot of space on the disk. You can perform the following steps to identify and delete such documents:
Display all unclaimed documents to a physical file:
QRYDOCLIB FLR(*NONE) OUTFILE(QTEMP/DOCPF)
Print a list of all such documents in owner and size order:
SELECT QDLUID, QDLONM, QDLDNM, QDLDSZ, QDLFLR FROM QTEMP/DOCPF ORDER BY QDLUID, QDLDSZ, QDLDNM, QDLFLR, QDLONM
Save all such documents to a save file:
SAVDLO DLO(*SEARCH) FLR(*NONE) DEV(*SAVF) SRCHTYPE(*DOC)
010190)) OWNER(*ALL) SAVF(QTEMP/SAVDLO) OUTPUT(*PRINT)
Save the save file to a tape for future retrieval.
Delete the unclaimed documents created by a specific owner by using following command:
DLTDLO DLO(*SEARCH) CRTDATE((000000 010190)) OWNER(owner-name)
- I'd use the following command to delete documents found using this tip: DLTDLO DLO(*SYSOBJNAM) SYSOBJNAM('DLO_ObjectName') & ;Kenneth Graap, Search400.com site expert
- Concerning the number of unassigned or folderless objects in QDOC. The QRYDOCLIB command itself can also generate an unassigned or folderless document in QDOC. The QRYDOCLIB CL command as a default (via the DOCL parameter) generates a document list that is stored in QDOC as a folderless document. The document list is owned by the user using the QRYDOCLIB command and will be re-used for the next QRYDOCLIB unless a new name is specified in parameter DOCL other than *DFT. A user can override the default by setting parameter DOCL to *NONE in the QRYDOCLIB command. For example: QRYDOCLIB FLR(*NONE) OUTFILE(qtemp/docfile) DOCL(*NONE). This command would return a list of folderless documents into an outfile without creating another folderless document in QDOC. It would be possible to generate a lot of folderless documents in a big hurry by using the QRYDOCLIB CL command and specifying DOCL(DOCLSTx) where x is some changing value. Each time QRYDOCLIB is called a new folderless document list would be generated in QDOC. Dale Erickson
MORE INFORMATION ON THIS TOPIC
The Best Web Links: Tips, tutorials and more.
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
Read this Search400.com Featured Topic: Managing your iSeries.
Ask the Experts yourself: Our systems management gurus are waiting to answer your technical questions.