What is Pre-online and Post-online triggers

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

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.