9.14. Configuration for the db2connect check

Check if a connect and a select count(*) from syscat.tables works fine on your database

The following SQL command will be used:

select count(*) as tables from syscat.tables

DB2CONNECT

Explanation

DB2CONNECT is the enclosing tag for all databases to check.

Parent

OSAGENT

allowed values

Count

0 or 1. If you don't define DB2CONNECT, no db2connect check will run.

Example
<DB2CONNECT>
  <DATABASE>
    <DB2PROFILE>/home/osmart/sqllib/db2profile</DB2PROFILE>
    <DB2ALIAS>osmart</DB2ALIAS>
  </DATABASE>
  <DATABASE>
    <DB2PROFILE>/home/osmart2/sqllib/db2profile</DB2PROFILE>
    <DB2ALIAS>osmart2</DB2ALIAS>
    <USERNAME>user1</USERNAME>
    <PASSWORD>secret</PASSWORD>
  </DATABASE>
</DB2CONNECT>
        

DATABASE

Explanation

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

Parent

DB2CONNECT

allowed values

Count

As many as you like.

Example

Look at DB2CONNECT