CAUAJM_I_40245 ALARM: DB_PROBLEM The AutoSys tables have used xxxx MB

Discussion created by trich06 on Jan 7, 2014
Latest reply on Dec 23, 2014 by Michael.Phan

Sometimes you may see this message after DBMaint has run: "CAUAJM_I_40245 ALARM: DB_PROBLEM The AutoSys tables have used xxxx MB disk space".

Explanation:  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.

Solution: <Caveat> you/your DBA, have validated the database "health" and table space sufficiency.

Script the variable "DBSPACE_ALARM_SPACE in the environment profile of any user that will be running the dbspace command, like so:

[the 2000MB is an arbitary value that has been used as an example]

If you use an Oracle database, the DBMaint command may erroneously report that the database is nearly full. This can occur because DBMaint calculates how much space is not allocated for extents. DBMaint reports entire extents as used space even when they are nearly empty.