View previous topic :: View next topic
|
Author |
Message |
krunalbafna Warnings : 1 Active User
Joined: 18 Jan 2010 Posts: 143 Location: Pune
|
|
|
|
Hi,
I got SQL -805.
I successfully bind the code.
I need to check whether new version points to latest bind. How can we check the bind date of our code.
Regards,
Krunal |
|
Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
You actually need to check for a match on the Contoken.
To be truthful however, this is probably a waste of your time (and mine).
I have dealt with hundreds of -805 abends and rarely do I need to match up the contoken.
This is what I do to diagnose the problem (hundreds of times):
1) Show the JCL used to perform the Bind. The concatenation of the DBRMLIB is of particular interest.
2) If you did not use JCL, show the BIND command used to perform the bind. The LIBRARY parameter is of particular interest.
3) Show the JCL used to execute your Batch Job. The concatenation of the JOBLIB or STEPLIB is of particular interest.
4) If this a CICS module, show the JCL for the CICS region in question. The concatenation of the DFHRPL is of particular interest.
What I have found most of the time is that there is a mismatch in the concatenations.
Look for yourself and please SHOW what I have asked for.
I did not spend my time helping you, for you to ignore this advise. |
|
Back to top |
|
|
krunalbafna Warnings : 1 Active User
Joined: 18 Jan 2010 Posts: 143 Location: Pune
|
|
|
|
Hi,
My bind was successful.
I want to know,
By what way we can check the latest version of Bind package in certain library on MF |
|
Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
UNBELIEVABLE
I spend a great deal of time explaining how to debug your issue and you respond with
Quote: |
My bind was successful.
|
Why do a I waste my time?
READ WHAT I WROTE PLEASE. |
|
Back to top |
|
|
krunalbafna Warnings : 1 Active User
Joined: 18 Jan 2010 Posts: 143 Location: Pune
|
|
|
|
Hi daveporcelan,
I have written in my post initially about my successful bind.
I am trying to find out the what are the changes that shows the latest version of my bind.
Example: When we successfully compile one code we do get the date in the load lib.
Similarly how can we check for the latest version of the Bind plan. |
|
Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
Your post is about how to resolve a -805 error.
You THINK you need to resolve the 'date' in the loadlib.
1) It is not the date that causes the issue, it is the contoken
2) from my experience, the real problem it is the concatenation (from a successful bind) that is the cause of the issue
3) I showed you what to do in great detail and you ignore it
4) None of these statements make any sense
Quote: |
I am trying to find out the what are the changes that shows the latest version of my bind.
Example: When we successfully compile one code we do get the date in the load lib.
Similarly how can we check for the latest version of the Bind plan.
|
I suggest you first have someone teach you how this all fits together.
Or try what I suggested to correct your -805. |
|
Back to top |
|
|
krunalbafna Warnings : 1 Active User
Joined: 18 Jan 2010 Posts: 143 Location: Pune
|
|
|
|
Hi daveporcelan,
I welcome your suggestion.
I would advice you to check the subject of the Topic.
I have been cleary asking from forum how to check for latest version of bind plan or package when bind is successful.
Regards,
Krunal
(Before giving suggestion first check how much you are aware of the topic rather than keep blaming) |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
Code: |
select name,contoken,version,bindtime,pdsname from sysibm.syspackage
where location = ''
and collid = 'COLLNAME'
and name = 'PROGNAME' |
gives you the different versions and bindtimes.
which one you actually need depends on which load you are using.
my -805's usually were caused by forgetting to do a new copy |
|
Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
1) Go to SYSIBM.SYSPACKAGE
2) Find your package
3) Display the CONTOKEN in HEX
4) Swap the order of the two half words
Code: |
1D4D0F8E
88059902
becomes
0F8E1D4D
99028805
|
5) Find and browse your load module in question
6) Look for the rearranged contoken
f x'09F980E218D840D5' |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
I would advice you to check the subject of the Topic. |
My advice would be to practice what you preach. . . Yes this is what the topic mentions but:
The first information is about the -805.
So, the responses have primarily dealt with resolving a -805.
If you are only interested in the comparison, why mention the -805? If you really want to resolve the -805 and the comparison is incidental, you should follow the advice on how to resolve the -805.
As has been mentioned, this compriason is not needed to fix the problem and because of they way the db2 environment works, you still have to deal with the -805. . . |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
krunalbafna wrote: |
My bind was successful. |
And we know this is true because...? |
|
Back to top |
|
|
|