Topic: DB2 for z/OS
DATE: 2011-5-4 (02:45 PM - 03:45 PM)
SPEAKERS: Terry Berman (DST Systems, Inc)
DST Systems leverages the information that DB2 externalizes as a key tactic to improve database performance, reliability and security. Our early trials of various such opportunities new in DB2 10 -- IFI metrics, real-time statistics, catalog columns, explain info -- produced several success stories, along with a few provisos. This (selective) survey shows how the support of longstanding DB2 functionality is enhanced with this new information.
EXP. LEVEL: Intermediate,Advanced
Enhanced monitoring(statement-level identification, IFCID 401 performance metrics, profile tables)
IFI changes/enhancements(enhanced auditing, separate lock/latch, subsystem stats, distributed metrics, 64-bit counters, index I/O parallelism, SMF compression)
Real-time statistics(select and cluster-sensitive metrics, hash support)
Catalog new information(STATEMENT text, package last-used, enhanced auditing security objects, pending DDL)
Explain tables(new version upgrade policy, sectnoi/collid/version harmonized across all tables, cost uncertainty externalized)
Click Here to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.