Database Monitor (iSeries)

Use

You can use the SAP database monitor for iSeries to perform the following tasks:

·        Daily monitoring of the database for both test and production systems

·        Analysis of certain types of problems

Since all data comes from the database server, you can retrieve the same data from every application server of your SAP system.

Integration

The SAP database monitor for DB2 UDB for iSeries is part of the Computing Center Management System (CCMS).

Prerequisites

Parameter as4/dbmon/enable in the instance profile must be set to the value ON. The memory-resident database monitor is started automatically for an SAP instance provided the parameter has this value. If you change this value to OFF, the database monitor is switched off.

Under normal circumstances, you should not change this value. The only situation when we would recommend you to switch off the database monitor is if you have serious performance problems that have already been analyzed and you are waiting for additional hardware to be delivered.

Statistics will be cleared after an IPL of the database server.

Data for the Database Monitor

The SAP database monitor for iSeries gets its data from the memory-resident database monitor on your iSeries. This data is only supplied if the memory-resident database monitor is switched on.

The data is obtained as follows:

...

       1.      Report SAPMSSY6 runs every n seconds and submits report RSDB4DMP, where n is the value of the profile parameter rdisp/autoabaptime.

       2.      Report RSDB4DMP initiates a regular database monitor dump every 300 minutes (by default).

       3.      Report RSDB4DMP schedules report RSDB4UPD.

       4.      Report RSDB4UPD initiates an update of the performance tables.

This merge supplies all monitors, except the database monitor history, with the necessary information.

       5.      Report RSDB4DMP also initiates a history database monitor dump every 60 minutes (by default) and schedules report RSDB4DBH.

       6.      Report RSDB4DBH calculates the work load statistics that is stored in the database table MONI and displayed in the database monitor history.

To set the interval between two regular dumps and two history dumps, see Database Monitor Configuration (iSeries).

If data is not being supplied to the database monitor, check the status of QXDAEDRSQL.

Make sure that job QXDAEDRSQLis in the QSYSWRK subsystem. If you do not find the job, enter command STARTSAP *DB at operating system level.

Additional Information

On all screens within the SAP database monitor for iSeries a group box is displayed providing system information. The following fields appear on each screen:

Field

Description

System

System

System ID of the System for which data is displayed in the Cockpit for iSeries

DB Server

Server which provides the database service

Total DB Time (s)

Total processing time of all executed SQL statements

Database Monitor

Database Start

Date and time when the database server was started

Last Analysis

Date and time when RSDB4UPD last run

Last Reset

Date and time since last reset of data in tables

The following sections provide information on the database:

·         Overview (iSeries)

·         SQL Statements (iSeries)

·         Table Scans (iSeries)

·         Sorts (iSeries)

·         Used Indexes (iSeries)

·         Created Indexes (iSeries)

·         Advised Indexes (iSeries)

·         Temporary Files (iSeries)

·         Database Monitor Activity (iSeries)

·         Database Monitor Configuration (iSeries)