views going invalid

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger - 04 Jan 2008 22:07 GMT

For some reason some of my views on a DB2 8.2 FP15 database went into
invalid state. I extracted the text from the sysviews and re created
them. I want to know why it went to invalid state to begin with. How
can i find the reason ?

Thanks

Roger

Reply to this Message

m - 04 Jan 2008 22:14 GMT

> For some reason some of my views on a DB2 8.2 FP15 database went into
> invalid state. I extracted the text from the sysviews and re created
[quoted text clipped - 4 lines]
>
> Roger

Generally speaking - views go invalid when the underlying table changes....

Reply to this Message

Tomas - 05 Jan 2008 00:16 GMT

> For some reason some of my views on a DB2 8.2 FP15 database went into
> invalid state. I extracted the text from the sysviews and re created
[quoted text clipped - 4 lines]
>
> Roger

Check out syscat.viewdep for the views in question to find what other
objects the views depend on. A change to those base objects (table,
function, other view...) could make your views inoperative.

/T

Reply to this Message