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

Dropping buffer pools


When you no longer need a buffer pool, you can drop it. Another alternative is to set it to automatic tuning, so it will not take up unneeded space.

Getting ready

Ensure no table spaces have been assigned to this buffer pool.

How to do it...

  1. Create a fictitious buffer pool to be dropped later.

    In this example, this buffer pool should have been created in another database:

    [db2inst1@nodedb21 nav]$ db2 "create bufferpool pos_bpt32k pagesize 32 K"
    DB20000I  The SQL command completed successfully.
  2. View the table space association list.

  3. If the mistake has not been detected early enough, we may want to check if a table space has been associated with it:

    [db2inst1@nodedb21 nav]$ db2 "select substr(ts.tbspace,1,20),substr(bp.bpname,1,20)
      from sysibm.systable spaces ts right outer join
      sysibm.sysbufferpools bp
      on bp.bufferpoolid = ts.bufferpoolid"
    1                    2
    -------------------- --------------------
    SYSCATSPACE          IBMDEFAULTBP
    TEMPSPACE1           IBMDEFAULTBP...