DB2 v8 alter view REGENERATE

David Seibert

DB2 v8 alter view REGENERATE
Hello all,

Has anybody at DB2 UDB for z/OS v8 run into the situation where the new
ALTER VIEW ... REGENERATE is necessary or useful?

I haven't been able to cause the circumstance this statement is intended
remedy.

There are 2 columns in SYSTABLES pertinent here: STATUS has a value of R
> An error occurred when an attempt was made to regenerate the internal
> representation of the view. < (c) Copyright IBM Corp. 1982, 2004
and
TABLESTATUS which contains a V signifiying the same thing.

The "Everything you wanted to know..." v8 redbook(SG24-6079) provides a
little more information, but not enough to tell me what I need to do to
cause the invalidated views.

Thanks in advance

Dave



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Phil Grainger

Re: DB2 v8 alter view REGENERATE
(in response to David Seibert)
I wonder if it has something to do with a view not being regenerated
automatically by DB2 when an underlying table is altered?


Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Seibert, Dave
Sent: 16 December 2004 14:55
To: [login to unmask email]
Subject: DB2 v8 alter view REGENERATE

Hello all,

Has anybody at DB2 UDB for z/OS v8 run into the situation where the
new ALTER VIEW ... REGENERATE is necessary or useful?

I haven't been able to cause the circumstance this statement is intended
remedy.

There are 2 columns in SYSTABLES pertinent here: STATUS has a value of R
> An error occurred when an attempt was made to regenerate the internal
> representation of the view. < (c) Copyright IBM Corp. 1982, 2004
and
TABLESTATUS which contains a V signifiying the same thing.

The "Everything you wanted to know..." v8 redbook(SG24-6079) provides a
little more information, but not enough to tell me what I need to do to
cause the invalidated views.

Thanks in advance

Dave



The contents of this e-mail are intended for the named addressee only.
It contains information that may be confidential. Unless you are the
named addressee or an authorized designee, you may not copy or use it,
or disclose it to anyone else. If you received it in error please notify
us immediately and then destroy it.

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

David Seibert

Re: DB2 v8 alter view REGENERATE
(in response to Phil Grainger)
Hi Phil,

That's what's implied. But the redbook the reference both lead you to
believe that the regeneration is automatic and this status occurs when that
auto-regenerate fails.

I've tried several changes to tables and columns in views (Alter add col,
alter col datatype, etc) but the auto-regenerate always works in my cases.

Thanks

Dave


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Grainger, Phil
Sent: Thursday, December 16, 2004 10:07 AM
To: [login to unmask email]
Subject: Re: DB2 v8 alter view REGENERATE


I wonder if it has something to do with a view not being regenerated
automatically by DB2 when an underlying table is altered?


Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Seibert, Dave
Sent: 16 December 2004 14:55
To: [login to unmask email]
Subject: DB2 v8 alter view REGENERATE

Hello all,

Has anybody at DB2 UDB for z/OS v8 run into the situation where the new
ALTER VIEW ... REGENERATE is necessary or useful?

I haven't been able to cause the circumstance this statement is intended
remedy.

There are 2 columns in SYSTABLES pertinent here: STATUS has a value of R
> An error occurred when an attempt was made to regenerate the internal
> representation of the view. < (c) Copyright IBM Corp. 1982, 2004
and
TABLESTATUS which contains a V signifiying the same thing.

The "Everything you wanted to know..." v8 redbook(SG24-6079) provides a
little more information, but not enough to tell me what I need to do to
cause the invalidated views.

Thanks in advance

Dave



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Phil Grainger

Re: DB2 v8 alter view REGENERATE
(in response to David Seibert)
How about when the view is "in use"? Does the alter fail??


Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Seibert, Dave
Sent: 16 December 2004 15:14
To: [login to unmask email]
Subject: Re: DB2 v8 alter view REGENERATE

Hi Phil,

That's what's implied. But the redbook the reference both lead you to
believe that the regeneration is automatic and this status occurs when
that auto-regenerate fails.

I've tried several changes to tables and columns in views (Alter add
col, alter col datatype, etc) but the auto-regenerate always works in my
cases.

Thanks

Dave


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Grainger, Phil
Sent: Thursday, December 16, 2004 10:07 AM
To: [login to unmask email]
Subject: Re: DB2 v8 alter view REGENERATE


I wonder if it has something to do with a view not being regenerated
automatically by DB2 when an underlying table is altered?


Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Seibert, Dave
Sent: 16 December 2004 14:55
To: [login to unmask email]
Subject: DB2 v8 alter view REGENERATE

Hello all,

Has anybody at DB2 UDB for z/OS v8 run into the situation where the
new ALTER VIEW ... REGENERATE is necessary or useful?

I haven't been able to cause the circumstance this statement is intended
remedy.

There are 2 columns in SYSTABLES pertinent here: STATUS has a value of R
> An error occurred when an attempt was made to regenerate the internal
> representation of the view. < (c) Copyright IBM Corp. 1982, 2004
and
TABLESTATUS which contains a V signifiying the same thing.

The "Everything you wanted to know..." v8 redbook(SG24-6079) provides a
little more information, but not enough to tell me what I need to do to
cause the invalidated views.

Thanks in advance

Dave



The contents of this e-mail are intended for the named addressee only.
It contains information that may be confidential. Unless you are the
named addressee or an authorized designee, you may not copy or use it,
or disclose it to anyone else. If you received it in error please notify
us immediately and then destroy it.

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

------------------------------------------------------------------------
----
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm



The contents of this e-mail are intended for the named addressee only.
It contains information that may be confidential. Unless you are the
named addressee or an authorized designee, you may not copy or use it,
or disclose it to anyone else. If you received it in error please notify
us immediately and then destroy it.

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

David Seibert

Re: DB2 v8 alter view REGENERATE
(in response to Phil Grainger)
Yes the alter fails >> -904 rc 00e70081 -- the object is in use.

Dave


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Grainger, Phil
Sent: Thursday, December 16, 2004 10:27 AM
To: [login to unmask email]
Subject: Re: DB2 v8 alter view REGENERATE


How about when the view is "in use"? Does the alter fail??


Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Seibert, Dave
Sent: 16 December 2004 15:14
To: [login to unmask email]
Subject: Re: DB2 v8 alter view REGENERATE

Hi Phil,

That's what's implied. But the redbook the reference both lead you to
believe that the regeneration is automatic and this status occurs when that
auto-regenerate fails.

I've tried several changes to tables and columns in views (Alter add col,
alter col datatype, etc) but the auto-regenerate always works in my cases.

Thanks

Dave


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Grainger, Phil
Sent: Thursday, December 16, 2004 10:07 AM
To: [login to unmask email]
Subject: Re: DB2 v8 alter view REGENERATE


I wonder if it has something to do with a view not being regenerated
automatically by DB2 when an underlying table is altered?


Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Seibert, Dave
Sent: 16 December 2004 14:55
To: [login to unmask email]
Subject: DB2 v8 alter view REGENERATE

Hello all,

Has anybody at DB2 UDB for z/OS v8 run into the situation where the new
ALTER VIEW ... REGENERATE is necessary or useful?

I haven't been able to cause the circumstance this statement is intended
remedy.

There are 2 columns in SYSTABLES pertinent here: STATUS has a value of R
> An error occurred when an attempt was made to regenerate the internal
> representation of the view. < (c) Copyright IBM Corp. 1982, 2004
and
TABLESTATUS which contains a V signifiying the same thing.

The "Everything you wanted to know..." v8 redbook(SG24-6079) provides a
little more information, but not enough to tell me what I need to do to
cause the invalidated views.

Thanks in advance

Dave



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

------------------------------------------------------------------------
----
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm