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 , 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.