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

    Maintenance and monitoring during large-scale data changes and updates

    • Product: Voyager, Alma
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

    Question

    • We are preparing our Voyager data for Alma and will be making large-scale updates to our records.
    • We are making a large amount of updates to our bibs before sending them to a vendor for processing.

    What maintenance and monitoring should we do in Voyager while we're making these massive changes?

    Answer

    There are a few considerations when doing heavy data change work on your Voyager database.

    Oracle archive logs
    Considerations

    Every update to the database writes to an Oracle log. When making large quantities of changes, these logs can become quite large and fill up disk space.

    Best practices
    • Before engaging in a major data change/update process, test a subset of records. For example,
      1. Identify a set of records that represents 5-10% of the total number of records to be updated.
      2. Check the current available disk space.
      3. Process the record change as you intend to for the full set.
      4. Check the disk space available when the update/change is complete. This will give a sense of how much space is required for the full set/for every change of the size tested.
    • Some sites with a large number of bibs or a large number of Voyager xxxdb instances may need Oracle tuning. Contact Support if your institution falls into this category.
    Keyword indexing
    Considerations

    Every update to a bibliographic or holdings record writes to the dynamic.dc file in /m1/voyager/xxxdb/data (for bibs) or /m1/voyager/xxxdb/mfhd.data (for holdings). The more updates are made, the larger the files grow. There are two impacts of this behavior:

    • As the file grows, the speed of keyword indexing slows, making jobs/processes that update the file take longer and longer.
    • If left unmonitored, the file can reach its max size of 2.0 GB, and can no longer be written to at that point, meaning records can no longer be saved/updated until a regen is run.
    Best practices

    • Article last edited: 19-Sep-2018