Book Image

IBM DB2 9.7 Advanced Administration Cookbook

Book Image

IBM DB2 9.7 Advanced Administration Cookbook

Overview of this book

IBM DB2 LUW is a leading relational database system developed by IBM. DB2 LUW database software offers industry leading performance, scale, and reliability on your choice of platform on various Linux distributions, leading Unix Systems like AIX, HP-UX and Solaris and MS Windows platforms. With lots of new features, DB2 9.7 delivers one the best relational database systems in the market. IBM DB2 9.7 Advanced Administration Cookbook covers all the latest features with instance creation, setup, and administration of multi-partitioned database. This practical cookbook provides step-by-step instructions to build and configure powerful databases, with scalability, safety and reliability features, using industry standard best practices. This book will walk you through all the important aspects of administration. You will learn to set up production capable environments with multi-partitioned databases and make the best use of hardware resources for maximum performance. With this guide you can master the different ways to implement strong databases with a High Availability architecture.
Table of Contents (21 chapters)
IBM DB2 9.7 Advanced Administration Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

There's more...


We've just covered basic commands, but there are many more aspects to discuss concerning the implementation, and some of these have an important performance impact.

Raw partitions

A container in this type of table space can be defined as a regular OS file or can be defined as a raw partition.

We do not recommend the use of raw partitions, since this adds complexity in disk and space management. A well-tuned DMS table space, that has containers defined as data files, will perform as well as containers defined as raw partitions.

Space allocation

Space is preallocated in the DMS table space. When multiple containers are defined, they are filled in round-robin fashion, one extent in each container. When autoresize is used, the containers will grow automatically, until maxsize value is reached, or until the filesystem is full, whichever comes first.

Tables and objects

A table can be split into multiple table spaces by:

  • Regular table data

  • Indexes

  • Long field and LOB data

Filesystem caching...