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

Results

Any existing profiles for tables specified in options are 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.