Difference Between CMGRD1 And CEMEQ1 Qualifiers In CEM

Products

• Compliance Event Manager

Issue/Introduction

What is the difference between the CMGRD1 and CEMEQ1 qualifiers for DB2 tables in Compliance Event Manager?

Environment

Release : 6.0

Component : COMPLIANCE EVENT MANAGER

Resolution

The CMGRD1 qualifier is the default qualifier for the (old) Compliance Manager Datamart database. It is similar to the (new) CEM Datamart database which has a qualifier of CEMED1 by default.

The CEMEQ1 qualifier is used for the CEM Warehouse database, which is different from the Datamart database. The Datamart database is the one that holds the data from a logger unload process.