views going invalid

[Roger]

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

[m]

Roger wrote:

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

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

[Tomas]

On Jan 4, 2:07*pm, Roger <[e-mail]:

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

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