Where does AutoSys Alarm "DB Problem ... XX.X% FULL ..." come from? Can it be adjusted?

Document ID : KB000054155
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

An alarm appears in the AutoSys Alarm Manager related to the AutoSys MDB.
The following may be seen:
AutoSys 4.x:

DB Problem <Date> <Time> <status> The Database: <DB_NAME> is XX.X% FULL! It needs to be cleared with:
archive_events <Inst_ID>
AutoSys 11.X
CAUAJM_I_60031 The AutoSys tables in MDB have used 1000.1 MB disk space.
CAUAJM_I_50179 *** ALARM Sent! ***

If AutoSys 11.x is forwarding events to NSM's Event Management Console:
CAUAJM_I_40245 EVENT: ALARM: DB_PROBLEM
<The AutoSys tables in MDB have used 1000.1MB disk space>

What is generating this alarm?
Can the alarm be modified to trigger in different thresholds?

Solution:

This alarm is generated when the "DBMaint" procedure is run. DBMaint is provided by AutoSys to archive historical AutoSys data from the MDB (or Event Server DB in AutoSys 4.x). As part of this process, DBMaint will call "dbstatistics" which in turn calls "dbspace". "dbspace" is the command which does a space check and issues the alarm if the defined DB threshold value for spaces used is exceeded.

AutoSys 4.x
You can set "DBSPACE_ALARM_PERCENT" to the percentage value you wish to be alarmed on when the threshold is reached.
DBSPACE_ALARM_PERCENT=80
Would result in an alarm being sent when 80% of the space has been used.
The default value is 75.

AutoSys 11.x
You can set "DBSPACE_ALARM_SPACE" to the total size of the combined tables you wish to be exceeded before sending an alarm.
DBSPACE_ALARM_SPACE=2000MB
Would result in an alarm being sent out only when the total combined size of the tables exceeds 2000MB.
The default is 1000MB

For additional information regarding dbspace, dbstatistics and DBMaint please refer to our product manuals:
Unicenter AutoSys Job Management Reference Guide
Unicenter AutoSys Job Management User Guide