SAP Knowledge Base Article - Preview

2486190 - DB6: SQL0713N or SQL0104N during secondary connection

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)
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 , cl_sql_connection=============cp , sql0713n , 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.