DB2 Referential Integrity - Do Plans & Packages have any ref erences ??

Sanjeev (CTS) S

DB2 Referential Integrity - Do Plans & Packages have any ref erences ??
Hi All,
In response to the affect of dropping the RI on Rebinding the plans and
packages. I am not sure why it is specifically mentioned that plans and
packages need to be rebound if some particular kind of RIs(mentioned below
the mail from Joe Link containing text from SQL Reference ) are dropped.
Does this raise some question : Do plans and packages have any references
mentioned if objects containing RI is used ? I am sure all the
delete/insert/update statements are not included in the object module
(plans) but there must be something which tells the plan to go for RI
checks. Otherwise it may be completely dynamic. If it is completely dynamic
then can there be any reason why the plans and packages need to be rebound
if RIs of particular type is dropped i.e RI of Delete Cascade/Set null ?

Any kind of Opinions/Guesses/Clarifications are requested. There must be
some reason behind this kind of design.

Regards
Sanjeev

> -----Original Message-----
> From: Joseph Link [SMTP:[login to unmask email]
> Sent: Friday, December 15, 2000 9:05 PM
> To: [login to unmask email]
> Subject: Re: DB2 Referential Integrity
>
> Actually, there is one RI condition that will invalidate plans and
> packages, which bit me once before. Quoting the SQL Reference:
>
> "When a referential constraint is defined with a delete rule of CASCADE or
> SET NULL, all plans and packages that refer to the parent table of the
> constraint are invalidated. Furthermore, all plans and packages that
> refer to tables from which deletes cascade are also invalidated."
>
> So, if you add the RI back on at your DR site, and you have delete rules
> of
> CASCADE or SET NULL, there may be some plans and packages that need to be
> rebound.
>
> Joe Link
> DBA - FDR
>
>
-----------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------
This e-mail and any files transmitted with it are for the sole use
of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message. Any unauthorised review, use, disclosure,
dissemination, forwarding, printing or copying of this email or any action taken in
reliance on this e-mail is strictly prohibited and may be unlawful.

Visit us at http://www.cognizant.com
----------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------