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 batch load mistakenly deleted item records from test server to prod

    How to batch load mistakenly deleted item records from test server to prod

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    A staff member has deleted a large number of items records in error. They still exist on our test server (which has a snapshot of the production data).

    Is there a way to extract them and load them back into production?

    Resolution:
    Either p_file_04 (with Append) or p_file_06 could be used to load a file of missing item records, but extracting them is a bit more complicated....

    I suggest this:

    On the test server:

    1. find a library which doesn't have a z30 table

    2. add z30 to the file_list

    3. use util a/17/1 to create the table

    4. use sql to copy the desired items from the abc50 z30 to the xxxnn z30

    5. use p_file_03 to export the xxxnn z30

    6. ftp the z30.seqnn from test ./xxxnn/files/ to prod ./abc50/files/

    7. use p_file_04 (with Append) or p_file_06 to load the z30.seqnn on Prod

    8. use this SQL to remove the xxxnn z30 on test:

    SQL-XXXNN> drop table z30;

    9. remove the z30 entry from the xxxnn file_list on test.

    (keywords: file-06 file_06 p-file-06 p-file-04 file_04 file-04)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How to back up tables prior to running manage-nn index jobs
      • How to be sure what instance (Test or Prod) I'm connected to with port 80?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    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