UTIL_RUNSTATS_PROFILE

The UTIL_RUNSTATS_PROFILE CM batch parameter specifies whether the RUNSTATS utility is to use statistics profiles.

Values:

USE or U

USE PROFILE is added to the utility statement. USE PROFILE specifies that a stored statistics profile is to be used to gather statistics for a table.

DELETE or D

DELETE PROFILE is added to the utility statement. DELETE PROFILE specifies that the existing RUNSTATS profile for the table is to be deleted from the SYSIBM.SYSTABLES_PROFILES catalog table.

blank

Neither PROFILE clause is added to the utility statement.

Default:

blank