Skip to Content
Information

This site will undergo a brief period of maintenance on Friday, 18 December at 12:30 AM Central/12:00 PM IST. During a 30 minute window, site availability may be intermittent.

Default language.

General Db2 system monitors

The monitors listed in the following table measure Db2 system activity and status.

Related topic

Alphabetical-reference-of-monitors

Monitor

Title

View

Description, Parameters, Warning

DSOPN

Database Data Sets Open

DDSOPN

Reports the number of open Db2 database data sets during the sampling period

Parameters: none

Error
Warning

DS0030W (nn) hh:mm:ss DB DATASETS OPEN(TOTAL) = v (>thrshld)

DSOPR

Database Data Set Open Requests

DDSOPR

Reports the number of successful open requests for database data sets by buffer pool during the sampling period

If a large number of databases are specified to open automatically at Db2 startup, a measurement spike occurs at startup.

Parameters: [BP0–BP49|BP8K0–BP8K9| BP16K0–BP16K9|BP32K–BP32K9]

Error
Warning

DS0040W (nn) hh:mm:ss DB DATASET OPEN REQUESTS(parm) = v IN x intrvl (>thrshld)

DSUTL

Open Database Data Set Utilization

DDSUTL

Reports the percentage of the maximum number of concurrently accessible Db2 database data sets (DSNZPARM value DSMAX) that are open during the specified time interval

Parameters: none

Error
Warning

DS0050W (nn) hh:mm:ss OPEN DB DATASET % UTIL(TOTAL) = v (>thrshld)

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Ops Monitor for Db2 13.1