Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Binding problem

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

New User


Joined: 01 Feb 2010
Posts: 5
Location: coimbatore

PostPosted: Mon Mar 08, 2010 11:51 am    Post subject: Binding problem
Reply with quote

Hi, I am getting the sqlcode=-805. what do u mean by bind problem. how to rebound it.
Back to top
View user's profile Send private message

Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 788
Location: Chennai, India

PostPosted: Mon Mar 08, 2010 12:58 pm    Post subject:
Reply with quote

Hi,

Please visit this link and take the action as suggested for your reason code.
An application program attempted to use a DBRM or package 'location-name.collection-id.dbrm-name.consistency-token' that was not found.
Back to top
View user's profile Send private message
Ragav86

New User


Joined: 27 Jan 2010
Posts: 37
Location: chennai

PostPosted: Mon Mar 08, 2010 10:18 pm    Post subject: Reply to: Binding problem
Reply with quote

it mean the expected package was not found in db2(this may be the one of the reason).


check whether the consistency token in the program load module and consistency token in the db2 are matching. if not bind your dbrm again using bind package statement or using DB2I (BIND PACKAGE STATEMENT).

way to find out token.
1. go to your precompiled output of your program for every sql query some varibales will be automatically declered by your precompiler in working storage with the name of SQL-PLIST.(not sure about the name check it out)
this will have the timestamp of the load module, convert this to hex using select hex(time1),hex(time2) from sysibm.sysdummy1.

2. select hex(contoken) from sysibm.syspackage where name ='pack name';
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 Having a problem FTP'ng to the MF pahiker All Other Mainframe Topics 2 Fri Nov 10, 2017 8:20 pm
No new posts LMINIT problem - not finding DDNAME Danielle.Filteau CLIST & REXX 7 Tue Sep 19, 2017 9:57 pm
No new posts Problem commiting to DB2 from IMS MPP Ole Soerensen IMS DB/DC 2 Wed Jul 26, 2017 5:19 pm
No new posts Strings with double quotes having pro... raja Arumugam All Other Mainframe Topics 11 Thu Mar 30, 2017 10:34 am
No new posts Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us