Help in contention of DB2 table between CICS and batch progr

Customer Information Control System. Middleware and MQ Series.
Post Reply
RobinPatil
New Member
Posts: 6
Joined: Thu Sep 04, 2014 11:25 am

Help in contention of DB2 table between CICS and batch progr

Post by RobinPatil »

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?
zprogrammer
Global Moderator
Global Moderator
Posts: 588
Joined: Wed Nov 20, 2013 11:53 am
Location: Mars

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

Post by zprogrammer »

Are you doing frequent commits in your CICS program?
zprogrammer
RobinPatil
New Member
Posts: 6
Joined: Thu Sep 04, 2014 11:25 am

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

Post by RobinPatil »

Yes, we are doing frequent commits.
RobinPatil
New Member
Posts: 6
Joined: Thu Sep 04, 2014 11:25 am

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

Post by RobinPatil »

We played more around the coomit/commit-frequency but it does nt seem to help...could you please help with some more suggestions?
User avatar
Anuj Dhawan
Founder
Posts: 2799
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Contact:
India

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

Post by Anuj Dhawan »

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.
Thanks,
Anuj

Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
zprogrammer
Global Moderator
Global Moderator
Posts: 588
Joined: Wed Nov 20, 2013 11:53 am
Location: Mars

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

Post by zprogrammer »

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

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Return to “CICS, Middleware and MQ Series.”