PSM (Statistics Manager)support of new DB2 v9 statistics

Document ID : KB000050719
Last Modified Date : 14/02/2018
Show Technical Document Details

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