View Printable Version
C05 - Highlight Zone-MetLife DB2 LUW-Tooling Time
DB2 for LUW - I
Susan Sterling [Director - Metlife]
Grand Sierra H&I => Wed, May 01, 2013 (09:15 AM - 10:15 AM)
Sue Sterling is a Database Director and IBM Certified Solution Expert with a deep database background at MetLife as the enterprise continues to expand and globalize. Sue owns the health and stability of DB2 LUW engineering and architecture for nearly 2000 DB2 LUW databases. She has worked with databases for 15 years and in IT for 30 years, with DB2 LUW since its inception, and DB2 zOS before that. Sue is an early adopter of Optim Performance Manager (OPM), Netezza, Guardium, and a key member of the DB2 LUW Customer Council. Sue has authored and delivered technical presentations internationally in such locales as Nice, Hamburg, Berlin, San Jose, Orlando, Anaheim, Dallas and New York City.
Audience experience level:
DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to:
Application Developers, Data Architects, Database Administrators, Systems Programmers, New Users, IT Managers
Technical areas this presentation will apply to:
Database Performance (DB2 for LUW), High Availability (DB2 for LUW), New Release (DB2 for LUW), Tools and Utilities, User Experiences
If Tools and Utilities was selected which products:
Optim Performance Manager V5.1 (OPM), Self-Tuning Memory Management V9.7 (STMM), Work Load Manager V9.7 (WLM), HADR Read on Standby V9.7 (ROS), Oracle-Compatible Mode V10
Using a portrait of MetLife real applications, teach how to implement and use Optim Performance Manager 5.1 to very quickly allow DBAs to analyze and tune health and performance more quickly, eliminating the need for home-grown scripting and analysis.
Illustrate MetLife's experience, challenges, and shaping of Self-Tuning Memory Manager to free DBA time, more effectively distribute memory on hundreds of systems, and in some cases improve performance and ease CPU use.
Show MetLife's first implementation of Work Load Manager: our goals, our successes, and our challenges, including business rule definitions.
HADR has become mainstream at MetLife. Automated Client Reroute (ACR) is also popular. In 9.7 Read on Standby (HADR ROS) has become available. Here we will convey our experiences and practical tips with ROS considering the strengths and restrictions.
In DB2 LUW V10 Oracle-Compatible Mode is said to be 99% transparent, up from 95% in V9.7 without developer intervention. Describe our Oracle-Compatible proof of concept and findings which have helped us target Oracle database applications to convert to DB
At MetLife we “create time” for our DBAs with performance, availability, cost reduction, and expense avoidance tools. The presentation shares our DB2 LUW footprint with easy-to-follow examples illustrating OPM 5, STMM, WLM, ROS and V10 Oracle-compatibility