Contention for db2table between CICS program and batch prog

CHALLY · New User Joined: 07 Jul 2006 Posts: 4 Location: Texas

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?

raghunathns

first stop
-STOP DATABASE(dbname) SPACE(tspace)
run ur job
issue start
-START DATABASE(dbname) SPACE(tspace) ACCESS(UT)

cics cannot access during this time. no need to down cics i believe. (try!!)

CHALLY · New User Joined: 07 Jul 2006 Posts: 4 Location: Texas

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.

CHALLY · New User Joined: 07 Jul 2006 Posts: 4 Location: Texas

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.