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.