Articles & Content

Archives

Early experiences with new DB2 10 metrics/metadata (G08)

Topic: 2011 NA

Subtopic: 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

OBJECTIVES:

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.