[NEWSboard IBMi Forum]

Hybrid View

  1. #1
    Registriert seit
    May 2002
    Beiträge
    2.643

    SQL

    Hallo,
    vielleicht kannst Du damit was anfangen:

    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

  2. #2
    Registriert seit
    Jul 2002
    Beiträge
    11
    Danke, ich werde wohl die manuelle Version wählen, da sich doch das ein oder ander wichtige Dokument versteckt hat.

Similar Threads

  1. Papierende am Drucker, Kein i zum eingeben
    By schubdigeige in forum NEWSboard Drucker
    Antworten: 4
    Letzter Beitrag: 12-10-06, 06:27
  2. CPYTOIMPF - Leerzeichen am Ende?
    By mott in forum NEWSboard Programmierung
    Antworten: 2
    Letzter Beitrag: 09-10-06, 11:28
  3. COMMON AWK München am 14.09.2006
    By holgerscherer in forum Archiv NEWSboard Events
    Antworten: 0
    Letzter Beitrag: 03-08-06, 11:39
  4. Hochverfügbarkeits-Symposium bei ALCO am 16.05.2006
    By Kirsten Steer in forum Archiv NEWSboard Events
    Antworten: 0
    Letzter Beitrag: 25-04-06, 13:37
  5. ADDJOBSCDE am 5. des Monats
    By linguin in forum IBM i Hauptforum
    Antworten: 1
    Letzter Beitrag: 02-12-05, 12:59

Berechtigungen

  • Neue Themen erstellen: Nein
  • Themen beantworten: Nein
  • You may not post attachments
  • You may not edit your posts
  •