Q:

What is Pre-online and Post-online triggers

what is pre-online and post-online triggers?i am not really sure.
i am using for failover management of DB2 9.7 and i need to used pre-online and post-online scripts. Any help would be apperciated.

A:

It appears that those terms refer to part of DB2's support for Microsoft Failover Clustering Support.  From the Publib (there is more information on that page):

Pre-online and post-online scripts 
You can run scripts both before and
  after a DB2 resource is brought online. These scripts are referred to
  as pre-online and post-online scripts respectively. Pre-online and
  post-online scripts are .BAT files that can run DB2 and system
  commands.
In a situation when multiple instances of DB2 might be running on the
  same machine, you can use the pre-online and post-online scripts to
  adjust the configuration so that both instances can be started
  successfully. In the event of a failover, you can use the post-online
  script to perform manual database recovery. Post-online script can
  also be used to start any applications or services that depend on DB2.

Here is a whitepaper on implementing such scripts, but it's a little older (created for UDB v8.1, which is well out of support), but maybe it will give you something to start from.  The scripts are described starting on page 34.

