RC_CHANGE control statement

This control statement is optional. The default is RC_CHANGE=NONE.

event_name

Specifies the name of the event to be detected in Smart Reorg utility processing. The following event name can be specified:

POLICY.EXCEPTIONS.CRITICAL

This event specifies a condition where one or more critical-level exceptions exist in the database. This parameter must be specified with CONDREORG=YES, CONDREORG=YES,REORGDIAG, or CONDREORG=YES,DIAGONLY.

If the Smart Reorg utility performs a database reorganization, it returns the specified return code when it detects one or more critical-level exceptions in the reorganized database.

POLICY.ACTION.REORG

This event specifies a condition where a database reorganization is needed for the database or for one or more HALDB partitions and the reorganization is not performed yet. This parameter can be specified with CONDREORG=YES,DIAGONLY. However, if UNLOADONLY=YES is specified, this parameter can be specified with CONDREORG=YES or CONDREORG=YES,REORGDIAG. For an example, see Example 16: Conditionally reorganizing a database in separate job steps.

rc

Specifies the return code for the Smart Reorg utility that will be issued when the event is detected. The maximum value is 99, and the minimum value is 1.

NONE

Does not change the return code. The default return codes of the Smart Reorg utility are used.

You can specify multiple RC_CHANGE control statements, one for each event. If two or more events are detected, the largest return code is returned.