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

I/O tuning


Disk Input/Output is the main bottleneck in a computer system. Since access from disk is 1000 times slower than memory, we must ensure maximum response.

The first thing we should discuss is transaction logs . Best practices in the industry recommend a separate, local, physical disk dedicated to this task, or ideally a RAID 1 configuration. Since DB2 writes to transaction logs in append mode, having a dedicated disk ensures that the write head is always ready to write without needing seek time.

The second thing to discuss is your debugging. Make sure the diagnostic logs are separated from the data. If you have event monitoring turned on, make sure it is separated from your tables and indexes. All explain plan tables (EXPLAIN.DDL) should follow the same rule.

The third thing to discuss is the number of spindles available for the database. In the case of RAID storage, or for individual drives, the rule of thumb is to configure at least 10 to 20 disks, per processor.

The next item in...