Articles & Content


MetLife's Fruitful Prototype:DB2 9 (E01)

Topic: 2008 NA

Subtopic: DB2 for LUW

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


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.

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.