SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Linked Server to DB2 V10.1 (LUW)


Linked Server to DB2 V10.1 (LUW)

Author
Message
phuang5168
phuang5168
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 26
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!
abelmj
abelmj
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 0
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search