DB2 10.5 for Linux, UNIX, and Windows

COMPILE_SCHEMA procedure - Compile all functions, procedures, triggers, and packages in a schema

The COMPILE_SCHEMA procedure provides the capability to recompile all functions, procedures, triggers, and packages in a schema.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-DBMS_UTILITY.COMPILE_SCHEMA--(--schema--+---------------------------------------+-->
                                           '-,--compile_all--+-------------------+-'   
                                                             '-,--reuse_settings-'     

>--)-----------------------------------------------------------><

Parameters

schema
An input argument of type VARCHAR(128) that specifies the schema in which the programs are to be recompiled.
compile_all
An optional input argument of type BOOLEAN that must be set to false, meaning that the procedure only recompiles programs currently in invalid state.
reuse_settings
An optional input argument of type BOOLEAN that must be set to false, meaning that the procedure uses the current session settings.

Authorization

EXECUTE privilege on the DBMS_UTILITY module.