Mainframe, MVS and zOS Discussion

Hi,

While the CICS is up, one of the other batch program unloads DB2 table (Table x) . The job executing the batch program abends as the CICS Listener is holding the table. To resolve it, we have added "WITH UR" in the SQL query in the online program bound it with ISOLATION LEVEL = UR but this did not help. Can someple please help?

Are you doing frequent commits in your CICS program?

Yes, we are doing frequent commits.

We played more around the coomit/commit-frequency but it does nt seem to help...could you please help with some more suggestions?

RobinPatil wrote:We played more around the coomit/commit-frequency but it does nt seem to help...could you please help with some more suggestions?

Try issuing 'SYNCPOINT' before the RETURN in the CICS program ans see if this helps.

Also sit with your DBA to analyze on the LOCKSIZE in Tablesapce