Cognos Data Manager Calls DataStage

This forum is the beginning of our inclusion of Cognos users to have their own place to go within our community. It is said the ETL and BI don't intersect, but as IBM integrates their platforms, there are less lines of demarcation between the two.

Moderators: chulett, rschirm

Post Reply
aspiresam
Premium Member
Premium Member
Posts: 7
Joined: Mon May 12, 2014 5:04 am

Cognos Data Manager Calls DataStage

Post by aspiresam »

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. :oops:
(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.
Image

Should you have any clue, please let me know.

Thanks in advance.

Regards,
Sam
Learning is a daily assignment.
kfrans
Participant
Posts: 3
Joined: Thu Feb 18, 2016 3:19 pm

Re: Cognos Data Manager Calls DataStage

Post by kfrans »

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
Karen
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply