DSXchange

Friends, All these days we were using DataStage only to extract data into Staging tables. From now on we want to use it to process the staging data and populate dim/fact tables in Star schema Can someone please answer the following questions 1) Can DataStage be used effectively to populate tables co...

Hello friends, Is there a way of exporting/importing DataStage jobs automatically? I mean, is it possilbe to write a script which can export/import specified DataStage jobs and compile them at the end? We are in the process of integrating DataStage jobs with other Production builds. In order for us ...

Thanks Craig

Hello friends, I got the following error after the completion of the job. The job has 3 ODBC stages and a Transformer stage ODBC-1====>ODBC-2====>Transformer====>ODBC-3 ODBC-1 deletes the records from a table ODBC-2 selects data from a db and populates a table mentioned in ODBC-3 Error: DSD.StageSta...

Freinds,

I am having some issues with DataStage after installation. The problem is I am not able to find the DataStage 'Daemon' (dsrpcd) on the server. I tried to restart the engine but couldn't fix the issue

Any ideas would be highly appreciated
Yamini

We had the exact same issue. We resolved the issue by executing a small command (like 'ls-l /home/dstage') as part of after job sub-routine

Try that and hopefully that will resolve your issue

Yamini

Hello freinds, We have DataStage 7.5.x installed on a Linux server and were able to connect to different databases for almost a year All of a sudden our jobs failed with the following error SQLSTATE=S1000, DBMS.CODE=1509 [DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle driver]File not found 'IV...

Thanks Craig
I was able to connect to the server after the network team opened the port and firewall

Hello friends, Recently our team built a new Linux server with DataStage 7.5.x on it. We are planning to use clients installed on Windows servers to connect to the new server. The problem is we don't know the port to be opened on the Linux server so as to initiate a client connection. The connection...

The problem, in my case, was the physical dirve was used 100 percent. The jobs went through fine after I freed some space by deleting some archive files

Yamini

Hello friends, We have some jobs which are triggered by respective job sequence. In the sense each job has its own sequence which is triggered on the execution of a shellscript These jobs ran without any errors for months but lately most of the sequence jobs are failing with the same error Controlle...

Thanks Ray

I dont think that the parameter can be set in Administrator. If I remember correctly, the parameter can be set in a file on the Linux server where the software is installed

Yamini

Ray,

Thanks a lot for your response.
One more follow-up question. How can I check that'deadlock daemon' is running?

Thanks
Yamini

Hello friends, I have a shellscript which triggers DataStage job multiple times in a loop. In short, at the beginning the shellscript executes a PL/SQL procedure which generates some files. Then it triggers the DataStage sequence which in turn triggers the job to process the files. This process cont...