DB2TS

Explanation

DB2TS is the enclosing tag for all DB2 tablespace-entries.

Parent

OSAGENT

allowed values

• TABLESPACE

Count

0 or 1. If you don't define DB2TS, no db2ts check will run.

Example

<DB2TS>
  <TABLESPACE>
    <DB2ALIAS>DBXXX</DB2ALIAS>
    <DB2PROFILE>/home/db2inst1/sqllib/db2profile</DB2PROFILE>
    <TABLESPACENAME>.*</TABLESPACENAME>
    <VALUE>80</VALUE>
    <FORMULA>PERCENT</FORMULA>
    <ERRORLEVEL>WARNING</ERRORLEVEL>
  </TABLESPACE>
  <TABLESPACE>
    <DB2ALIAS>DBXXX</DB2ALIAS>
    <DB2PROFILE>/home/db2inst1/sqllib/db2profile</DB2PROFILE>
    <TABLESPACENAME>.*</TABLESPACENAME>
    <VALUE>90</VALUE>
    <FORMULA>PERCENT</FORMULA>
    <ERRORLEVEL>ERROR</ERRORLEVEL>
  </TABLESPACE>

  <TABLESPACE>
    <DB2ALIAS>DBYYY</DB2ALIAS>
    <DB2PROFILE>/home/db2inst2/sqllib/db2profile</DB2PROFILE>
    <TABLESPACENAME>TSSPECIAL</TABLESPACENAME>
    <VALUE>95</VALUE>
    <FORMULA>PERCENT</FORMULA>
    <ERRORLEVEL>WARNING</ERRORLEVEL>
  </TABLESPACE>
  <TABLESPACE>
    <DB2ALIAS>DBYYY</DB2ALIAS>
    <DB2PROFILE>/home/db2inst2/sqllib/db2profile</DB2PROFILE>
    <TABLESPACENAME>TSSPECIAL</TABLESPACENAME>
    <VALUE>98</VALUE>
    <FORMULA>PERCENT</FORMULA>
    <ERRORLEVEL>ERROR</ERRORLEVEL>
  </TABLESPACE>

  <TABLESPACE>
    <DB2ALIAS>DBYYY</DB2ALIAS>
    <DB2PROFILE>/home/db2inst2/sqllib/db2profile</DB2PROFILE>
    <TABLESPACENAME>.*</TABLESPACENAME>
    <VALUE>80</VALUE>
    <FORMULA>PERCENT</FORMULA>
    <ERRORLEVEL>WARNING</ERRORLEVEL>
  </TABLESPACE>
  <TABLESPACE>
    <DB2ALIAS>DBYYY</DB2ALIAS>
    <DB2PROFILE>/home/db2inst2/sqllib/db2profile</DB2PROFILE>
    <TABLESPACENAME>.*</TABLESPACENAME>
    <VALUE>90</VALUE>
    <FORMULA>PERCENT</FORMULA>
    <ERRORLEVEL>ERROR</ERRORLEVEL>
  </TABLESPACE>
</DB2TS>
        

DB2ALIAS

Explanation

Which DB2 database on your server ?

Parent

TABLESPACE

allowed values

Any database alias in your catalog

Count

1

Example

Look at DB2TS

DB2PROFILE

Explanation

For different databases in different instances you need sometimes different DB2 profiles. Here you can include (if you want) the correct profile for your database. Just enter the whole path to the profile file.

Parent

TABLESPACE

allowed values

Any complete path to a db2 profile

Count

0 or 1

Example

Look at DB2TS