Optim Performance Manager (OPM) shows ERRORCODE=-4220 on "Current Application Connections" screen
Optim Performance Manager (OPM) shows the ERRORCODE=-4220 error when using the "Current Application Connections" screen
In Current Application Connections screen, OPM shows the following exception:
[jcc][3.63.81] Exception occurred during clob conversion.
See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null
com.ibm.db2.jcc.am.SqlException: [jcc][3.63.81] Exception
occurred during clob conversion. See attached Throwable for details.
The OPM database code page is configured as UTF.
When the Driver converts CLOB bytes to UTF characters driver is encountering invalid UTF data, causing the -4220 error.
You will see a SQL exception on the resultset.getClob() call with error code -4220.
Diagnosing the problem
On the Current Application Connections dashboard, OPM displays the SQL statement text by running this query via JDBC :
SELECT T1.STMT_TEXT as STMT_TEXT, \
T1.STMT_OPERATION as STMT_OPERATION, \
DEC(DOUBLE((T1.STMT_ELAPSED_TIME_S * 1000000)+ T1.STMT_ELAPSED_TIME_MS)/1000000,8,3) as STMT_ELAPSED_TIME_S, \
DEC(DOUBLE((T1.STMT_SYS_CPU_TIME_S * 1000000)+ T1.STMT_SYS_CPU_TIME_MS)/1000000,8,3) as STMT_SYS_CPU_TIME_S, \
DEC(DOUBLE((T1.STMT_USR_CPU_TIME_S * 1000000)+ T1.STMT_USR_CPU_TIME_MS)/1000000,8,3) as STMT_USR_CPU_TIME_S \
FROM SYSIBMADM.SNAPSTMT T1, \
SYSIBMADM.APPLICATIONS T2 \
WHERE T1.AGENT_ID = T2.AGENT_ID \
AND T1.DBPARTITIONNUM = T2.DBPARTITIONNUM \
AND T1.STMT_TYPE = 'DYNAMIC' \
AND TRIM(T1.DB_NAME) = 'replaceDBName' \
AND T1.AGENT_ID =
The STMT_TEXT column is a CLOB column. Please check if this column has certain problematic characters.
Resolving the problem
From a command window, follow these steps:
1. Stop OPM by running the <OPM_install>/bin/OPMStop.sh script
2. Set the JAVA_OPTS environment variable:
3. Start OPM by running the <OPM_install>/bin/OPMStart.sh script
More support for:
Optim Performance Manager for DB2 for Linux, UNIX and Windows
Software version: 5.1
Operating system(s): AIX, HP-UX, Linux, Solaris, Windows
Reference #: 1609599
Modified date: 2013-03-28