Error Message - "DSP.Open GCI $DSP.Open error -100"

[pg_smh]

I am getting the following error message - "DSP.Open GCI $DSP.Open error -100" while running a server job. Data is being pulled from DB2 datasource.

[kumar_s]

Hi and Welcome to Dsxchange :D !!!

There should be other valid error code along with this error message.
Just with this message, we can guess various reasons like, Wrong SQL query, incompatable datatype, wrong column name specification.
You need to give more details about the job as well as the error message and as well as the query.
Try to execute the same query from command prompt and ensure the correctness.

[pg_smh]

1. Warning - Error occurred during link open processing. (while sending data to the Lookup transformer)
2. warning - DSP.Open GCI $DSP.Open error -100.
3. Fatal - DSP.Open GCI $DSP.Open error -100 (while sending data to the error transformer)

If the SQL query for pulling data from the source is run at the backend database, then rows are returned, but when this data goes to the transformer for lookups, then the following messages are encountered.

[ray.wurlod]

$DSP.Open is the function used to connect to DB2.

Verify that all the connection information goven in the stage is correct and that, if needed, the DB2 client software is correctly installed and configured.