Hi,
DB2 V8.2 ON WINDOWN2003

Can someone help on this issue pls?

Since we have implemented the HADR, one of the weekly MIS application running very very slowley. Normaly takes 8 hours to run. But this week it took over 14 hours and still running.
Appart from this application no one logged on to the system.
I have checked the locks , applications snapshot and i could not find any thing.
This application creates lots of temp tables and does export and import too. I have noticed it has produced over 500 transaction logs and each logs size is 10mb.

Is it possible that the HADR is slowing down this applications? how can i trouble shoot this further?
Please post your comments. Thanks.
Dgunas

It could, if HADR_SYNCMODE were set to SYNC.
Check the database configuration.

Thanks Nick.
It has been set to NEAR SYNC.

DB CFG looks ok. any specific parameter ?

Regards, Dgunas

Set the HADR_SYNCMODE = ASYNC
I am suspecting you have a slow tcpip network; with near sync, primary database has to receive acknowledgement from the standby system that the logs have also been written to main memory on the standby system;

ASYNC:
In this mode, log writes are considered successful when they
have been delivered to the TCP layer of the primary system’s host
machine. Because the primary system does not wait for acknowledgement
from the standby system, transactions might be considered committed
when they are still on their way to the standby.
A slow network would explain the extra 6 or more hours using HADR.