DSXchange

I purchased premium membership on Oct 31, but my status is still participant. Sent email to membership director yesterday, no reply. Is anybody taking care of this? How long do I have to wait?

That's exactly what I'm suggesting. Whether you double the number of scratch disk spaces or double the number of process nodes, ultimately you need to be able to provision sufficient scratchdisk spac ... Thanks Ray. When I get enough disk space, I will run the job in one shot to see if any performa...

You can have multiple scratch disks per node specified in the configuration file. It only makes sense to do that if they're on different file systems. ... Thanks Ray. Yes, even if I use disks supposed to be used for dataset for scratch disk, there is still not enough space to handle all the sorting...

Thanks Paul. The sort source is from the result of join stage. I have to resort the the data because the requirement is dfiierent.
Anyway, because the scratch disk space limitation, I have to split the data volume.

I have a job with 900 millions of records needed to be sorted before the aggregator stage. It almost fills up 50G of scratch disks (4 nodes, 200G in total). I am wondering if there is any guidance regarding the sort disk size. Should I spilt the data into small volume for processing? Thank you in ad...

Try using TO_CHAR(Create_DT, 'YYYY-MM-DD HH24:MI:SS')

Thanks prakashdasika for your answer. That is exactly what I was curious about.

How do we know if the data are "previously grouped"? "Previously Sorted" is easy to understand. I have a job contains JOIN stage followed by Sort stage. Data are sorted using link sort before the JOIN stage. Can I use "Previously Goruped" option? Why cannot use "Pr...

ray.wurlod wrote:Pass JobActivityName.$UserStatus as the value of the command's parameter. ...

Thanks for the answer. It works.

I need to run a shell script with Execute Command Activity. I would like to pass in the value of other job's UserStatus as the parameter of the shell script. I am not sure how to do it? I would like to avoid wrapping the Execute Command Activity in a seperate sequence job and taking the parameter fr...

write a simple server job that uses DSUtilityRunJob (see the sdk routines) in a transformer. to kick off the Sequence Job....and publish that simple job as a service. Thanks Ernie for your advice. Can you point me to the direction or documnets on how to publish datastage job as a service? Is it a s...

I need to execute job sequence on demand from a JSP page. I think the best way would be to expose the job sequence as a web service and JSP page will call the web service to execute the data stage job. Please advise the way of doing that. Thanks in advance.

Stop wanting to have your cake and eat it too. This is not a DataStage thing. If you want all rows to be in one transaction, then that's that - if you can't feed the rows swiftly, then the transactio ... I am going to use 0 for the inserting stage and 1 for the deleting stage to make sure that dele...

crouse wrote:Just for grins...

In Director, go to Tools -> Options -> Limits and be 100% sure it is set to "No limit"

-Craig

100% sure it is no limit

chulett wrote:

jiegao wrote:My question is if link1 and link2 are within the same transaction.

That depends. Two OCI stages? Two transactions. One OCI stage? One transaction. ...

Thanks