IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Solve aborts job when processing long cursor


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
jctgf
Currently Banned

Active User


Joined: 04 Nov 2006
Posts: 109

PostPosted: Sun Aug 23, 2009 7:48 pm
Reply with quote

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
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Sun Aug 23, 2009 8:23 pm
Reply with quote

What is SOLVE?
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Sun Aug 23, 2009 8:55 pm
Reply with quote

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
View user's profile Send private message
jctgf
Currently Banned

Active User


Joined: 04 Nov 2006
Posts: 109

PostPosted: Sun Aug 23, 2009 10:31 pm
Reply with quote

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
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Sun Aug 23, 2009 10:43 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Mon Aug 24, 2009 3:58 am
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Mon Aug 24, 2009 1:05 pm
Reply with quote

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
View user's profile Send private message
ovreddy

Active User


Joined: 06 Dec 2004
Posts: 211
Location: Keane Inc., Minneapolis USA.

PostPosted: Mon Aug 24, 2009 2:55 pm
Reply with quote

Hi,

Define cusror WITH UR (Uncommitted Read) this will prevent the cursor holding locks against the database.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Mon Aug 24, 2009 3:09 pm
Reply with quote

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
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Tue Aug 25, 2009 4:10 pm
Reply with quote

Whie browsing around I got this link..
www.ca.com/in/products/product.aspx?id=1503

Is the SOLVE mentioned in this thread is related to this??
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Ca7 long running jobs report All Other Mainframe Topics 1
No new posts how to solve this power failure shutd... ABENDS & Debugging 5
No new posts icetool empty file and not empty file... DFSORT/ICETOOL 5
No new posts Cobol-db2 : SQL query is running for ... DB2 4
No new posts Any idea about how to solve 3022 aben... IMS DB/DC 3
Search our Forums:

Back to Top