 | Level: Introductory 28 Oct 2009 Learn how to use the Configuration Advisor, the Design Advisor, and autonomic features, such as the self-tuning memory manager,
to reduce the human costs associated with DB2® maintenance. Help your organization develop a holistic view of reducing costs across hardware, software, and maintenance
over time as part of the lost-cost evolution.
In this article
- DB2 databases and total cost of ownership
- Standardization
- Business strategy
- Cost reduction features and technology
- DB2 database cost reduction features at a glance
- Planning your system
- Installing DB2 systems
- Configuring DB2 systems
- The DB2 Configuration Advisor
- Improving buffer pool usage using prefetchers and page cleaners
- The DB2 Design Advisor
- Tips for using the DB2 Design Advisor
- DB2 Design Advisor for partitioned databases
- Maintaining DB2 systems
- The self-tuning memory manager
- Automatic storage
- Automatic maintenance
- Automatic RUNSTATS and real-time statistics
- Reducing hardware costs
- Reducing troubleshooting costs
Introduction
This article is written primarily for database administrators (DBAs) and focuses on rapid cost reduction practices for the DB2
database. The goal of the article is to free up DBAs to put more focus, time, and effort into moving the business forward. In the
spirit of lowering costs, we'll skip a long introduction and jump right in.
There are three aspects of enterprise cost reduction:
- IT practices including standardization
- Business strategies such as master data management that can consolidate and streamline your business
- Cost reduction features and technology
We'll highlight each briefly and then go into depth on the last topic, as it is the primary focus of this paper.
Download | Description | Name | Size | Download method |
|---|
| Article in PDF format | DB2BP_Cost_Reduction_1009I.pdf | 590KB | HTTP |
|---|
Resources Learn
Get products and technologies
Discuss
Rate this content
| | | |
