DSXchange

Oh! Then we have an issue here. I have to contact Unix admin. He is in the US and myself in India. then ask him, but DataStage has another limitation with Hash file that is not in the s.o. for hash files greater than 2 GB the performance is not good. If you want to work with it you must RESIZE the ...

abhilashnair wrote:I logged in with my own id and executed this command. I am not aware what exactly do you mean by root user?

root is the user administrator of your unix machine.

The ulimit -a for you user is not relevant because DataStage don't use it.

have you done these command as root user? time(seconds) unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes) unlimited memory(kbytes) unlimited coredump(blocks) unlimited nofiles(descriptors) unlimited The above is the output of ulimit -a in the directory where my hash file is prese...

No, you must change all jobs, In Parallel you can run your server (DS 7) jobs without change it, but you would not have the funcionality of Parallel. If you want to have this funcionality you must change the jobs. Cristina. Hi, we are planning to upgrade to version 8, we had also aquired the Paralle...

You must do ulimit -a for the user root to see the kernells parameters. You can put it to ulimited, then your os will have not this limitation. Also,You can resize your file hash to increase it up to 2GB using the command RESIZE. but a Hash file more than 2GB is not trateable in goog performance.You...

Hello,

Is it possible to connect with pluguin Load to a BD DB2 for iSeries in a AS/400?

I have problems because DB2Connect can't make Load into a DB2 for iSeries. Is it true?

regards,
Cristina

Clear status file don't stop the job.
You have initialize the estatus of the job but it is already running, so you can't start it.
if you don't have permissions to kill the job, call to someone that can do it to stop the job.

regards,
Cristina

Hello Brad, DataStage use several resources to run a job, it seems like the internal files of DSEngine could be great o corrupted. try with this. -Clear Status File of the job you are running -Clear Log of the job you are running -Clear &PH& file if with this you dont see better performance ...

Note that in unix the trailing spaces are losted, i think for better performance.
if you don't want to loose these trailing spaces you must insert another caractere (example_ tab) at the end the record.

regards,
Cristina

Thanks a lot

Hello, I have a parallel job with one agregator that agregates 5000000 reg. it fails with the error: Aggregator_30,0: Failure during execution of operator logic. Aggregator_30,0: Fatal Error: Throwing exception: APT_BadAlloc: Heap allocation failed. before there is a warning log: Aggregator_30,0: Th...

File-----> Transformer1-----> Transformer2------> File |-----> Agregator transformer1 has two output links: one to transformer2 and another to agregator. Hi, a possible solution could be : File-----> Transformer-----> Transformer------> File write an intermediate file has no sense in paralell regard...

then it could be something like: File-----> Transformer-----> Transformer------> File |-----> Agregator Hi, a possible solution could be : File-----> Transformer-----> Transformer------> File write an intermediate file has no sense in paralell regards, Cristina The intermediate file is our output fo...

Hi,
a possible solution could be :
File-----> Transformer-----> Transformer------> File

write an intermediate file has no sense in paralell

regards,
Cristina

please Ray, i can't see your entire message. could you please tell me another time. Regards, Cristina A "processing node" is a logical concept - a subset of your available processing power and resources such as memory and disk. The degree of parallelism is determined by the number of nodes...