|
View previous topic :: View next topic
|
| Author |
Message |
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? |
|
| Back to top |
|
 |
raghunathns
Active User
.jpg)
Joined: 08 Dec 2005
Posts: 127
Location: rochester
|
|
|
|
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!!) |
|
| Back to top |
|
|
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. |
|
| Back to top |
|
|
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. |
|
| Back to top |
|
|
|
|
