RECREATE_VIEWS procedure¶

Recreates all inoperative views in the specified schema from their system catalogue definitions.

Prototypes¶

RECREATE_VIEWS(ASCHEMA VARCHAR(128))
RECREATE_VIEWS()

Description¶

RECREATE_VIEWS is a utility procedure which recreates all inoperative views in a specified schema, using the SQL found in the system catalogue tables. It is useful for quickly recreating views which have been marked inoperative after a change to one or more of the views’ dependencies. If ASCHEMA is omitted it defaults to the current schema.

Note

This procedure is effectively redundant as of DB2 9.7 due to the new deferred revalidation functionality introduced in that version.

Warning

This procedure does not take into account the dependencies of views when recreating them. It crudely attempts to correctly order recreations on the basis of the CREATE_TIME field in the system catalogue, but this is not necessarily accurate. However, multiple consecutive runs of the procedure can be sufficient to recreate all inoperative views.

Warning

See SAVE_AUTH procedure for warnings regarding the loss of authorization information with inoperative views.

Parameters¶

ASCHEMA: If provided, specifies the schema containing the views to recreate. If omitted, defaults to the value of the CURRENT SCHEMA special register.

Examples¶

Recreate all inoperative views in the FOO schema:

CALL RECREATE_VIEWS('FOO');

Recreate all inoperative views in the current schema:

CALL RECREATE_VIEWS;