Managing IBM DB2 Databases

CA SRM provides a licensed option that collects storage usage data from DB2 databases.

This chapter describes how to use this option. It includes the following topics:

DB2 support
DB2 objects
Registering DB2 databases
Defining a Query service
Defining an Automate service

This section contains the following topics:

IBM DB2 Support

IBM DB2 Objects

Registering IBM DB2 Databases

Defining a Query Service

Defining an Automate Service

IBM DB2 Support

CA SRM assembles and presents the information you need to manage your database storage more efficiently. CA SRM collects a variety of data to assist you in such tasks as tuning your system, setting alerts, planning capacity, reporting on raw devices, and so on. You can display unified views of data collected from multiple database instances running on different platforms. CA SRM logs on to all the databases automatically at scheduled times.

You can use CA SRM to perform the following tasks:

Present complete logical volume information by combining data reported by the DB2 server with raw device data collected by the CA SRM Agent
Monitor size, free space, and occupied space information for servers, databases, indices, tables, and long table
Analyze trends for servers, databases, tables, and long tables
Set alerts when certain conditions are met

Data Collection

The DB2 Storage Management GUI displays the size and capacity values of the database in megabytes. It only displays these values as whole numbers. CA SRM manages these values in bytes and then displays them as megabytes. As a result, you might see a difference in the values between the two interfaces.

Note: To help ensure that the Windows Client displays the most recent data collection, refresh open user views.