![Close [x]](http://dw1.s81c.com/i/c.gif){kind=small}
The IBM Smart Analytics System can be expanded to accommodate growth in users and data, providing a scalable and flexible approach to data warehousing infrastructure needs.
This article provides details on the following recommendations:
- Good capacity planning practices can assist in early detection of trends in resource usage. You can create and document a performance baseline for each workload and a forecast baseline for the next 12 months. Align your service level objectives with capacity planning indicators so that metrics can be easily compared.
- Begin planning for storage expansion when storage capacity reaches 60% and is projected to reach 80% within 12 months.
- You can add a data module to expand storage capacity and reduce the data volume per database partition. Or, you can add a user module to increase the capacity of the system to accommodate users. When adding modules, remember that multi-generation environments might need multiple high availability groups. Ensure that you incorporate fail over and fail back testing into your expansion plan.
There are other, more general recommendations that apply as well. When planning an expansion, do not forget to include site preparation. Additional cooling, floor space, and network capacity might be needed to accommodate an expanded system.
You also need to take into account the operational implications of your expanded system. Review your backup and recovery infrastructure to ensure that you can maintain service level objectives after the expansion. Also, ETL applications and maintenance scripts need to be reviewed to accommodate the expanded system.
| Description | Name | Size | Download method |
|---|---|---|---|
| Article in PDF format | DB2BP_Warehouse_Expanding_SmartAnalytics_1211.pdf | 1,019KB | HTTP |
Information about download methods Get Adobe® Reader®
Learn
- Learn more about DB2 for Linux, UNIX, and Windows in the
DB2
Information Center.
- Learn more about
IBM
Smart Analytics System.
- Learn more about DB2 for Linux, UNIX, and Windows at the
DB2 page on developerWorks and
get the resources you need to grow your skills.
- Follow developerWorks on Twitter.
- Watch developerWorks on-demand demos advanced functionality for experienced
developers.
Get products and technologies
- Download a trial version of
DB2 for Linux, UNIX, and Windows.
Discuss
- Participate in the discussion forum.
- Get involved in the My developerWorks community. Connect with other developerWorks users
while exploring the developer-driven blogs, forums, groups, and wikis.
Garrett Fitzsimons is a Data Warehouse Best Practices Specialist based in the IBM Dublin lab. He has worked with transactional and data warehouse database applications since 1990 on a variety of vendor platforms. Garrett is currently focused on developing and promoting best practice guidelines for all areas of data warehousing and is dedicated to helping customers implement data warehouse and business analytics solutions on InfoSphere Warehouse and the IBM Smart Analytics System.
James Cho is a Senior Technical Staff Member and Chief Architect for IBM Smart Analytics Systems. He has been a technical leader of integrated warehouse solutions from the first formal offering known as BCU to Balanced Warehouse, and now IBM Smart Analytic Systems. He has over 15 years experience in BI solutions including data warehouse DBA, publication of industry-standard TPC performance benchmarks, and BI architecture and deployment. James graduated with a bachelor of science in computer science from the University of Texas in 1996.
