Before you start
Before you start, read about what is covered in this tutorial, prerequisites, and system requirements.
The purpose of this tutorial is to show you how to enable some of the autonomic features of IBM DB2 9.7 for Linux, UNIX, and Windows, and how to automate some routine database maintenance tasks. These features and techniques are particularly useful when you are embedding a DB2 database server instance in a virtual environment.
The tutorial covers the following topics:
- Enabling automatic maintenance
- Automatic database backup and restore
- Automatic statistics collection
- Automatic reorganization
- Enabling silent updates to the database server
- Enabling self-tuning memory manager
- Enabling automatic storage management
This tutorial is written for IBM DB2 database administrators, application architects, and developers. You should have a general familiarity with installing and configuring DB2, and using a UNIX or Linux command-line shell.
To run the examples in this tutorial, you need a Linux or UNIX system with DB2 9.7 installed. You must have root access to the operating system and instance owner access to DB2.
The tutorial includes a toolkit that consists of scripts and policy files you can use to enable and configure the features described in the tutorial. These scripts and policy files are packaged in a file named embed-bundle.zip that you can obtain from the Download section of this tutorial.
Copy the embed-bundle.zip file to the target computer that is running DB2, login to the computer as the DB2 instance owner (for example, db2inst1), and use the commands shown in Listing 1 to unpack the toolkit.
Listing 1. Commands to unpack the embed-bundle.zip toolkit
mv embed-bundle.zip /home/db2inst1 unzip /home/db2inst1/embed-bundle.zip chmod +x /home/db2inst1/embed-bundle/*.sh
Note: The toolkit is developed specifically for DB2 9.7 running on either Linux or UNIX. However, if you want to use it for DB2 9.7 running on Windows, you should be able to do so with only minor modifications.
One of the files in the toolkit is
a sample DB2 script named
This script creates a database and modifies the configuration of the database to enable
the autonomic features discussed in this tutorial.