Start of changeCICS VSAM Transparency for z/OS, Version 1.2


Adding SQL commit calls

Existing application programs that perform many updates may cause DB2® locking issues.

The only way to reduce the number of concurrently locked pages in DB2 is to issue SQL COMMIT calls. If you encounter locking issues, you may have to consider changing your application programs.

The least disruptive way to do this is to code a new program that simply issues a COMMIT. Code this program to uses either the DB2 remote recovery services attachment (RRSCAF) or the call attach facility (CAF). Instructions for both methods are in the appropriate DB2 manual. Add code to the long-running update programs to call the new module.

Bind the DBRM from the commit program into the same collection as the CICS® VT DDM driver.

Be aware of the following considerations:

Using this technique is only appropriate if your long running batch programs only update VSAM files. It is not appropriate if other resources such as DB2 or MQSeries are involved.



Concept topic


Last updated: May 25, 2012 20:43:52
End of change