My problem is twofold :

I have created views in DB2 , but lately they seems to be obtaining the requested data from a cache, ie : the view isn't being refreshed. I know this, because as soon as I drop the view and re-create it again, the data I'm looking for is there.

So could anyone help me with A) Checking to see what code was used to create a specific view, B) How to fix the caching problem.

Thanks

I'm not sure if I understand your problem ...

AFAIK, a view is never materialized and cached ... The view is stored in dB2 as a definition only .... Whenever a view is referred, using the defn db2 gets the table from the bufferpool or disk to build the resultset ...

To see the view definition, use SYSCAT.VIEWS

HTH

Sathyaram

Are you talking about materialized query tables or DB2 views?