We're not currently using profiles, but did take a look at them. Db2 v12 made some changes such that, if you use the defaults for some of the new v12 zparms, will automatically create/update RUNSTATS profiles with any recommendations that get written to the SYSSTATFEEDBACK table. Which means your profiles might contain a mix of legitimate helpful recommendations along with a bunch of "one-off" recommendations from infrequent ad-hoc queries, or even some queries which may have been poorly written or flat out written in error.
Bill Gallagher | Senior Systems Engineer, DBA
UPS6756, #1544403 Oleander Drive, Suite CWilmington, NC 28403 Phone: (910) 660-8649Fax: (910) 523-5504