DSXchange

Dear all,

Actually, we are migrating from IBM Cognos Data Manager. There is a need for interim solution for Cognos Data Manager calling DataStage stages.

DataStage 9.1 FP2 on AIX 7.1
Cognos Data Manager 10.2.1 FP4 on Winodws 7 SP1
DataStage Client 9.1 FP2 on Windows 7 SP1 (same machine as Data Manager)

However, I have configured the dm.ini with
DataStage Development Kit=C:\IBM\InformationServer\Client\Classic\vmdsapi.dll

It is able to see the DataStage projects and jobs.

I have tried 2 different types of jobs with errors.
(a) DataStage Job with No parameter
(b) DataStage Job with Parameters (flat parameter / parameter sets)

UPDATE: 2 MAR 2015 - version 2

- Both (a) & (b) are finished successfully.
- However, DataStage job is being called but returns an error message iwth unknown reason.


Should you have any clue, please let me know.

Thanks in advance.

Regards,
Sam

Hi,

We are also migrating from IBM Cognos Data Manager to DataStage and would like to use the DataStage node in Data Manager as an interim solution.

I'm experiencing the same problem whereby the datastage job successfully runs but then an unknown error occurs and data manager stops working.

Did you find a solution to this problem?

Thanks,
Karen

It could be that the exit status of the call is set to that of the DataStage job, where 0 is "running", 1 is "finished", 2 is "finished with warning", etc. Your caller may be interpreting the non-zero code as an error.