Help in contention of DB2 table between CICS and batch progr

RobinPatil · Post by **RobinPatil** » Thu May 21, 2015 11:59 am

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?

Post by **zprogrammer** » Thu May 21, 2015 3:09 pm

Are you doing frequent commits in your CICS program?

RobinPatil · Post by **RobinPatil** » Fri May 22, 2015 2:19 pm

Yes, we are doing frequent commits.

RobinPatil · Post by **RobinPatil** » Thu Jun 04, 2015 8:50 pm

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

Post by **Anuj Dhawan** » Mon Jun 08, 2015 2:59 pm

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.

Post by **zprogrammer** » Mon Jun 08, 2015 3:05 pm

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

Mainframe, MVS and zOS Discussion

Help in contention of DB2 table between CICS and batch progr

Help in contention of DB2 table between CICS and batch progr

Re: Help in contention of DB2 table between CICS and batch p

Re: Help in contention of DB2 table between CICS and batch p

Re: Help in contention of DB2 table between CICS and batch p

Re: Help in contention of DB2 table between CICS and batch p

Re: Help in contention of DB2 table between CICS and batch p

Create an account or sign in to join the discussion

Create an account

Sign in