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

    ETL (p_arc_01): locking or not locking?

    • Product: Aleph

    Question

    When running an ETL process (p_arc_1) you can either choose to lock or not to lock the ADM library.

    What implications do both choices have?

    Answer

    It is recommended to run the ETL outside the working hours (with locked library) to have consistent data.
    If this is not possible - e.g. due to long working hours - you might consider to run the process during the working hours (with unlocked library).

    The inconsistency might contain data in one table referencing data in a different table that was not created when the table is extracted.

    Additional Information

    Example: if you create a new bibliographic record with items and the bibliographic table was already extracted at this point, it might happen, that the extracted items are pointing to a non-existent bibliographic record.
    This situation should resolve itself during the next ETL though.

    Category: ETL (ARC)/ARC

    Subject: ARC


    • Article last edited: 2/19/2014