The error in Director:
Code: Select all
DsStag3TransactionHistoryImage05..db2_service_action: Error occurred during link open processing.
DsStag3TransactionHistoryImage05..db2_service_action.DSLink1: DSP.Open GCI $DSP.Open error -100.
Strangely, other jobs which read other tables from that same database in that environment don't have the same problem, they work fine. We've tried dropping and recreating the problem table but this doesn't effect the error.
Also we've tried logging into Toad and performing the same database operation on the table with the same credentials that Datastage uses. There is no problem when doing this.
Appreciate any thoughts.