Application hangs while symultaneously running two instances of client on DB2

[Vidyaranya]

I am facing one problem w.r.t DB2,

When i launch my first instance of my client exe.
(written using Delphi 7)
and perform an action on Table A. (one of the row is in Transaction mode)
waits for response from say 5 mins.

Depending upon response system will commit/Rollback transaction.

In this situation, Symultaneously if i launch my second instance of same
client and try to read-only access of Table

A, System will simply haungs until first one gets commited.

Is any body help me to overcome this problem?
I cannot use setting of locktimeout property, because in first instatnce
i need to wait till i get any sort of response.
One DB2 Interface program which calls internally.)

For second instance of my client should works like normal application
without delay.
My question is how to share those uncommited rows across the user.
(Read only access for other delphi instances)
Thanks
Vidyaranya MV

[Mark Yudkin]

Either commit (first instance) or use dirty read (second instance).
Otherwise, consistency considerations require the current behaviour.

"Vidyaranya" <vi***********@hotmail.com> wrote in message
news:9a**************************@posting.google.c om...

I am facing one problem w.r.t DB2,

When i launch my first instance of my client exe.
(written using Delphi 7)
and perform an action on Table A. (one of the row is in Transaction mode)
waits for response from say 5 mins.

Depending upon response system will commit/Rollback transaction.

In this situation, Symultaneously if i launch my second instance of same
client and try to read-only access of Table

A, System will simply haungs until first one gets commited.

Is any body help me to overcome this problem?
I cannot use setting of locktimeout property, because in first instatnce
i need to wait till i get any sort of response.
One DB2 Interface program which calls internally.)

For second instance of my client should works like normal application
without delay.
My question is how to share those uncommited rows across the user.
(Read only access for other delphi instances)
Thanks
Vidyaranya MV