PSM (Statistics Manager)support of new DB2 v9 statistics

Article Id: 50719

Status: Published

Updated On: 21-03-2018 06:12

Legacy Id: TEC540438

Products:

CA RC Compare for DB2 for z/OS , CA Bind Analyzer for DB2 for z/OS , CA SQL-Ease for DB2 for z/OS , CA Sysview Performance Management Option for DB2 for z/OS , CA Plan Analyzer for DB2 for z/OS , CA Subsystem Analyzer for DB2 for z/OS , CA Database Analyzer for DB2 for z/OS , CA Fast Unload for DB2 for z/OS , CA Fast Check for DB2 for z/OS , CA Fast Index for DB2 for z/OS , CA Fast Load for DB2 for z/OS , CA Rapid Reorg for DB2 for z/OS

Issue/Introduction:

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

Environment:

Release:
Component: PPADB2