Articles & Content

Archives

MetLife's Fruitful Prototype:DB2 9 (E01)

Topic: DB2 for LUW

Subtopic: 2008



DATE: 2008-5-19 (09:45 AM - 10:45 AM)
SPEAKERS: Susan Sterling (MetLife)

At MetLife we set up a DB2 9 lab as "all-automatic" to pilot a cost savings strategy to keep DBA costs level while supporting a 20% growth in databases.We set all maintenance, memory, CPU, monitoring "on autopilot" on p595 hardware which itself uses virtual CPU and I/O.Based on our experiences we built a plan to deploy the most successful elements to our 600+ UDB instances on 200+ p595 VPARs with 100+TB of data. The presentation illustrates results and best practice recommendations gleaned from the experiment with charts and examples of levels of success through each phase of support automation.

EXP. LEVEL: Intermediate

OBJECTIVES:

Learn to reduce human intervention without reducing quality when installing base DB2 9 software and fixpacks on hundreds of VPARs

Practice exploiting Performance Expert and Query Patroller to manage performance and workload

Plan to save money with many UDB instances sharing virtualized hardware while safely managing CPU and RAM

Enable your organization to flatten DBA cost increases while supporting database growth by setting as much maintenance and monitoring as is safely possible "on autopilot"

Reduce new cost outlays for storage through data compression while preserving, or improving, performance. Charts of our experiences will be provided.



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.