2484373 - DB6: SQL0420N error for t-code DBACOCKPIT | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2484373 - DB6: SQL0420N error for t-code DBACOCKPIT

Symptom

You get the following error when running t-code DBACOCKPIT.

SQL0420N Invalid character found in a character string argument of the function "DECFLOAT". SQLSTATE=22018

Details:
Exception CX_DBA_ADBC in class CL_DB6_DATABASE method IS_AUTOSTORAGE line 49
Kernel Error ID:
SYSID: <SID>
SY-SUBRC: 0
SQL statement: SELECT COUNT(*) FROM SYSIBM.SYSDUMMY1, TABLE ( SNAP_GET_TBSP( '', 0 ) ) AS T1 WHERE T1.TBSP_USING_AUTO_STORAGE = 1 AND T1.TBSP_TYPE = 0
Database:
caused by
Exception CX_SQL_EXCEPTION in class CL_SQL_RESULT_SET
...



Read more...

Environment

SAP on IBM DB2 for Linux, UNIX, and Windows
DB2 version is 10.1 or 10.5

Keywords

SQL0420N, Invalid character, DECFLOAT, dbacockpit, 10.1, 10.5 , KBA , BC-DB-DB6-CCM , CCMS/Database Monitors for DB2 Universal Database , BC-DB-DB6 , DB2 Universal Database for Unix / NT , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.