Articles & Content


Speeding Toward Business Objectives - Exploiting UDB and Hardware Advances for BI/DSS at MetLife (I02)

Topic: DB2 for LUW

Subtopic: 2007

DATE: 2007-5-7 (11:10 AM - 12:10 PM)
SPEAKERS: Susan Sterling (MetLife)

A design profile of MetLife's international insurance and financial UDB DPF business intelligence/decision support warehouses will be presented. Concurrent with a broad 2006 refresh from p690 hardware and symmetrix SAN to p595 hardware and dmx SAN, MetLife seized all available UDB, AIX 5.3, and storage redesign opportunities for great gains on the key factors listed. Each technique adopted is related back to the business investment return it provided: Savings, Performance boost, Increased Availability.Objectives: Describe architecture of several MetLife warehouses where costs were cut, performance was enhanced, and availability was increased, including through consolidation of LPARs and instance, conversion to 64-bit, exploitation of virtual and fractional CPU,conversion from log-shipping to storage-based replication/mirroring, conversion from log-shipping to memory-based log shipping with HADR, adaptation of the BCU concept to our customized environment, capacity and sizing analysis

EXP. LEVEL: Intermediate


Achieve cost savings with UDB through strategic hardware use

Boost performance with UDB and AIX best practices

Achieve highest availability at lowest cost

Adapt IBM'c BCU concept for industry-specific purposes

See portraits of some of MetLife's BI/DDS warehouses where cost, performance and availability objectives have been met

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.