In my application, an unload job runs on a DB2 table, say Table A while the CICS is up. This job is abending since the CICS Listener (which uses Table A for authorization) is holding it. The SQL query within the online program has 'WITH UR' and its also bound with a ISOLATION LEVEL = UR. The problem still exists.
Everytime I am bringing down the production region.
Can anyone help?
I need the CICS region up while this job is running. Bringing down the region is a temporary solution. I want to see to it that I give a premanent solution.
Guys, I solved the issue. I coded a 'SYNCPOINT' just before the RETURN in the online program. This took care of releasing the resources immediately and the job ran fine.