DAMON (Data Monitor) Procedures

Contents

The second database job is the DAMON data monitor job. The DAMON job runs the majority of the background processing and is responsible for running background clean up processes required by the application that can potentially take a relatively long time to run.

Oracle and DAMON

By default, DAMON runs every Saturday. It uses the Oracle DBMS_SCHEDULER package to schedule the jobs, and an Interval setting controls the schedule and accepts the same parameters as the DBMS_SCHEDULER interval. For more information, refer to your Oracle database documentation.

Microsoft SQL Server and DAMON

By default, DAMON runs every Saturday. You can set it to run every two weeks or on a specific day. To run DAMON every two weeks, use the following command to set the interval: -eg 2W

To set DAMON to run on a specific day, use the following setting under namespace: ‘Database.background.Damon’ DayOfWeek

DAMON Procedures

DAMON cleans the:

• BGPLOG table containing the background logs.
• REFRDEL table.
• PRMQUEUE table.
• Remaining USESSION records.
• Logically deleted records.
• PRMAUDIT table.
• USESSION audit table (USESSAUD).

You can also dynamically extend DAMON functionality via the user-defined procedure, USER_DEFINED_BACKGROUND.