DSXchange

Can you paste exact error message ??

There may be possibility of getting into deadlock even while inserting concurrently . This may be true even if its a row level lock .In those cases , check INITRANS parameter in database and increase the value to number of nodes .Let us know if it helps .

Restart the server . Please let us know what exactly your problem is ? Even after restarting the server , your dsrpcd is not running ?

After job completes automatically the intermediate files will be deleted .

Still if there are some files which are old then use find command with option mtime .

It depends on type of req you are having .But decide whether its a keyed partitioning or non-key then as mentioned by craig experiment and decide .

Job got aborted due to lack of space . Please note that after the job aborted or completed all the scratch space related to that job will be cleaned up .

In a parallel job , sequential file automatically rejects . Put a reject link and collect records which are having bad data .

disabling operator combination wont eliminate error .It will tell what exactly the operator causing the problem

you mean to say that there will be only one record from reference link ?
what is the through put in primary link ?

CFF are best bet for multi record format . or you can use sequential file stage as varchar and after that filter or transformer to split into different files ( all records of same format into one file )

I believe you have given the password in the parameterset ( value file ) through datastage .If that value is not changed at unix level then you should be able to pass the value file at runtime through command line and execute the job successfully .

Whenever there is a change in number of parameters in parameter set , compile the jobs that are using the paramter set .

Are you talking about value file related to paramter set ?

dsjob -run -param parametersetname=valuefilename ......

It will work with varchar fields only