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
 

 

To check the latest bind date or version

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

Active User


Joined: 18 Jan 2010
Posts: 143
Location: Pune

PostPosted: Wed Nov 10, 2010 5:12 pm    Post subject: To check the latest bind date or version
Reply with quote

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
View user's profile Send private message

daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 662
Location: Pennsylvania

PostPosted: Wed Nov 10, 2010 6:33 pm    Post subject:
Reply with quote

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
View user's profile Send private message
krunalbafna
Warnings : 1

Active User


Joined: 18 Jan 2010
Posts: 143
Location: Pune

PostPosted: Wed Nov 10, 2010 7:06 pm    Post subject: Reply to: To check the latest bind date or version
Reply with quote

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
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 662
Location: Pennsylvania

PostPosted: Wed Nov 10, 2010 7:18 pm    Post subject:
Reply with quote

UNBELIEVABLE icon_evil.gif

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
View user's profile Send private message
krunalbafna
Warnings : 1

Active User


Joined: 18 Jan 2010
Posts: 143
Location: Pune

PostPosted: Wed Nov 10, 2010 7:21 pm    Post subject: Reply to: To check the latest bind date or version
Reply with quote

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
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 662
Location: Pennsylvania

PostPosted: Wed Nov 10, 2010 7:32 pm    Post subject:
Reply with quote

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
View user's profile Send private message
krunalbafna
Warnings : 1

Active User


Joined: 18 Jan 2010
Posts: 143
Location: Pune

PostPosted: Wed Nov 10, 2010 7:36 pm    Post subject: Reply to: To check the latest bind date or version
Reply with quote

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
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Wed Nov 10, 2010 7:38 pm    Post subject:
Reply with quote

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
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 662
Location: Pennsylvania

PostPosted: Wed Nov 10, 2010 7:45 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Nov 10, 2010 8:47 pm    Post subject:
Reply with quote

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:
Quote:
I got SQL -805.
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
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1753
Location: Bloomington, IL

PostPosted: Wed Nov 10, 2010 9:45 pm    Post subject: Re: Reply to: To check the latest bind date or version
Reply with quote

krunalbafna wrote:
My bind was successful.

And we know this is true because...?
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 LISTIDR compiled date/time jerryte IBM Tools 3 Thu Apr 20, 2017 7:37 pm
No new posts SUBSTR for Date functions Shaheen Shaik DB2 4 Thu Apr 06, 2017 2:14 pm
No new posts Check Binary Values for symbols gandikk CA Products 3 Tue Mar 21, 2017 5:11 am
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm
No new posts How to get current date -1 and curren... murali.andaluri DFSORT/ICETOOL 3 Wed Mar 08, 2017 2:09 pm


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