Published on 18-Oct-2006
"“With DB2 9, we’re seeing compression rates up to 83 percent on the data warehouse tables. The projected cost savings are more than US$2 million initially with ongoing savings of US$500,000 a year.” " - Michael Henson, DB2 Unix Team Lead, Database Delivery Services, SunTrust Bank, Inc.
Customer:
SunTrust Bank, Inc.
Industry:
Banking, Financial Markets
Deployment country:
United States
Solution:
Business Intelligence, Data Warehouse, Information On Demand
Overview
Headquartered in Atlanta, SunTrust Bank, Inc., is one of the nation’s largest banking organizations, with total assets of US$181 billion, more than 1,600 branches, and more than 34,000 employees. The bank serves a broad range of consumer, commercial, corporate and institutional clients and operates an extensive distribution network, primarily in Florida, Georgia, Maryland, North Carolina, South Carolina, Tennessee, Virginia and the District of Columbia.
Business need:
SunTrust Bank set out to reap more returns on its investment in its IT infrastructure, including the memory, storage and servers in its database environment. At the same time, SunTrust wanted to manage risk and compliance and increase the productivity of its database administrators.
Solution:
To achieve these goals, SunTrust migrated its IBM System p5™ p575 servers from IBM DB2 8 to the new DB2 9 data server.
Benefits:
Average compression of 83 percent on the data warehouse
Projected initial cost savings of more than US$2 million
Ongoing savings of US$500,000 per year
The ability to install multiple DB2 versions and fix packs on the same computer
Table partitioning benefits of increased query performance via partition elimination
Self Tuning Memory Manager (STMM) senses the underlying workload and tunes the memory based on need
Performance and scalability enhancements
Case Study
Overview
SunTrust Bank, Inc.
Atlanta, Georgia, United States
www.suntrust.com
Industries
• Banking
• Financial Markets
Products
• IBM DB2® 9 data server
• IBM System p™ servers
• IBM System z™ servers
• IBM AIX® operating system
• IBM z/OS® operating system
“With DB2 9, we’re seeing compression rates up to 83 percent on the data warehouse tables. The projected cost savings are more than US$2 million initially with ongoing savings of US$500,000 a year.”
—Michael Henson, DB2 Unix Team Lead, Database Delivery Services, SunTrust Bank, Inc.
Background
Headquartered in Atlanta, SunTrust Bank, Inc., is one of the nation’s largest banking organizations, with total assets of US$181 billion, more than 1,600 branches, and more than 34,000 employees. The bank serves a broad range of consumer, commercial, corporate and institutional clients and operates an extensive distribution network, primarily in Florida, Georgia, Maryland, North Carolina, South Carolina, Tennessee, Virginia and the District of Columbia.
Challenge
SunTrust Bank set out to reap more returns on its investment in its IT infrastructure, including the memory, storage and servers in its database environment. At the same time, SunTrust wanted to manage risk and compliance and increase the productivity of its database administrators.
Solution
To achieve these goals, SunTrust upgraded its IBM System p5™ p575 servers from IBM DB2 8 to the new DB2 9 data server.
Benefits
With the deep compression capabilities of DB2 9, SunTrust is seeing:
• Average compression of 83 percent on the data warehouse tables
• Projected initial cost savings of more than US$2 million
• Ongoing savings of US$500,000 per year
SunTrust is also finding that DB2 9 provides:
• The ability to install multiple DB2 versions and fix packs on the same computer
• Table partitioning benefits of increased query performance via partition elimination
• Self Tuning Memory Manager (STMM) senses the underlying workload and tunes the memory based on need
• Performance and scalability enhancements
To manage risk and compliance, SunTrust Bank will be implementing the new Label Based Access Control feature of DB2 9. Also, the new Security Administration Authority will allow SunTrust to give its enterprise risk management group the ability to control security within the database.
SunTrust expects to meet its goal of increased DBA productivity using the STMM and automatic storage enhancement features of DB2 9.
| Overview |
| SunTrust Bank, Inc. Atlanta, Georgia, United States www.suntrust.com |
| Industries
• Banking • Financial Markets |
| Products
• IBM DB2® 9 data server • IBM System p™ servers • IBM System z™ servers • IBM AIX® operating system • IBM z/OS® operating system |
| “With DB2 9, we’re seeing compression rates up to 83 percent on the data warehouse tables. The projected cost savings are more than US$2 million initially with ongoing savings of US$500,000 a year.”
—Michael Henson, DB2 Unix Team Lead, Database Delivery Services, SunTrust Bank, Inc. |
Products and services used
IBM products and services that were used in this case study.
Hardware:
System p
Software:
DB2 9 for Linux, UNIX and Windows
Operating system:
AIX, z/OS and OS/390
Footnotes and legal information
G507-1751-09
© Copyright IBM Corporation 2006
IBM CorporationSoftware GroupRoute 100Somers, NY 10589U.S.A.
Produced in the United States of America
12-06 All Rights Reserved
AIX, DB2, IBM, the IBM logo, System p, System p5, System z and z/OS are trademarks of International Business Machines Corporation in the United States, other countries or both.
Other company, product and service names may be trademarks or service marks of others.
The information contained in this documentation is provided for informational purposes only. While efforts were made to verify the completeness and accuracy of the information contained in this documentation, it is provided “as is” without warranty of any kind, express or implied. In addition, this information is based on IBM’s current product plans and strategy, which are subject to change by IBM without notice. IBM shall not be responsible for any damages arising out of the use of, or otherwise related to, this documentation or any other documentation. Nothing contained in this documentation is intended to, nor shall have the effect of, creating any warranties or representations from IBM (or its suppliers or licensors), or altering the terms and conditions of the applicable license agreement governing the use of IBM software.
