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

    Huge z105h table; ue_11 logs

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Problem Symptoms:
    * z105h table (Messages between libraries -History ) in xxxnn <where "xxxnn" is the $z105_library> has more than 100 million records.

    * multi-Gigabyte run_e_11 logs in the xxxnn $data_scratch directory

    Cause:
    xxxnn Z105H_TRIGGER is enabled. {As described in KB 8192-5047 (What is the z105h table?) z105h is not needed by North American sites.}

    Resolution:
    1. dlib xxxnn

    2. util a/17/6/3 (Disable trigger) to disable the Z105H_TRIGGER.

    3. util a/17/1 (Drop & Create Table) for z105h

    4. util e/12 (Stop Messaging Update)
    5. util e/11 (Start Messaging Update)

    6. cd $data_scratch
    7. delete old run_e_11 logs

    Category: System Management (500)

    Subject: Oracle (500)

    • Article last edited: 10/8/2013