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.