With the ALTER CACHE
statement, you can disable, enable or refresh cache tables. This requires
the CREATE CACHE or ALTER CACHE privilege.
ALTER CACHE "catalog"."schema"."view" OPTION
“catalog”.’schema”.”view”
Specifies the catalog,
schema and name of the view.
OPTION
Specifies an option
for the statement as one of the following:
DISABLE
Disables use of the
specified cache. References to the view use the view rather than the
cached data.
ENABLE
Enables use of the
specified cache after having been disabled.
REFRESH
Refreshes the cache
table for the specified view.
ALTER CACHE "catalog1"."schema1"."view1" DISABLE
ALTER CACHE [ "catalog2"."schema2". ] view2 ENABLE
ALTER CACHE [ "catalog3"."schema3". ] view3 REFRESH