IBM Support

Adding custom primary only triggers to the failover/failback procedures

Question & Answer


Question

ActingPrimary : How are custom primary only triggers implemented?

Cause

Custom triggers are not part of the primary_only trigger group but are primary only triggers

Answer

If custom triggers are implemented that can only run on the primary object server, and are not part of the primary_only trigger group, then these can be put in a custom trigger group for primary only triggers and this group added to the automation_disable and automation_enable procedures.

For example if the custom trigger group is called 'custom_primary_only' then the two procedures can be modified as:


------------------------------------------------------------------------
-- Signal triggers: gateway_triggers
------------------------------------------------------------------------
create or replace procedure automation_disable()
begin

-- Disable the automations that should not be
-- running when it is a backup ObjectServer
for each row tg in catalog.triggers where
tg.GroupName IN ( 'primary_only' , 'custom_primary_only' )
begin
alter trigger group tg.GroupName set enabled false;
end;
end;
go

create or replace procedure automation_enable()
begin

-- Enable the automations that should be
-- running when it is a primary ObjectServer
for each row tg in catalog.triggers where
tg.GroupName IN ( 'primary_only' , 'custom_primary_only' )
begin
alter trigger group tg.GroupName set enabled true;
end;
end;
go

[{"Product":{"code":"SSSHTQ","label":"Tivoli Netcool\/OMNIbus"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.4.0;7.3.1;7.3.0;8.1.0","Edition":"Edition Independent","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
17 June 2018

UID

swg21641949