Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Deleting "ghost" items in the z30 table

    • Article Type: Q&A
    • Product: Aleph
    • Product Version: 20

    Question

    XXX50 z30 (Item) record 000012345000010, with z30_barcode "barcode" does not appear to be linked to any bib or hol record, and can't be pulled up in any client. Can it be deleted?

    Answer

    Yes, it can be deleted.

    1. Do:

    dlib xxx50
    util f/4

    enter file name (or q to exit) doc

    ENTER DOC NUMBER: 000012345

    If you find that there is no ADM doc record for this z30 key, then, definitely, you can and should delete this z30 via SQL.

    2. If there *is* an ADM doc record 000012345, then do:

    util a/3/12

    ENTER HOME LIBRARY : xxx50
    ENTER DOC-NUMBER : 000012345

    If no links are displayed, the ADM can and should be deleted in the GUI. This will also delete the item record.

    Category: System Management (500)

    Subject: Oracle (500)


    • Article last edited: 10/8/2013