DSXchange

Hello Experts, We are on DataStage 11.5.0.1 on AIX 7.1 platform. I am looking for the way integrating remote Cognos database environment from DataStage. I have not done this integration before. I am looking for guidance on what steps to perform integrating Cognos environment via Datastage. Though Da...

Hello, I have created simple test job (DB2 ---> xfm ---> ISD Output) as a service on our DataStage 9.1 FP1 environment to design proof of concept for ISD usage for service. I am passing three fields to ISD output and only selecting one row for test. On ISD environment, I have used Soap over HTTP bi...

Hello, I have created simple test job (DB2 ---> xfm ---> ISD Output) as a service on our DataStage 9.1 FP1 environment to design proof of concept for ISD usage for service. I am passing three fields to ISD output and only selecting one row for test. On ISD environment, I have used Soap over HTTP bin...

Hello, Is there any way we can get list of DataStage jobs name by db2 table of our interest? We have list of jobs in different folder in our project, and I was trying to get list of jobs which used particular db2 table. I dont want to go by opening and checking each job and looking that table name i...

Hello, Suddenly, we are getting following message while try to login to DataStage director or designer GUI with our LDAP id. They were working fine since long. Now its not allowing us to log in. Can anyone guide me what could be cause of this error message?..We are using DataStage 8.1 on AIX platfor...

Thanks Ray..

It was got resolved by changing RTLogging=1
ORLogging=0.

Its mystery that how it was switched values in DSParams file. I need to investigate with my Admin team.

Regards,
Gaurav

Thanks Ray..

Hunm..strange

Its

RTLogging=0
ORLogging=1

While for other projects we do have reverse. I have not changed it..looks like this should be reverse.

Which id generally used to connect to XMETA database?...Is it IISadmin id?

Hello, We are came across one situation. Here is some background information. We are having DataStage 8.1 on AIX 6x box. We have parallel jobs and they are running fine since beginning of last year. Yesterday, Our production DataStage jobs were running slowly while updating our target tables. We dec...

Thanks Ray...

Its strange though..Let me look on the permission side and let u all guys know if I get any success.

Thanks again

Hello, We have DataStage 8.1 on the AIX platform. I am trying to generate report of the DataStage jobs, but keep geting error message like "Failed to Import Report". (I tried clicking File > Generate Report with default style option). I tried for both parallel and server style jobs but not...

Thank you for your response. Yeah...I was looking for something else other than creating table to view Data Set stage data. In Data Set stage data viewer, its allowing us to see only few thousands records... Hi, Other than the file viewer there is not much you can use. Still, if you want to see the ...

Hi, We are using DataStage 8.1 on AIX platform. In our Parallel job design we are using Data Set stage to store intermediate data. It has about 100000 rows o entries. Wondering, is there any simple way to view data which r stored inside Data Set for debuging?...DataSet stage data viewer is not that ...

No need, really.... just use the timeout capability. The job will terminate nicely when there are no messages if you set a really short timeout period. Ernie Thanks Ernie, Thanks for your reply on IBM techlist too... Yes, if we supply timeout period as "0" then job terminate. But what I a...

Hi We are using DataStage 7.5 on AIX 5.1 In our job we are pulling data from MQ stage. We are expecting about 100K messages by year end.... We r working on loop approach to read 5000 messages at a time, perform xml parsing and load to target and after that running 2nd job to perform destructive read...

Hello, Our Ascential development servers are in USA. We have GR who are woking from China. When they try to access our Ascential development server GUI client, they are facing some peformance problem. Client GUI opens after very long time even they are facing problem in compiling jobs...its take too...