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.


Dig Deeper on Performance

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close