Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. How to delete bib and associated records?

    How to delete bib and associated records?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Description:
    Our staff needs help deleting Bib and associated records. Sys number is 619108. Hundreds of HOLs are attached and thousands of items. I want to delete the whole thing and start over. There are double links for many of the individual titles which causes searching to slow down or fail - I want to clean these up. ADM=368609 one HOL is=438725

    In trying to do this myself, I went into ABC60 and looked for HOL#438725 – it had 8259 items attached – I deleted the HOL from the server and then used SQL to delete the barcodes (using z30_hol_doc_number_x to locate the relevant items).  8259 rows were deleted .

    But there are still lots of HOLs with just one item underneath – just don’t want to repeat that process over and over – I also don’t wish to delete the item and then the HOL for each one in Aleph GUI either

    If I try to bring up the sys number, I get a timeout -- even with the timeout changed to 600. So I deleted the LKR fields from the bib and tried to save – it didn’t come back and tell me it was completed cuz Aleph timed out at 600. But now whenever I look at sys #619108, the LRK fields are gone

    Anyway, is there some SQL that acts like the Total Delete and can remove BIB, HOL and ITEMs all at once or at the very least, an SQL that deletes all the items, the all the HOLs and then the BIB? Are there other options?

     

    Resolution:
    The z103 links in the bib and HOL libraries are reciprocal. The following SQL indicates that the links seem to be OK (or at least they are the same in both):

    SQL-XXX01> select count(*) from z103 where z103_rec_key_1 like 'XXX01000619108%' and z103_lkr_library = 'XXX60';
    **** Hit return to continue ****

    COUNT(*)
    ----------
    1285

    SQL-XXX60> select count(*) from z103 where z103_rec_key_1 like 'XXX01000619108%' and z103_lkr_library = 'XXX60';
    **** Hit return to continue ****

    COUNT(*)
    ----------
    1285

    So you should be able to run p_manage_33 to delete these. The input records would look like this:

    000619108XXX01

    You would need to decide what BATCH-DELETE lines you want to have in the ./xxx01/tab/check_doc file. This is described in the article "Delete BIB Recs Incl. Related ADM/HOL Recs (manage-33): BATCH-DELETE lines"  (KB 5726). In order to delete the HOL records, at least the check_doc_delete_lkr line would need to be commented out.

     

     


    • Article last edited: 12-Mar-2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How to delete ADM records with no BIB records
      • How to delete bib, item, and HOL records **MASTER RECORD**
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved