Symptom
After setup of secondary connection "multiconnect" to DB2 z/OS database from SAP system using Oracle as primary database, the following error is reported when "ADBC_TEST_CONNECTION" connection test is performed using tcode SE38:
DB2 library has been loaded.
Info: successfully loaded DB2 library '/db2/client/lib/libdb2.so'
Running with UTF-8 Unicode
DB2 client driver version '11.01.0202'
Running with CLI driver.
CLI cfg for con_hdl=1:
UID=SLTDB2T;DATABASE=MVSDB201;PROTOCOL=TCPIP;HOSTNAME=DKMVS00;SERVICENAME=21446;
Connected to DB server type 'DB2'
Connected to DB server version '11.01.0005'
*** ERROR in prepareStatement[/bas/745_REL/src/dbs/db6/dbdb6.c, 14324] CON = 1 (BEGIN)
&+ DbSlConnectDB6( SQLExtendedPrepare ): [IBM][CLI Driver] CLI0150E Driver not capable. SQLSTATE=HYC00
&+
&+ VALUES( CASE CURRENT DEGREE WHEN 'ANY' THEN -1 ELSE CAST( CURRENT DEGREE AS INTEGER ) END )
&+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=32, read_only=0
&+
&+ ABAP location info 'CL_SQL_CONNECTION=============CP', 321
&+ SAP user 'BOYDBO', transaction code 'SA38'
&+
*** ERROR in prepareStatement[/bas/745_REL/src/dbs/db6/dbdb6.c, 14324] (END)
***LOG BYI=> connect failed for connection DB2_TEST2 [dbds 981]
***LOG BZY=> unexpected return code 8192 calling DBDS [dbacds 2029]
*** ERROR => Unexpected RC when calling dsql_connect
Read more...
Environment
- SAP Netweaver 7.5
- SAP_BASIS 750 0008
- DB2 client driver version 11.01.0202
- DB2 z/OS 11.01.0005
- Linux GNU SLES-11 x86_64 cc4.3.4 use-pr17111
Product
Keywords
CLI0150E DB2Connect CLI multiconnect ADBC_TEST_CONNECTION DB2 iSeries Informix , KBA , BC-DB-DB2-SYS , DB2 for z/OS - Database interface , BC-DB-DB4 , DB2 for AS/400 , BC-DB-DB6-SYS , Database Interface/DBMS , BC-DB-INF-SYS , Informix Database Interface/DBMS , Problem
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