• 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