DB2 JWP on 21.0.8 startup error: 'com.automic.xevents.XEventsCleanupComponent'

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation

Issue/Introduction

When starting a JWP with DB2 as the backend database, the following errors occur in the JWP log:

20230915/142948.751 - 37     U00045448 Planned cleanup of XEvents table could not be performed.
20230915/142948.751 - 37     U00045014 Exception 'com.automic.database.api.DBException: "TRUNCATE TABLE XEVT5 IMMEDIATE"' at 'com.automic.database.impl.DBConnectionImpl.executeInternal():573'.
20230915/142948.751 - 37     U00045015 The previous error was caused by 'com.ibm.db2.jcc.am.SqlException: "DB2 SQL Error: SQLCODE=-428, SQLSTATE=25001, SQLERRMC=null, DRIVER=4.31.10"' at 'com.ibm.db2.jcc.am.b7.a():815'.
20230915/142948.751 - 37     U00003620 Routine 'com.automic.xevents.XEventsCleanupComponent' forces trace because of error.
20230915/142948.767 - 37     U00003450 The TRACE file was opened with the switches '0000000000000000'.
20230915/142949.798 - 37     U00003449 Output to the TRACE file is finished.
20230915/142949.798 - 37     U00003434 Server routine  'XEventsCleanupComponent/TIMER' required '0' minutes and '11' seconds for processing.

This error also shows up once a day after startup.

Environment

Database: DB2
Automic version: Prior to 21.0.9

Cause

DB2 9.7 introduced a TRUNCATE TABLE statement that must be first in a transaction and was not

Resolution

This is fixed with 21.0.9 which has been released.

There is no impact caused by this other than displaying an error message in the logs