|
View previous topic :: View next topic
|
| Author |
Message |
Chinnadu
New User
.jpg)
Joined: 05 Mar 2009
Posts: 46
Location: Hyderabad
|
|
|
|
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 |
|
 |
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
| Back to top |
|
|
Chinnadu
New User
Joined: 05 Mar 2009
Posts: 46
Location: Hyderabad
|
|
|
|
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 |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
|
|
|
|
| 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 |
|
|
|
|
