Articles & Content

Archives

Accelerate Your DB2 Business On Demand Autonomically! (H12)

Topic: DB2 for LUW

Subtopic: 2007



DATE: 2007-5-10 (09:20 AM - 10:20 AM)
SPEAKERS: Scott Hayes (Database-Brothers Inc.)

Over ten years of crisis and fine tuning DB2 LUW and its applications (SAP, Siebel, PeopleSoft, Lawson, Websphere, and I2 to name a few) have yielded many valuable lessons and performance tuning solutions. This session describes performance best practices and tips for exploiting the many autonomic tuning capabilities of DB2 LUW. It is loaded with practical, technical, and usable lessons for achieving dramatic and measurable performance improvements on any DB2 Multi-Platform database, with emphasis on V8.2 and V9. Attendees will hear anecdotes and customer success stories from actual customer situations and learn the physical design and/or configuration solutions that provided remarkable performance results, and will also take home a checklist to verify performance integrity in their own shops. With all of the new AUTOMATIC and AUTONOMIC capabilities of DB2, attend this session to learn what is left for the DBA to do - if anything!

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Hear summarized history of improvements to DB2 LUW from V5 to V9

Discuss DB2 V8.2 Automatic Capabilities

Discuss DB2 V9 Automatic Capabilities, best practices, and recommendations for Self-Tuning Memory Manager (STMM). It's good stuff, but some risks and cautions should be duly noted

With all this AUTOMATIC tuning, What is left for the DBA to do?

DBA Configuration tasks, DBA Physical Design Tasks and Best practices, other Administrative Tasks



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.