View previous topic :: View next topic
|
Author |
Message |
jctgf Currently Banned Active User
Joined: 04 Nov 2006 Posts: 109
|
|
|
|
Hi,
I have a batch program in which a huge cursor is opened at the beginning of the processing and read until its end.
The entire processing may take a few hours, depending on the conditions of the machine.
After some time SOLVE abends the program claiming that are pending commits.
How could that be if the the program DOES NOT contain any update/delete/insert command at all?
If there are no pending commits, why is Solve abending the task?
How could I avoid the problem, please?
Thanks.
Joao |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
What is SOLVE? |
|
Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
|
|
Quote: |
After some time SOLVE abends the program claiming that are pending commits. |
Looks like error trapped in program and above message is shown..
what is abend code you are getting?
Can you show us spool error messages with codes? |
|
Back to top |
|
|
jctgf Currently Banned Active User
Joined: 04 Nov 2006 Posts: 109
|
|
|
|
Solve is a software that runs on MVS or Z/OS. I'm not sure if it's from IBM or CA.
I can't say precisely what it is. It seems to have many features and functions. I've just made an extensive search on the Web but couldn't find anything about it.
It kind of monitors if there are uncommitted changes on the data base and aborts the task if it's taking too long for these pages to get committed.
For example, if you run a batch program that updates a row of the table at the beginning of the processing and takes too long to commit this row, Solve may abend your program because of it.
In my case, there is absolutely no update/insert/delete on any the table, at all.
Joao |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
The vendor of SOLVE should be able to provide documentation for its product to any licensed customer to help interpret error messages. As Sambhaji has requested, what are the error messages and codes. Please post any relevant information. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Might the product be "Resolve"?
Long ago there was a monitoring/trouble-shooting product from Boole and Babbage called "resolve". More recently, BMC has a "resolve":
www.networkworld.com/news/1999/0826bmc.html
Suggest you talk with your local people who support the product for info on which product is in use as well as the name of the vendor. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Joao,
there used to be a sticky in this forum containing some articles about commiting - keyword - JOYS of COMMITing -
but some fool decided to delete them.
oh well, take my word for it,
even with a READ-ONLY cursor,
there are locks issued
that you should release periodically during your processing via a commit.
you have outstanding commits and your tool indcates as such.
put in some periodic commits. |
|
Back to top |
|
|
ovreddy
Active User
Joined: 06 Dec 2004 Posts: 211 Location: Keane Inc., Minneapolis USA.
|
|
|
|
Hi,
Define cusror WITH UR (Uncommitted Read) this will prevent the cursor holding locks against the database. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
ovreddy wrote: |
Define cusror WITH UR (Uncommitted Read) this will prevent the cursor holding locks against the database |
ovreddy,
since this week i am a nice guy, I will only suggest that you RTFM.
To everybody else:
What ovreddy said is BS! |
|
Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
Back to top |
|
|
|