March 29, 2012 at 1:00 pm
Hi,
I have few SSIS packages that retrieve data from remote iSeries DB2 machine.
Originally they were using ODBC connection and DataReader components. Unfortunately when executed the pre-execution phase on data flows with iSeries queries hanged and after 24+ hours were canceled.
I partially fixed it by running the iSeries queries in stored procedure through ODBC and retriving data from them by OLE DB. Still though the validation phase of iSeries lasts sometimes for 40-50 minutes and sometimes for just few seconds. Amount of data is not more than 300 rows.
Did anybody have problems like this?
It begin to happen just recently so it might be a problem with DB2 but I need strong evidence.
Thanks in advance.
March 30, 2012 at 1:46 am
Can't you just use the Microsoft OLE DB provider for DB2 and get rid of the ODBC entirely?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply