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
 

 

for COBOL Stored procedures, we are facing sqlcode -805

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
GaganGarg

Active User


Joined: 31 Mar 2010
Posts: 132
Location: India

PostPosted: Mon May 24, 2010 3:19 pm    Post subject: for COBOL Stored procedures, we are facing sqlcode -805
Reply with quote

Hi All,

In our project, for COBOL Stored procedures, we are facing sqlcode -805 as and when web screen accesses the SP. Whenever we make any changes to SP and we do compile and bind, we are getting this error. We believe that the reason behind the error might be latest bind info is not getting updated in Catalog tables immediately. Because without making any fix, the issue is automatically getting corrected after 5 to 6 hrs. Not sure how to reduce this delay and see the results of our code changes in SP immediately. Please advise any suggestions if you have faced similar issue before.

Options that we tried:
1. Dropped the Stored procedure ; recreated and then bound the SP.
2. Deleted the load and DBRM. Compiled and bound the SP.

Both of the above options didn’t solve the issue.

Thanks
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


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

PostPosted: Mon May 24, 2010 6:06 pm    Post subject:
Reply with quote

Quote:
might be latest bind info is not getting updated in Catalog tables immediately


you have it backwards. the bind updates the db2 catalog tables immediately.
That's one of the reasons db2 has to be running to accomplish a bind.
you can pre-compile without db2, but you need db2 to bind - because it updates the catalog tables...

what you may wish to explore:
the loadlib containing the sp
and working copy of the loadlib
are are maintained in memory.
Applications like CICS and Websphere need their 'loadlib's refreshed

and for CICS
a newcopy of the loadmodule is required
if the module has been changed and you want to see the effects of that change.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Tue May 25, 2010 2:51 pm    Post subject:
Reply with quote

WLM_REFRESH ?
Back to top
View user's profile Send private message
GaganGarg

Active User


Joined: 31 Mar 2010
Posts: 132
Location: India

PostPosted: Tue May 25, 2010 7:56 pm    Post subject:
Reply with quote

The solution is to do WLM refresh. In our case, refresh was done automatically after certain hours and we were concentrating on finishing unit testing. In future, if we face this issue, we will do WLM refresh.
Thanks all for your valuable inputs icon_biggrin.gif
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue May 25, 2010 9:11 pm    Post subject:
Reply with quote

If you do WLM refresh and this is the "common WLM", all the SPs executing in that WLM will loose what they might have in spool. Check with your support, if you can get a dedicated subsystem ID of the DB2 subsystem with which the WLM environment can be associated; in simple terms if you can get a different address-space for your application/team. Otherwise other team-members might hunt for you to and not with very good intentions ... icon_smile.gif
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 -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
This topic is locked: you cannot edit posts or make replies. RANDOM Function in COBOL swapnil781 COBOL Programming 2 Tue Nov 15, 2016 6:17 pm
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts COBOL Version 6.1 Virendra Shambharkar COBOL Programming 5 Tue Nov 01, 2016 11:24 am
No new posts Cobol list of programs being called biswajit.dattagupta COBOL Programming 5 Tue Nov 01, 2016 2:10 am


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