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
 

 

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 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
No new posts ROUNDED Problem with COMPUTE statement shalem COBOL Programming 11 Thu Feb 09, 2017 8:16 pm
No new posts SYMNAMES problem jacobdng DFSORT/ICETOOL 7 Thu Dec 22, 2016 7:47 am
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm


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