Re: LOCKING Problem BATCH vs. Client Access
SELECTs run with UR isolation level should not affect the batch application with an exclusive lock on the table; the opposite I think is also true. In short, your solution should work.
Originally posted by magro
I have an application with a DB2 database under OS390 with monthly batch operations with Cobol programms using LOCK TABLE IN EXCLUSIVE mode.
At the same time users are accessing the database with a WINNT client software via DB2 Connect - but definitely with SELECTs only (no INSERTs, UPDATEs or DELETEs).
We cannot avoid running the batch part during daytime due to organizational reasons and we are sometimes experiencing -911s with the batch operations.
Would it help the situation if the SELECTs from the client software were generated with an appending "FOR FETCH ONLY WITH UR" ? Can the COBOL programm achieve its lock while the client access would be done like that instead of SELECTing without the "UR" part like it is done today?
"It does not work" is not a valid problem statement.