This is a long shot but hoping someone can help. Not sure if this is the right place.
We are in the process of upgrading DataStage (was Mercator) to version 8.4.0.1. but have a strange problem.
We use datastage to transmit and receive data between the iSeries and Sybase. Nearly all files are sent to an off-line library during overnight batch processing where the data is picked up later by our iSeries application batch process. This works seamlessly.
The exception is we have one real time file that sits in the main database library which is updated during the day. This file receives live transaction data into our application database. It's this process we are having problems with.
During testing, everything worked as expected and there was no reason to believe there would be any problems going live. The project was subsequently signed off and we upgraded a few weeks ago. However, that evening, we couldn't get any data to the online file without an error occurring in DS. As a result the implementation was aborted. We have since tried to find the cause of the error:
Interestingly, using the same map but pointing to our test iSeries LPAR, everything works as expected.
I've attached two DataStage race files.. Live (with the error) and test (without).
As far as we can see DS is logging on the the iSeries but failing when compiling the native SQL complaining that it cannot find the column definitions.
Connection is via ODBC
Things we have tried.
1. Created a duplicate files on the iSeries in the same library from the offending object, changed the DS map to point to that file and re-tested.
2. as above but created the file from DDS re-compile.
We are pretty sure it's an ODBC driver problem.. but to add a spanner in the works.. we have another file in the same library using the same ODBC connection that get's updated around 4pm daily. This works fine.
iSeries version 5.4
Any help would be greatly appreciated.
We are in the process of upgrading DataStage (was Mercator) to version 8.4.0.1. but have a strange problem.
We use datastage to transmit and receive data between the iSeries and Sybase. Nearly all files are sent to an off-line library during overnight batch processing where the data is picked up later by our iSeries application batch process. This works seamlessly.
The exception is we have one real time file that sits in the main database library which is updated during the day. This file receives live transaction data into our application database. It's this process we are having problems with.
During testing, everything worked as expected and there was no reason to believe there would be any problems going live. The project was subsequently signed off and we upgraded a few weeks ago. However, that evening, we couldn't get any data to the online file without an error occurring in DS. As a result the implementation was aborted. We have since tried to find the cause of the error:
SQLError: SQLPrepare: No extended error information found
<4472-1176-07/26/13 15:18:08>: No columns found for table BLBDAYLIB/STT02P: table name is likely to be invalid.
<4472-1176-07/26/13 15:18:08>: No columns found for table BLBDAYLIB/STT02P: table name is likely to be invalid.
I've attached two DataStage race files.. Live (with the error) and test (without).
As far as we can see DS is logging on the the iSeries but failing when compiling the native SQL complaining that it cannot find the column definitions.
Connection is via ODBC
Things we have tried.
1. Created a duplicate files on the iSeries in the same library from the offending object, changed the DS map to point to that file and re-tested.
2. as above but created the file from DDS re-compile.
We are pretty sure it's an ODBC driver problem.. but to add a spanner in the works.. we have another file in the same library using the same ODBC connection that get's updated around 4pm daily. This works fine.
iSeries version 5.4
Any help would be greatly appreciated.
Comment