Ad Hoc EXPLAIN

Gerald Brookman

Ad Hoc EXPLAIN
Envir: DB2 OS/390 V6.1

When we upgraded to DB2 V6.1, we deleted all the old PLAN_TABLE's and
created a single new master 49 column PLAN_TABLE. All of our production
plans and packages are currently bound with "EXPLAIN(NO)". What I would like
to know is do I have to create an owner.PLAN_TABLE for each owner prior to a
REBIND of all the production plans and packages with "EXPLAIN(YES)"? The
V6.1 "Command Reference" manual on page 73-75 is not clear. TIA.

Gerald R. (Garry) Brookman

James Szabo

Re: Ad Hoc EXPLAIN
(in response to Gerald Brookman)
Ad Hoc EXPLAINYes - your REBINDs will fail otherwise.

Next time, don't delete the old PLAN_TABLES, but upgrade them via ALTER commands. If you have a change management product (BMC, CA, etc.), this is quite easy.

Jim Szabo
----- Original Message -----
From: Brookman, Gerald
Newsgroups: bit.listserv.db2-l
To: [login to unmask email]
Sent: Monday, January 08, 2001 5:29 PM
Subject: Ad Hoc EXPLAIN


Envir: DB2 OS/390 V6.1

When we upgraded to DB2 V6.1, we deleted all the old PLAN_TABLE's and created a single new master 49 column PLAN_TABLE. All of our production plans and packages are currently bound with "EXPLAIN(NO)". What I would like to know is do I have to create an owner.PLAN_TABLE for each owner prior to a REBIND of all the production plans and packages with "EXPLAIN(YES)"? The V6.1 "Command Reference" manual on page 73-75 is not clear. TIA.

Gerald R. (Garry) Brookman

Sanjeev (CTS) S

Re: Ad Hoc EXPLAIN
(in response to James Szabo)
If you do not have the PLAN_TABLE for each owner, bind/rebind will
definitely fail and probably with -204.
In V6, all the newly added columns are NOT NULL WITH DEFAULT, so i think
ALTER can be used.

HTH
Regards,
Sanjeev

> -----Original Message-----
> From: Brookman, Gerald [SMTP:[login to unmask email]
> Sent: Tuesday, January 09, 2001 3:59 AM
> To: [login to unmask email]
> Subject: Ad Hoc EXPLAIN
>
> Envir: DB2 OS/390 V6.1
>
> When we upgraded to DB2 V6.1, we deleted all the old PLAN_TABLE's and
> created a single new master 49 column PLAN_TABLE. All of our production
> plans and packages are currently bound with "EXPLAIN(NO)". What I would
> like to know is do I have to create an owner.PLAN_TABLE for each owner
> prior to a REBIND of all the production plans and packages with
> "EXPLAIN(YES)"? The V6.1 "Command Reference" manual on page 73-75 is not
> clear. TIA.
>
> Gerald R. (Garry) Brookman
>
-----------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------
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
----------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------