Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying IBM DB2 9.7 Advanced Administration Cookbook
  • Table Of Contents Toc
  • Feedback & Rating feedback
IBM DB2 9.7 Advanced Administration Cookbook

IBM DB2 9.7 Advanced Administration Cookbook

4.5 (8)
close
close
IBM DB2 9.7 Advanced Administration Cookbook

IBM DB2 9.7 Advanced Administration Cookbook

4.5 (8)

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)
close
close
IBM DB2 9.7 Advanced Administration Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Configuring the block-based area


Buffer pools are defined as having a large number of pages by default, so when DB2 issues a prefetch, the pages read from the disk may not be stored contiguously in the buffer pool.

The block-based area enhances prefetching performance by allowing a contiguous area of the buffer pool for this eventuality, named the block area, or block-based area. Each set of contiguous pages is called a block; the number of pages in a block is referred to as the blocksize.

Getting ready

Make sure the application uses sequential prefetching; otherwise the block area of the block buffer is useless. Allow a time frame for a possible database restart.

How to do it...

  1. Get the database configuration:

    [db2inst1@nodedb21 ~]$ db2 get db cfg
           Database Configuration for Database

    We'll be looking for parameters related to prefetching.

     Default prefetch size (pages)         (DFT_PREFETCH_SZ) = AUTOMATIC
     Default table space extentsize (pages)   (DFT_EXTENT_SZ) = 32
  2. Get current characteristics...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech

Create a Note

Modal Close icon
You need to login to use this feature.
notes
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Delete Note

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Edit Note

Modal Close icon
Write a note (max 255 characters)
Cancel
Update Note

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY