Symptom
Symptom 1
In the solution manager system, you notice errors like the following in the SAP developer trace files.
This happens when it is connecting to the managed systems.
C *** ERROR in ExecuteDirect[/bas/745_REL/src/dbs/db6/dbdb6.c, 6935] CON = 2 (BEGIN)
C &+*** DbSlConnectDB6( SQLExecDirect ): [IBM][CLI Driver][DB2/LINUXX8664] SQL0713N The replacement value for "CURRENT DECFLOAT ROUNDING MODE" is invalid.
C &+*** SET CURRENT DECFLOAT ROUNDING MODE ROUND_HALF_UP -- LOCATION( CL_SQL_CONNECTION=============CP , 321 ) -- HASH_VALUE(1713009988)
C &+*** ABAP location info 'CL_SQL_CONNECTION=============CP',
C *** ERROR in ExecuteDirect[/bas/745_REL/src/dbs/db6/dbdb6.c, 6935] (END)
C Change your database configuration parameter DECFLT_ROUNDING to ROUND_HALF_UP .
C Connected to 'ABC' as 'DB2ABC' schema 'DB2ABC' o.k.
Symptom 2
SOLMAN_SETUP for the managed system with Db2 V9.1 fails with the following error:
C *** ERROR in ExecuteDirect[/bas/749_REL/src/dbs/db6/dbdb6.c, 6969] CON = 2 (BEGIN)
C &+*** DbSlConnectDB6( SQLExecDirect ): [IBM][CLI Driver][DB2/HPUX-IA64] SQL0104N An unexpected token "DECFLOAT ROUNDING
C &+*** MODE ROUND_HALF_UP" was found following "SET CURRENT ". Expected tokens may include: "<space>". SQLSTATE=42601
C &+*** SET CURRENT DECFLOAT ROUNDING MODE ROUND_HALF_UP LOCATION( CL_SQL_CONNECTION=============CP , 321 ) HASH_VAL
C &+*** UE( 1713009988 )
C &+***
C &+*** ABAP location info 'CL_SQL_CONNECTION=============CP',
C &+***
C *** ERROR in ExecuteDirect[/bas/749_REL/src/dbs/db6/dbdb6.c, 6969] (END)
C Connect to 'ABC' as 'DB2ABC' schema 'DB2ABC' failed
Note
This KBA only applies if the ABAP location is "CL_SQL_CONNECTION=============CP".
Read more...
Environment
SAP on IBM Db2 for Linux, UNIX, and Windows
Keywords
SQL0713N, SQL0104N, DECFLOAT ROUNDING, ROUND_HALF_UP, secondary connection, CL_SQL_CONNECTION=============CP,
, KBA , sql0713n , cl_sql_connection=============cp , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , BC-DB-DB6-CCM , CCMS/Database Monitors , 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.
SAP Knowledge Base Article - Preview