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 , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.