Configuring Aleph 21 for ARC 3.0, z900 triggers
- Article Type: Q&A
- Product: Aleph
- Product Version: 21
Question
We seem to already have the Z900 Oracle table set up with the Aleph installation.
But the triggers are not defined in the file_list definitions as they should be according to Appendix C of the Aleph Configuration for ARC3 document. Is this correct?
How can we check if the trigger list is complete?
Answer
The triggers are already defined in the default file_list for ADM libraries and can be seen in the merged file list.
You can check the merged file list definitions by using
util a/17/10/2
e.g.
A.17.10. Edit file_list of XXX50 Tables
0. Exit Procedure
1. Edit file_list of XXX50
2. View merged file_list
[...]
TRI z76_trigger_1
TRI z601_trigger_1
TRI z31_trigger_1
TRI z77_trigger_1
TRI z30_trigger_1
TRI z30h_trigger_1
TRI z36_trigger_1
TRI z36h_trigger_1
TRI z37_trigger_1
TRI z20_trigger_1
TRI z68_trigger_1
TRI z16_trigger_1
TRI z501_trigger_1
TRI z70_trigger_1
TRI z08_trigger_1
TRI z38_trigger_1
TRI z309_trigger_1
TRI z78_trigger_1
TRI z305_trigger_1
TRI z13_trigger_1
The trigger status can be checked in util a/17/6/4 Show Trigger Status
A.17.6. Manage Triggers in XXX50
1. Create/Recreate Library Triggers
2. Enable Trigger
3. Disable Trigger
4. Show Trigger Status
Please select [exit]: 4
SQL*Plus: Release 11.2.0.3.0 Production on Thu Nov 7 13:49:01 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
aleph_admin@ALEPH21> aleph_admin@ALEPH21> aleph_admin@ALEPH21> 2 3 4
TRIGGER_NAME TABLE_NAME STATUS
------------------------------ ------------------------------ --------
Z08_TRIGGER_1 Z08 ENABLED
Z105H_TRIGGER Z105 ENABLED
Z16_TRIGGER_1 Z16 ENABLED
Z20_TRIGGER_1 Z20 ENABLED
Z303_TRIGGER_1 Z303 ENABLED
Z304_TRIGGER_1 Z304 ENABLED
Z305_TRIGGER_1 Z305 ENABLED
Z308_TRIGGER_1 Z308 ENABLED
Z309_TRIGGER_1 Z309 ENABLED
Z30H_TRIGGER_1 Z30H ENABLED
Z30_TRIGGER_1 Z30 ENABLED
TRIGGER_NAME TABLE_NAME STATUS
------------------------------ ------------------------------ --------
Z31_TRIGGER_1 Z31 ENABLED
Z36H_TRIGGER_1 Z36H ENABLED
Z36_TRIGGER_1 Z36 ENABLED
Z37_TRIGGER_1 Z37 ENABLED
Z38_TRIGGER_1 Z38 ENABLED
Z501_TRIGGER_1 Z501 ENABLED
Z601_TRIGGER_1 Z601 ENABLED
Z68_TRIGGER_1 Z68 ENABLED
Z70_TRIGGER_1 Z70 ENABLED
Z76_TRIGGER_1 Z76 ENABLED
Z77_TRIGGER_1 Z77 ENABLED
TRIGGER_NAME TABLE_NAME STATUS
------------------------------ ------------------------------ --------
Z78_TRIGGER_1 Z78 ENABLED
aleph_admin@ALEPH21> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options