Droping an index

[Raja Shekar]

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

[Serge Rielau]

Raja Shekar wrote:

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

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
--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab

[ras9929]

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>'