July 23, 2012 at 7:30 am
I am trying to create linked server from SQL Server (SQL2012 on Windows 2012 x64) to DB2 (V10.1 Red Hat Linux x64). The connection test works fine, but I wan't able to run "Package" nor "Sample Query" from Data Access Tool.
Data Access Tool:
- output for connect
Successfully connected to data source 'New Data Source'.
Server class: DB2/LINUX
Server version: 10.01.0000
- output for package
Connected to data source 'New Data Source'.
The package creation process has failed on resource 'New Data Source':
Error in BIND or PRECOMPILE option "KEEPDYN?0xF1" with value "". SQLSTATE: 56095, SQLCODE: -30104
- output for sample query
Could not connect to data source 'New Data Source':
One or more errors occurred during processing of command.
Error in BIND or PRECOMPILE option "KEEPDYN?0xF1" with value "". SQLSTATE: 56095, SQLCODE: -30104
- Connection String
Provider=DB2OLEDB;User ID=db2inst1;Password=XXX;Initial Catalog=mydb1;Network Transport Library=TCPIP;Host CCSID=37;PC Code Page=1252;Network Address=10.200.47.178;Network Port=50000;Package Collection=db2inst1;Process Binary as Character=False;Units of Work=RUW;DBMS Platform=DB2/6000;Use Early Metadata=False;Defer Prepare=False;DateTime As Char=False;Rowset Cache Size=0;Datetime As Date=False;AutoCommit=True;Authentication=Server;Decimal As Numeric=False;Derive Parameters=True;LoadBalancing=False;Persist Security Info=True;Cache Authentication=False;Connection Pooling=False;
Also verified same error when creating linked server (linked server alias name: db2pojen)
select * from db2pojen.mydb1.db2inst1.demo_sqlserver
OLE DB provider "DB2OLEDB" for linked server "db2pojen" returned message "One or more errors occurred during processing of command.".
OLE DB provider "DB2OLEDB" for linked server "db2pojen" returned message "Error in BIND or PRECOMPILE option "KEEPDYN?0xF1" with value "". SQLSTATE: 56095, SQLCODE: -30104".
Msg 7330, Level 16, State 2, Line 2
Cannot fetch a row from OLE DB provider "DB2OLEDB" for linked server "db2pojen".
Any advice/input are appreciated.
Thanks!
November 17, 2016 at 9:24 am
I realize this is an old post, but was wondering if you ever found a solution? I have a similar issue with an app that works fine when SQL Server accesses DB2 10.5 Fixpack 4, but get's this issue when accessing a "clone" of the db2 database that is running under DB2 10.5 fixpack 7. We are pretty confident that no customizations were done to the 10.5 fixpack 4 database such as to the dbm cfg or db2cli.ini to provide any special handling of alternate package collections for non-default BIND parms such as KEEPDYN. Given the connection string/datasource definitions for the connection the app uses are pretty much the same for both versions of the database aside from the host/port, we can't understand where or why KEEPDYN would even be implied for the dynamic bind related to the query being called. I have a PMR opened with IBM on it, but so far they are still researching. BTW - we are using the Microsoft DB2 OLEDB Provider not the IBM DB2 OLEDB Provider in both cases.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply