I am using CA Compliance Event Manager with DB2 for z/OS V11 and getting message CEM0420E SQL ERROR SQLCODE: FFFFFEB9 SQLERRM: What cause this error?

Document ID : KB000012816
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

This error is issued by the CA Compliance Event Manager (CEM) data warehouse component as a result of an SQL failure. The SQL error code was provided but not the content of the error message field. 

Question:

I am using CA Compliance Event Manager 5.0 with DB2 for z/OS 11 and getting message CEM0420E SQL ERROR SQLCODE: FFFFFEB9 SQLERRM. 

What cause this error?

Environment:
CA Compliance Event Manager 5.0 or 6.0 and DB2 for z/OS version 11.
Answer:

The Compliance Event Manager CEM0420E message is just passing back the return codes from DB2. Because the return codes can vary the CEM0420E message just returns the DB2 return codes. 

The FFFFFEB9 SQL code translates to -327 which indicates that a row can not be inserted because it is outside the bound of the partition range for the last partition. 

This is a -327 error which is caused by no partitions available for the Insert. Several tables in warehouse are partitioned and they use the time stamp to determine which partition to use. There are no partitions defined for the current time stamp so you get the -327 SQL error. 

Initially, most tables in the Warehouse repository are defined with 12 partitions- one partition for each month of the year. The Warehouse component 
DB2 DDL statements let you control how much data each partition can hold based on your expected volume of data. The Compliance manager install is set up with partitions because DB2 has a hard 4-gigabyte limit on the amount of data it can handle in a single partition. The warehouse requires occasional maintenance to the partitions. 

For more information please review our CEM 5.0 DocOps link:

Unload Data and Manage Partitions for IBM DB2 Warehouse Repository

CEM 6.0 DocOps link:

Unload Data and Manage Partitions for IBM DB2 Warehouse Repository

 

Additional Information:

SQL error code -327 as per IBM Knowledge Center:

https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/codes/src/tpc/n327.html