Database maintenance process in Compliance Event Manager

Products

• Compliance Event Manager

Issue/Introduction

There is a monthly DB maintenance process for CEM, this job will alter tables OBJACCESS and SYSACCESS. What is the best method to stop the CMGRWHSE task connecting to these tables during the maintenance process? These commands F CMGRWHSE,REFRESH MSWMWAREHMTH are run before the DBA process, but this doesn't stop any activities in CEM, so there is resource contention in the DBA job.

 

Environment

z/os CEM DB2 Datacom

Cause

DB contention 

Resolution

The best way to ensure the issue is solved permanently is to stop the Warehouse task when the maintenance is being done.