Hi,

DB2 V9.5 FP5 , OS : AIX 6.1

We have setup HADR on it. HADR_MODE : ASYNC.
We noticed that when standby goes down everything work properly on primary. but once we restart primary database then we are not allowed to connect to database until and unless either we force start HADR on primary or we shut down HADR on primary.

Is there any mode or any way so that we can avoid this behaviour??

but once we restart primary database : you mean activate ?
what is going down on standby : instance - hadr ??

Yes i mean activate. i.e when u try to connect to db.

SAN @standby went down.

can you specify in more detail the timing of the events as
We noticed that when standby goes down everything work properly on primary. but once we restart primary database..
this is not very clear : standby down-primary restarted ??

1) We had a HADR setup. and it was working fine.
2) One day accidently SAN @standby went down. and we didnt came to know about this.
3) Every day from 2 AM to 7 AM we get a maintainance window in which we take cold backup of database. and other teams take system backup.
4) At time of cold backup we deactivate database. all this maintainance is done by scripts.
5) Next day users were not able to connect to database.
6) So for that period of time we have shut down HADR and everything started working properly.

Later we did UAT and came to know that if u r standby is down and primary is active then it will not create any impact on primary. But once primary is deactivated (when standby is not available) then to activae primary next time either we have to shut down HADR or force start primary in HADR environment.

When the primary server is first started, it waits for the standby server to contact it. If the standby server does not make contact with the primary after a specific period of time(HADR_TIMEOUT), HADR will not start.

usually you start first hadr on standby (listener) and next the primary that will connect to primary.. if connection is lost (after timeout) hadr is disconnected..
when connection is available hadr will restart again
check status before doing anything db2pd -d xxx -hadr
we monitor all the time the status.. and ship mail if disconnected..