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: 645
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: 645
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: 645
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: 1278
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: 645
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: 1738
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 What is the command to check MODE of ... rohanthengal CLIST & REXX 6 Fri Nov 18, 2016 1:48 pm
No new posts TOT & DATE parameter in ICEMAN hemanthj642 DFSORT/ICETOOL 4 Mon Nov 14, 2016 5:19 am
No new posts Check System time(Minute) Using TIME1... balaji81_k DFSORT/ICETOOL 5 Fri Nov 11, 2016 10:53 am
No new posts COBOL Version 6.1 Virendra Shambharkar COBOL Programming 5 Tue Nov 01, 2016 11:24 am
This topic is locked: you cannot edit posts or make replies. How to pass the previous month date i... Suganya87 DFSORT/ICETOOL 5 Mon Oct 31, 2016 4:13 pm


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