Can you please look at this error message? What does this mean, and where do I begin? I am a SQL DBA and know little about the iSeries 400. The library set up in the ODBC client is CLOCFILE00, but the error string references CLOCFILE0 - not the library.
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147217865 (80040E37) Error string: [IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL7973 - SQL create package for DTSRUNFBA in CLOCFILE0 has failed. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147217865 (80040E37); Provider Error: 204 (CC) Error string: [IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL7973 - SQL create package for DTSRUNFBA in CLOCFILE0 has failed. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete.
The ODBC driver is trying to create a SQL package. SQL package is an object in the system that keeps the access plan of the statement (so when you run it again the database will have an execution pan ready).
The SQL package is not created, probably because of commitment mode issue. The package creation phase is a step that must run under commitment control. Therefore, if the very first connection to a remote system is with COMMIT NONE, then the packages will not create properly.
In order to check it please remove the package creation from the data source (in the performance tab disable package creation). If you use connection string you should set off dynamic. a good link for working with iSeries from ms env. written for "non-iSeries" can be found here.
MORE INFORMATION ON THIS TOPIC
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
The Best Web Links: tips, tutorials and more.