 | Level: Intermediate Paul Read (paul_read@uk.ibm.com), Product Introduction Manager, IBM
Eva Angelika Billich (bch@de.ibm.com), Senior DB2 Consultant for Strategic IBM Business Partners in Europe, Middle East, and Africa, IBM
30 Nov 2006 Starting in IBM® DB2® 9, a new memory-tuning feature, self-tuning memory management, simplifies the task of memory configuration by automatically setting values for
several memory configuration parameters. When enabled, the memory tuner dynamically
distributes available memory resources among several memory consumers, including sorts, the package cache, the lock list, and buffer pools. In this tutorial, walk through a series of
exercises to understand and learn how to administer this new feature.
Objectives
Familiarize you with concepts and capabilities of self tuning in
DB2 9, such as self-tuning memory overview and logon, self-tuning memory and
SORTHEAP, self-tuning memory and PCKCACHESZ, self-tuning memory and
LOCKLIST, and self-tuning memory and health checking.
Prerequisites
None
System requirements
To run the examples in this tutorial, you need the following installed on your
machine: DB2 9 Express-C is available from the DB2 9 Data Server link above. See the
tutorial "DB2 XML
evaluation guide (developerWorks, June 2006) for steps on installing DB2.
Unless the DB2 configuration is altered, then DB2 will automatically start after installation. Use the samples scripts and data provided in the stmm_zipped.zip file, included in
the tutorial, to demonstrate the concepts in this
tutorial. Extract the contents into a subdirectory called stmm_scripts (
C:\stmm_scripts or home/userid/stmm_scripts, for example). This directory will be
referred to simply as stmm_scripts throughout the tutorial. This tutorial assumes
that you have used the default directories for the DB2 installation and all the DB2 exercises are performed by a database administrator id.
Formats html, pdf
Tutorial overview
The exercises in this tutorial enable you to work with the DB2 self-tuning memory feature
and to have available memory resources dynamically distributed among several memory
consumers, including sorts, the package cache, the lock list, and buffer pools.
They have been developed to demonstrate one or more tasks found within each of the areas.
| | | |
