I have a procedure updating a set of 4 tables from a client. At the same time, i have 4 users connected to the database who would like to access data for select from those sametables. But my users complain that the tables remain locked till the above procedure completes. I'm new to DB2 databases. Could someone suggest me how to avoid this locking and let other users Select the data, atleast.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Locking problem in DB2...
- Thread starter GDB2
- Start date
Similar threads
- Locked
- Question