DSXchange

Go into the DataStage Administrator, and increase the inactivity timeout, so you wait longer. You can also set it to not to timeout.

For the changes to go into effect, you will need to restart the DataStage engine

There should be a file in your project directory the name of the file is "DSParams", this contains all the environment variables which you define using Administrator. The format of each variable defined is given below, in this format 6th item is <SetAction>, please see following different ...

Hi all, i've a problem. I launch a DS parallel job. This job return an error code -"14 DSJE_TIMEOUT" Can i set an option for increment the job timeout???? Help me pls!! Massimiliano There is a parameter in the server for Inactivity timeout, check that and increase it to higher number. Hop...

It's a PX stage provided by default. I'm still waiting word from management for installing this. -T.J. I couldn't find anywhere this stage in the PX version 7, I even have asked Ascential Support and here is the reply from them "There is a key generator routine available on the server but I am...

Hi,

I would like to know some thought on following

1. What are the advantages using DataStage Job Sequence? Rather using 3rd party scheduling tool like ControlM.

2. How to get the restart ability in the Job Sequence if any job fails in the flow?

Thanks,

Sohail.

Using the KISS principle, do the 100 jobs. Since you're using 7.x, create a shell in a template job, then load the individual table definitions from the text files and from the Oracle tables into separate jobs created from that template. Which, of course, you've previously imported into your reposi...

I have question about loading more than 100 pipe delimited text files with different record formats into our Data Warehouse Landing area, each file will be loaded to a single oracle table. So, my question is what is the best way to load these files. I know one way 1 job per file which will have the ...

We also faced the same issue when we try to generate surrogate keys using the Oracle Sequences. We did it two different ways, in the Server job we use OracleSeq.NextVal to get the next key, which works fine as Server execute each SQL in the database whereas the PX doesn't, it brings the same value e...

Thanks Ray, I wanted to have second thought before making any decision to use Basic transformer in PX, initially it seems very attractive to use this as it has many built-in transformation routines which are not available in PX transformer yet. But now if there is some overhead involve with it then ...

Hi, I'm new to this forum, I found this forum very beneficial and have got some good ideas from posted questions and answers. I would like to know if anyone knows that is there any disadvantage to use Basic Transformer in Parallel job :?: which is available in the version 7 along with Parallel trans...