I need a trigger when activation database occurs, or when HADR changes the active server.
Is it possible?

thanks

I can't think of a direct way to do that...

what do you want the trigger to do ?

You are aware that DB2 deactivates a database when the last connection goes away and activates it again upon the first connection - unless you have explicitly activated the database. So triggering on database activation may occur at more or less random points in time.

I'm also interested in understand what kind of action you want to perform based on this event.

Hi,
I've develop an external task manager that is outside DB2 process. This task manager is feed via IPC shared memory when triggres on TASKS table occurs.
The problem is that i need a wake-up process to the first time.
I don´t want to use JDBC drivers, because the daemon must be too light.
In my design, DB2 role must be the client, and my task manager the server.

Sorry for my english, my programs are better ;-)

Adolfo

Since you have a trigger on the TASKS table anyway, why not attempting the wake-up in that trigger already? If the process is already running, the wake-up has nothing to do.

If you actually try to implement a scheduler that executes some tasks - independent of DB2, have a look at existing solutions. You could also regularly poll whether DB2 is running.