2486190 - DB6: SQL0713N or SQL0104N during secondary connection | SAP Knowledge Base Article

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 , sql0713n , cl_sql_connection=============cp , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration with DB2 Universal Database , BC-DB-DB6-CCM , CCMS/Database Monitors for DB2 Universal Database , 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.