When the Scheduler runs DBMaint, the following messages occur:
From The Scheduler Log:
05/22/2017 03:33:27] CAUAJM_E_20220 DB Maintenance returned an exit code of 1.
[05/22/2017 03:33:27] ______________________________________________________________________________
05/22/2017 03:33:27] CAUAJM_I_40265 ****<Date:05/22/201703:33:27>****
[05/22/2017 03:33:27] CAUAJM_I_40245 EVENT: ALARM ALARM: DBMAINT_FAILURE TEXT: <Error encountered while running DBMaint script!>
From $AUTOUSER/out/DBMaint out:
CAUAJM_W_10406 Control Execute Access Denied!
CAUAJM_W_10439 No policies granting access to resource.
CAUAJM_W_10440 Class: as-control Resource: PR1.ARCHIVE_JOBS User: SYSTEM Access: execute
What is the cause of the message and how can it be prevented?
The DBMaint script runs the archive_jobs command. Access to this command is controlled by the ARCHIVE_JOBS WAAE policy in EEM under the as_control resource class.
The user that runs the Scheduler needs to be granted 'execute' in the ARCHIVE_JOBS policy. In Windows this is usually SYSTEM. For Unix, it is typically the user that was specified as the application owner during installation.