Droping an index

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Raja Shekar - 29 Dec 2005 04:33 GMT

Hi Everybody,
I have a view created based on two base tables..now when i drop one of
the tables on which the view is dependent ..what would happen when i
try to select some records from that view ..? Does the view becomes not
usable or autmatically that will get droped as soon as one of the base
table on which it depends get dropped...?
Thanks in advance
Bye

Reply to this Message

Serge Rielau - 29 Dec 2005 05:35 GMT

> Hi Everybody,
> I have a view created based on two base tables..now when i drop one of
[quoted text clipped - 4 lines]
> Thanks in advance
> Bye

The view will effectively be dropped.
DB2 will keep the defintion in SYSCAT.VIEWS however, marking the view as
invalid.
There is no automatic revalidation.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab

Reply to this Message

ras9929 - 29 Dec 2005 14:46 GMT

The other thing to remember is that DB/2 when invalidating a view will
also remove permissions from that view. If DB2 security is handled by
a group other than DBAs, this can cause some organizational headaches.

Here's a query to list views dependent on an table...
SELECT VIEWSCHEMA, VIEWNAME
FROM SYSCAT.VIEWDEP
WHERE BNAME = '<table name>'
AND BSCHEMA = ' <table schema>'

Reply to this Message