Deleting statistics profiles

You can delete an existing statistics profile.

Procedure

To delete existing RUNSTATS profiles:

Issue the following utility control statement:

RUNSTATS TABLESPACE ts-name TABLE options DELETE PROFILE

Any existing profile for the table or tables specified in options is removed. No statistics are collected when you invoke the RUNSTATS utility with the DELETE PROFILE option. If no profile exists for the specified table or tables DB2® issues an error message.