Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 1281
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
This topic is locked: you cannot edit posts or make replies. 00D3003B - time outs in DB2 when invo... chavinash2004 DB2 2 Mon Oct 09, 2017 4:39 pm
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm
No new posts Comparing 2 Files using Current time arunsoods SYNCSORT 9 Fri Sep 22, 2017 6:00 pm
No new posts Regarding time parameter shanthi gude JCL & VSAM 7 Mon Sep 04, 2017 2:31 pm
No new posts Confusion b/w index and subscript Deepak kumar25 Mainframe Interview Questions 7 Thu Aug 31, 2017 6:50 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us