IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Confusion over the time stamp and BIND


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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

Moderator Emeritus


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

PostPosted: Fri Apr 30, 2010 2:29 am
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: 1281
Location: Belgium

PostPosted: Fri Apr 30, 2010 2:49 pm
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: 691
Location: Earth

PostPosted: Tue May 04, 2010 1:57 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts To get the the current time DFSORT/ICETOOL 13
No new posts RC query -Time column CA Products 3
No new posts C Compile time time stamps Java & MQSeries 10
No new posts Parallelization in CICS to reduce res... CICS 4
No new posts Insert system time/date (timestamp) u... DFSORT/ICETOOL 5
Search our Forums:

Back to Top