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
 

 

how to analyse on the abends for DB2 modules

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
abdulrafi

Active User


Joined: 14 Sep 2009
Posts: 145
Location: Coimbatore

PostPosted: Thu Aug 05, 2010 5:46 pm    Post subject: how to analyse on the abends for DB2 modules
Reply with quote

Hi,

I am new to DB2 and I have developed some DB2 programs with embedded sql's and cursors. Now I am executing it and trying to find out the reason why it is not executing. It is not abending rather it is not getting executed.
Could anybody tell me how to start up with my analysis on this . Is there any log files to see the data until which the db2 processing is done or something like that ?.
Once my program abended with -912 i guess. i was unable to search for the plan whether it has been binded properly or not. If am wrong correct me please.
Back to top
View user's profile Send private message

Binop B

Active User


Joined: 18 Jun 2009
Posts: 407
Location: Nashville, TN

PostPosted: Thu Aug 05, 2010 6:19 pm    Post subject:
Reply with quote

Hi Abdul,

Enjoy your stay in the Db2 world !!! icon_biggrin.gif

My suggestion for you is to check with your seniors on this ... Ask them to guide you for a simple program ... Make it work one time and then you can start with the actual code with all the cursors.. icon_wink.gif
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Aug 05, 2010 9:47 pm    Post subject:
Reply with quote

AdbulRafi, Hi,

Did you execute your SQL in SPUFI ? Did you get any results.

Post your full SQLCODE error message, so that other could help with your analysis.

Sushanth
Back to top
View user's profile Send private message
ChowHan

New User


Joined: 16 Oct 2009
Posts: 15
Location: India

PostPosted: Thu Aug 05, 2010 11:13 pm    Post subject:
Reply with quote

Just a few more questions

Quote:
Once my program abended with -912 i guess


Are you sure? Did you put in a test for non-zero SQLCODE after open and fetch statements? or display SQLCODE in spool?
Did the cursor open successfully? Did it fail in fetch ?

Quote:
It is not abending rather it is not getting executed.


Is there some sort of conditional processing involved, where you cursor will be opened and rows fetched only if a certain condition is met?

Did you try debugging with expeditor (if its available in your shop)?

And as someone asked, did you run the cursor query in spufi?
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 IEFZB476 getting various 0C4 abends Grant Goodale PL/I & Assembler 18 Sat Sep 12, 2015 9:27 pm
No new posts How to find possible traces of ARCH 7... Prosenjit2011 All Other Mainframe Topics 5 Mon Aug 17, 2015 10:53 am
No new posts COBOL Update to 5.1, recompile all mo... vickey_dw COBOL Programming 1 Thu Jun 18, 2015 10:45 am
No new posts Is it possible to FTP the COBOL progr... ankit.jain TSO/ISPF 12 Wed Apr 22, 2015 6:51 pm
No new posts Code for called and calling modules i... Gopalakrishnan V CLIST & REXX 13 Thu Nov 13, 2014 7:07 pm


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