Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Solve aborts job when processing long cursor

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Solve aborts job when processing long cursor
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Mon Aug 24, 2009 3:58 am    Post subject:
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":
http://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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
Reply with quote

Whie browsing around I got this link..
http://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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Getting -504 Cursor Name GTT-ARTS-CUR... Robin Sulsona DB2 2 Fri Mar 17, 2017 1:43 am
No new posts Asynchronous CICS Processing Question moezbud CICS 0 Mon Mar 06, 2017 6:13 pm
No new posts Release of Adabas Cursor mohitsethi All Other Mainframe Topics 1 Mon Feb 06, 2017 8:36 pm
This topic is locked: you cannot edit posts or make replies. How to move a long alphanumeric data ... lind sh COBOL Programming 8 Mon Dec 05, 2016 7:51 pm
No new posts Updating Cursor row withour using FOR... chandan.inst DB2 15 Tue Nov 08, 2016 11:17 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us