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
 

 

Significance of SYSIBM.SYSPACKAGE and SYSIBM.SYSPLAN

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

New User


Joined: 05 Mar 2009
Posts: 42
Location: Hyderabad

PostPosted: Thu Apr 30, 2009 6:12 pm    Post subject: Significance of SYSIBM.SYSPACKAGE and SYSIBM.SYSPLAN
Reply with quote

Can anyone tell me the significance of following 2 tables in package bind during runtime of DB2 program?

1) SYSIBM.SYSPLAN 2)SYSIBM.SYSPACKAGE.

During run time how the timestamp generated by precompiiler will be used to fetch the correct package/plan?
Back to top
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri May 01, 2009 2:55 am    Post subject:
Reply with quote

Go through the link http://www.ibmmainframes.com/viewtopic.php?t=23965 and then we will talk about those two tables later.
Back to top
View user's profile Send private message
Chinnadu

New User


Joined: 05 Mar 2009
Posts: 42
Location: Hyderabad

PostPosted: Fri May 01, 2009 2:53 pm    Post subject: Reply to: Significance of SYSIBM.SYSPACKAGE and SYSIBM.SYSPL
Reply with quote

Hey Anuj,

I have gone through the link mentioned in the previous reply. Still I am not clear on the following points..

1) In plan bind why do we have bind all pgms if we change only one program?
2 ) How can we identify if we are doing a plan bind or package bind?
Back to top
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 788
Location: Chennai, India

PostPosted: Fri May 01, 2009 4:53 pm    Post subject:
Reply with quote

Quote:
1) In plan bind why do we have bind all pgms if we change only one program?
Yes, if you bind all DBRMs to a plan directly...
No, if you bind a DBRM to package.

Quote:
How can we identify if we are doing a plan bind or package bind?
Please look at the BIND CARDs, ie, BIND JCL
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 ERM-Diagram of SysIBM-Catalog-Tables Auryn DB2 2 Fri Feb 17, 2017 6:22 pm
No new posts Can not find SQL statement of package... chaoj DB2 2 Wed Mar 11, 2015 12:00 pm
No new posts -551 on SYSIBM.SYSTABLES, SYSIBM.SYST... baramesh DB2 5 Mon Dec 23, 2013 6:29 pm
No new posts SYSIBM.SYSPACKSTMT - DB2 V9 TO V10 gylbharat DB2 22 Fri Oct 25, 2013 3:36 pm
No new posts what is the significance of REPLACE=N... Bill Woodger JCL & VSAM 6 Thu Feb 07, 2013 1:10 pm


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