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

Creating and configuring a multipartitioned database


In this recipe, we will proceed to create the NAV database as a multipartitioned database.

Getting ready

We will use nodedb21 and nodedb22 for all recipes in this chapter. The NAV database will be created under instance db2instp, created and configured in the Creating and configuring instances for a multipartitioned environments recipe in Chapter 1, DB2 Instance—Administration and Configuration.

For database storage, we have defined a new Linux partition /data. The database storage path will reside on the /data/db2 directory.

How to do it...

  1. Navigate to the /db2partinst/db2instp/sqllib directory. Here, open db2nodes.cfg with your preferred editor; you should find three nodes already configured in the Creating and configuring an instance for multipartitioned environments recipe, in Chapter 1, DB2 Instance—Administration and Configuration:

    [db2instp@nodedb21 sqllib]$ more db2nodes.cfg
    0 nodedb21 0
    1 nodedb22 0
    2 nodedb21 1
    

    These three nodes...