Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    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

    Additional Information

    See also article 'What is the z900 table?'

     

    • Article last edited: 11/26/2013
    //doorbell.io feedback widged