My Centura Appl. uses DB2 Connect to connect to DB2 Database, on one screen I insert in 2 tables, & update on the 3rd. But 3rd table has some problem while updating. My data gets rollbacked properly.
But If I try to Query the First Table it takes lot of time and at the end I receive Deadlock or TimeOut message.
Are there any additional settings needs to be one to AVOID TIMEOUT.

REPLY BACK.
THANKS IN ADVANCE
-MILIND

You should be able to specify the timeout in the connection string. Check your query to find out why does it takes too ling to execute so, check your query first.

mphilip

You should be able to specify the timeout in the connection string. Check your query to find out why does it takes too ling to execute so, check your query first.

mphilip

Thanks for your input, but the Query is simple with a condition.

Are there any settings to be done for DB2 Connect ?
-milind

You need to find out what is causing the lock contention.

If you fixed your rollback problem from this thread:
http://www.dbforums.com/t969209.html
please tell us what you did to fix it.