Can a plan exist without a package? Also can a package exist without a plan?
QUESTION POSED ON: 08 NOV 2004
QUESTION ANSWERED BY:
Craig Mullins
Well, the answer to both of your questions is "yes"... but we should really
go into more details.
A plan can exist without a package by directly binding the DBRMs into the
plan. This was the standard way of operating prior to packages being
introduced to DB2 back in V2.3.
A package can exist without a plan, too. But in order for the package to be
used by an application it must be bound into a plan. There are exceptions,
though. For example, a trigger that contains SQL will have a trigger package
defined for it. This trigger package exists and is used by DB2 without the
user having to bind it into a plan.
In general, though, a package will be bound into a plan for it to be used by
an application program.
Related Topics:
Search Advice from more than 250 TechTarget Experts
Your question may have already been answered! Browse or search more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice
ASSOCIATED RSS FEEDS
 |
|
Expert Answer Center: Expert Q&As |
|
View all RSS Feeds | RSS Info
|
