• Article Type: General
• Product: Aleph
• Product Version: 15.5

Description:
How is z127 in the Union Catalog created?

Resolution:
1. Z127 should be created only for the first time after z120 is created (i.e. after p_union_02 was run for the first time).
To create Z127 and save it to memory, run create_z127 and load_z127_to_mem. When you are running these two jobs, ue_01 should not be running and the Z127 update trigger should be disabled. Once the jobs have completed successfully, make sure the Z127 update trigger is activated before updates are done to the database so that all such updates will be made to Z127 by the trigger.

2. Any further update of Z120 (new, delete, update) will update also Z127 by the Oracle trigger mechanism. Therefore trigger should be active all the time.

3. There is no need to re-run load_z127_to_mem after Oracle down or restarted.