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
 

 

Confusion over the time stamp and BIND

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

New User


Joined: 03 Aug 2006
Posts: 9

PostPosted: Fri Apr 30, 2010 2:18 am    Post subject: Confusion over the time stamp and BIND
Reply with quote

Well I am little confused about the time stamp concept and when we need to bind

Some concepts that I keep in mind

- we get a SQLCODE -818 if there is a mismatch between the time stamp of load mondule and the time stamp of Plan
- If I am using a Package for a program(SQL program) and I make change to non-SQL part then I need to recompile as well as BIND PACKAGE the new DBRM again, but not BIND PLAN
- One of the advantage of binding DBRMs to PACKAGE first and then binding these PACKAGEs to PLAN is that if there is a change in the program for any one PACKAGE we just have to BIND PACKAGE again not the PLAN.

Now there are two doubts which trouble me:
1)If I only BIND PACKAGE and the time stamp changes from t1 to t2 for this DBRM/package and I don't BIND PLAN then how will the time stamp of the PLAN change to t2 automatically ?

2) I compile the changed module(subprogram) on time stamp t2 but now I also have to recompile the main module(also a SQL module but with no changes) again. Suppose I do it at time stamp t3. Then how does the final load module and the final Plan get the same time stamp and what will the time stamp be t2 or t3 or some thing different?

Thanks and Regards
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: Fri Apr 30, 2010 2:29 am    Post subject:
Reply with quote

Hello,

This should not be an issue for a developer. . . This should already be standard process(es) on the system and the developers should use the standard compile/link/bind process.

You should talk with your support people as to what is stanrard on your system.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1280
Location: Belgium

PostPosted: Fri Apr 30, 2010 2:49 pm    Post subject:
Reply with quote

What gave you the idea that -818 has anything to do with the plan?

do you use VERSION(AUTO) on the precompile or do you specify a specific VERSION?
Back to top
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 686
Location: Earth

PostPosted: Tue May 04, 2010 1:57 am    Post subject:
Reply with quote

In both your queries you are trying to associate a PLAN with a single timestamp/consistency token. Remember that PLAN is list of packages and every package has its associated consistency-token. 'Timestamp' is not the correct terminology to use. So when you bind a package, it is enough. No need to bind the plan.

I have never encountered -818. I can't imagine getting -818 when working with packages.

I recommend that you should read the plans___dbrms___packages___collections___versions___confusion.pdf document which was posted by Dick Brenholtz. Its a very good document for understanding the basics better. Good luck.
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 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
No new posts Why myself doing Package Bind always ... Susanta DB2 5 Thu Mar 02, 2017 10:47 pm
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
No new posts CICS transaction slow response time vasanthz All Other Mainframe Topics 3 Thu Jan 19, 2017 1:31 am


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