9.13. Configuration for the db2applications check

9.13. Configuration for the db2applications check
Prev	Chapter 9. Configure the OpenSMART agents	Next

Check your db2 database for the maximum number of active applications.

Active applications will be identified by:

db2 list applications

The maximum number of possible applications is identified by MAX_AGENTS parameter (dbm cfg).

You can define thresholds (in percent).

DB2APPLICATIONS

Explanation

DB2APPLICATIONS is the enclosing tag for all databases to check.

Parent

OSAGENT

allowed values

DATABASE

Count

0 or 1. If you don't define DB2APPLICATIONS, no db2applications check will run.

Example

<DB2APPLICATIONS>
  <DATABASE>
    <DB2PROFILE>/home/osmart/sqllib/db2profile</DB2PROFILE>
    <DB2ALIAS>osmart</DB2ALIAS>
    <THRESHOLD>
      <PERCENT>70</PERCENT>
      <ERRORLEVEL>WARNING</ERRORLEVEL>
      <DESCRIPTION>if permits, increase MAX_AGENTS parameter</DESCRIPTION>
    </THRESHOLD>
    <THRESHOLD>
      <PERCENT>90</PERCENT>
      <ERRORLEVEL>ERROR</ERRORLEVEL>
    </THRESHOLD>
  </DATABASE>
  <DATABASE>
    <DB2PROFILE>/home/osmart/sqllib/db2profile</DB2PROFILE>
    <DB2ALIAS>osmart</DB2ALIAS>
    <THRESHOLD>
      <PERCENT>80</PERCENT>
      <ERRORLEVEL>WARNING</ERRORLEVEL>
      <DESCRIPTION>if permits, increase MAX_AGENTS parameter</DESCRIPTION>
    </THRESHOLD>
  </DATABASE>
</DB2APPLICATIONS>

DATABASE

Explanation

for every database you want to check you you define the DATABASE-pair

Parent

DB2APPLICATIONS

allowed values

THRESHOLD
DB2PROFILE
DB2ALIAS
The common XML tags as described in Section 9.8, “Tags Common to All Checks and/or Checkpoints”

Count

As many as you like.

Example

Look at DB2APPLICATIONS

THRESHOLD

Explanation

This entity describes a threshold pair (percentage of agents which are in use)

Parent

DATABASE

allowed values

Count

1 or more.

Example

<DB2APPLICATIONS>
  <DATABASE>
    <DB2PROFILE>/home/osmart/sqllib/db2profile</DB2PROFILE>
    <DB2ALIAS>osmart</DB2ALIAS>
    <THRESHOLD>
      <PERCENT>70</PERCENT>
      <ERRORLEVEL>WARNING</ERRORLEVEL>
      <DESCRIPTION>if permits, increase MAX_AGENTS parameter</DESCRIPTION>
    </THRESHOLD>
    <THRESHOLD>
      <PERCENT>90</PERCENT>
      <ERRORLEVEL>ERROR</PERCENT>
    </THRESHOLD>
  </DATABASE>
  <DATABASE>
    <DB2PROFILE>/home/osmart/sqllib/db2profile</DB2PROFILE>
    <DB2ALIAS>osmart</DB2ALIAS>
    <THRESHOLD>
      <PERCENT>80</PERCENT>
      <ERRORLEVEL>WARNING</ERRORLEVEL>
      <DESCRIPTION>if permits, increase MAX_AGENTS parameter</DESCRIPTION>
    </THRESHOLD>
  </DATABASE>
</DB2APPLICATIONS>

Prev	Up	Next
9.12. Configuration for the db2lck check	Home	9.14. Configuration for the db2connect check