Description:
Does R14 PSM(Statistics Manager) exploit the new DB2V9 statistics columns?
Solution:
Statistics Manager(PSM) r14 supports:
New V9 tables:
SYSIBM.SYSKEYTARGETS SYSIBM.SYSKEYTARGETSTATS SYSIBM.SYSKEYTGTDIST SYSIBM. SYSKEYTGTDISTSTATS
and
Old tables: New V9 columns:
SYSIBM.SYSCOLDIST LOWVALUE, HIGHVALUE, QUANTILENO SYSIBM.SYSCOLDISTSTATS LOWVALUE, HIGHVALUE, QUANTILENO SYSIBM.SYSINDEXES DATAREPEATFACTORF, IX_EXTENSION_TYPE, KEYTARGET_COUNT SYSIBM.SYSINDEXSTATS DATAREPEATFACTORF