Hi,
We currently have an application that primarily sits on SQL server and needs to access some legacy data in a DB2 database. The solution we are using is to use a linked server between the two servers. The problem with this is that complex queries occasionally cause the driver to fetch a complete table and filter that table locally. I wondered whether service broker (which I have never used) could allow me to access the DB2 database using MQSeries and thus speed up the application as our ODBC calls have low priority on our mainframe.
Thanks and sorry if this sounds a stupid use of service broker.
Service Broker supports only its own protocol so it cannot communicate with DB2 or MQSeries. You must have Sql on both ends to use Service Broker.
Rick Negrin
Program Manager
Sql Server Service Brokersql
No comments:
Post a Comment