DSXchange

Few were towards some setting in database end, and few were towards network traffic. They would have probably tried those option discussed here. As mentioned, if the stored procedure is called via shell, it can running for a long hrs, and not via ODBC stage.
Kinda weired.

Not really a mandate option. If you are opting for that, make sure the schema name should be parameterized.

Hi Rai,

Could you make you question clear.

B, F, J and O) only start when the first jobs (A, E, I, N) has all finished.

Is this not expected? If so, do you expect B, F, J and O to run parallel to A, E, I, N)?

To be more simple, Datastage is in its best on RealTime via SOA rather than in Batch mode. Even the one line application are clensed using Quality Stage and stored in ERP using Datastage. And its all triggered by a web service. After seeing all these, it often prompts in my mind that, pace of evolut...

Hi Himadri, Welcome to Dsxchange :D !!! OSH engine is what used for Datastage PX. For each stage there is one or more Orchestrate operators operates in orchestrate engine. For example, Sort stage will have tsort operator to sort the data in Orchestrate. There is another operator called psort for sim...

What is the timer value set in dsdlockd config file?

If you are talking about Preserver Partition, there are three options. Default is Propagate. This will try to use the same option what its previous stage is used. If the previous stage Preserver Partition has 'Set' this stage will also try to have 'Set' in it. If Preserver Partition is set to hold t...

May be the processed rows where huge in number that the process has consumed the full paging space and couldn't even log the error.

Vivek, I dont find a real need to clear the partition before sending it to Sort stage. If the Sort stage has partition in it, the existing partition will obviouly be re partitioned. The partition prior to that will not take effect.

If I understand properly, you are writing the row num using @INROWNUM in addition to the exisiting columns, rigth? If there is no much transformation included in that, that particular macro shouldn't cause the slog. As I said, you nail down the culprit, you can remove link and find the statistics to...

You got to be kidding.

Even in one of the other project in my site reporting the same issue. Need to check out the reason.

You are right, CRC32 will give you unique single field value for combination of several fields. So you can reduce the over head of doing the lookup for all the fields. But you need to make sure, while preparing the CRC field, the datatype and length should be same, else you will end up in getting di...

Not necessarily. If its a shell script which is ready to call the jobs, why it should be again called from Job Sequence. You can directly call it from Command prompt, or schedule it.

So it should be issue with the compiler configuration. What is the error that you get?