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. Incremental ETL duration too long

    Incremental ETL duration too long

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Problem Symptoms:
    2. Cause:
    3. Resolution:
    4. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 2

    Problem Symptoms:

    * the incremental ETL takes several hours and takes almost as long as the full ETL

    Cause:

    Configuration of ./xxx50/tab/arc_conf_table.conf

    Resolution:


    In order to reduce the duration for the ETL load, reduce the amount of data included into the load.
    Check / Correct the settings of table .xxx50tabarc_conf_table.conf to include less data:

    [ARC HISTORY]       period for all history files (z30h, z36h, z37h)
    [OPAC]                       period for OPAC events (z69)
    [EVENTS]                  period for events (z35)



    Example for configuration including all (history) data since 01.01.2010
    ./xxx50/tab/arc_conf_table.conf

    [ARC HISTORY]
    2010
    [OPAC]
    20100101
    [EVENTS]
    20100101

    Additional Information

    In ARC 2.0 the Incremental Load differs from the Full Load only this way, that the events (z35) and OPAC events (z69) are loaded incremental. All other files are fully loaded during ETL.

    Starting with ARC 3.0 / Aleph 21 a Full Complete Incremental Load is available.

    For details please see ALEPH Configuration for ARC 3.0.pdf

     

    The following additional options are available starting with ARC 3.0:

     

    [PATRON-DATA]
    eliminate_data=N

    [CIRC-LOGGER]

    from date = 20070101

     

     

     

     


    • Article last edited: 06-Feb-2017
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Increasing number of WWW server handlers (www_server child processes)
      • Indentifying ADM library for NCIP client using https transport
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 2
      2. contype:kba
      3. ETL (ARC)
      4. Prod:Aleph
      5. 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