Problem solve Get help with specific problems with your technologies, process and projects.

Delete unassigned documents from QDOC library

Display all unclaimed documents to a physical file.

You Can View User Feedback To This Tip

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:

STRSQL

SELECT QDLUID, QDLONM, QDLDNM, QDLDSZ, QDLFLR FROM QTEMP/DOCPF ORDER BY QDLUID, QDLDSZ, QDLDNM, QDLFLR, QDLONM

Save all such documents to a save file:

CRTSAVF FILE(QTEMP/SAVDLO)

SAVDLO DLO(*SEARCH) FLR(*NONE) DEV(*SAVF) SRCHTYPE(*DOC)
CRTDATE((000000
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)

USER FEEDBACK TO THIS TIP

  • 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.


This was last published in November 2003

Dig Deeper on Performance

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close