DBMaint Fails With Exit Code 1 When Executing archive_jobs

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

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?

Answer:

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.