March 28, 2012 at 9:35 am
The following Statement returns the error listed below:
select * from openquery(lsctlr40dat,'select count(*) from RECACT where D2AACD||D2ABCD||D2POLSYM||D2POLNO<=''0081FYN8040410''');
OLE DB provider "MSDASQL" for linked server "lsctlr40dat" returned message "[IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0666 - SQL query exceeds specified time limit or storage limit.".
If you run it against an open source tool called SQuirrel it completes.
I searched Goggle but I have not found a solution?
Could there be a timeout issue, memory, etc?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 28, 2012 at 9:47 am
I changed the query timeout property on the Linked Server and the query completed.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply