If you have an IBM Db2 database, chances are it might be using automatic storage table spaces. With Db2 automatic storage table spaces, storage is managed automatically by Db2. Because Db2 controls the table space containers, users cannot configure the containers, making them tricky to manage.
If you want to learn more about automatic storage table spaces then the IBM Redpaper IBM Db2: Investigating Automatic Storage Table Spaces and Data Skew is for you! This paper will guide you through the process of understanding their behavior. Understanding automatic storage table space characteristics will increase your Db2 problem determination skills and general Db2 knowledge
This IBM Redpaper will step you through:
- Automatic storage table space concepts
- Identifying automatic storage table spaces
- Data skew and physical data imbalance concepts
- Determining which automatic storage table spaces might have data imbalance
- Extent maps
- Table space maps
- Rebalancing data
- Reclaimable storage
- Db2 restore utility
- Problem determination for automatic storage table spaces ”gotchas”, common problems and their solution
The scope of this paper is limited to Db2 Linux, UNIX, and Windows operating systems. This document will give the reader an understanding of automatic storage table spaces s and how to manage them.
George Wangelien is a Senior Db2 UDB DBA for IBM Hybrid Cloud. George has over 22 years of Db2 for Linux, UNIX, and Windows experience at IBM. His interests include consulting, problem determination, high availability solutions, proof of concepts, and writing ksh scripts. His areas of expertise are production Db2 for Linux, UNIX, and Windows support and also the administration of SAP Db2 databases. George holds numerous IT and Db2 certifications, a Db2 patent and a Bachelor’s degree from Montclair State College, New Jersey, USA. George co-authored the IBM Redpaper IBM Db2: Investigating Automatic Storage Table Spaces and Data Skew.