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

    How to delete bib and associated records?


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


    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?


    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 ****


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


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


    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
    • Was this article helpful?