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 is the enclosing tag for all databases to check.
0 or 1. If you don't define DB2CONNECT, no db2connect check will run.
<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>
for every database you want to check you you define the DATABASE-pair
The common XML tags as described in Section 9.8, “Tags Common to All Checks and/or Checkpoints”
As many as you like.
Look at DB2CONNECT