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

What is the difference between plan and package


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ganga

New User


Joined: 16 Mar 2005
Posts: 7

PostPosted: Thu Mar 31, 2005 2:48 pm
Reply with quote

what is the diff b/w plan and package,which one will genarate first after the bind process.
Back to top
View user's profile Send private message
learnmf

Active User


Joined: 14 Mar 2005
Posts: 123

PostPosted: Thu Mar 31, 2005 7:17 pm
Reply with quote

Quote:
what is the diff b/w plan and package,which one will genarate first after the bind process.

package contains the optimize access path, where as plan Contains the package list along with the pointer to that package.So packge will generate first.
Back to top
View user's profile Send private message
learnmf

Active User


Joined: 14 Mar 2005
Posts: 123

PostPosted: Thu Mar 31, 2005 7:25 pm
Reply with quote

Quote:

what is the diff b/w plan and package,which one will genarate first after the bind process.




Package will generate fast.Package contains the optimize access path where as plan contains package list.

Thanks
Back to top
View user's profile Send private message
learnmf

Active User


Joined: 14 Mar 2005
Posts: 123

PostPosted: Thu Mar 31, 2005 7:30 pm
Reply with quote

Hi ganga
better you can refer this one for more knowledge
ibmmainframes.com/viewtopic.php?t=1882[/quote]
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 Timestamp difference and its average ... DB2 11
No new posts Difference when accessing dataset in ... JCL & VSAM 7
No new posts What is the difference between Taskty... Compuware & Other Tools 2
No new posts Rebind issue - Package DB2 2
No new posts Difference between VALIDPROC and CHEC... DB2 3
Search our Forums:

Back to Top