Compliance Event Manager with DB2 for z/OS V11 receives, "CEM0420E SQL ERROR SQLCODE: FFFFFEB9 SQLERRM:"

Products

• Compliance Event Manager

Issue/Introduction

 Error, " CEM0420E SQL ERROR SQLCODE: FFFFFEB9 SQLERRM", is issued by the 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. 

Resolution

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.