DSXchange

hi chulett,

Sorry for using unofficial words (eg: rite).

So based on your reply, i assume that my conclusion is correct.
am i right now?

thanks,
Bhasan.

hi, thanks for your replies. based on my observation of Statistics, when i am significantly increasing the nodes the time is decreasing. but when i run the same job in single node it is taking very less time. May i know the reason behind this? I think since i am hash partitioning in the source stage...

The stages used inthe job are

MQRead ---> Transformer --> column import ---> Oracle Stage

Hash partitioning is done in the MQRead stage

Hi, When i ran the job in single node it is taking 10 mins around. If i run it using the 4 nodes then it is taking 30 mins around to process all the records. I am hash partiitoning the incoming records based on key fields. Please throw some light on this. I would like to know why the performance is ...

Hi,

what are the points to be considered to make a job run in multiple nodes. Other than configuration file changes what are the changes to be done at stage level.
Please provide me the useful links if any.

Thanks,
Bhasan.

you can do that using after job subroutine calling unix commands.

sorry guys, posted question wrongly. the corrected question is as follows. what are the points to be considered in making a job which is running in a single node to run in multiple nodes. I mean what are the properties in the stages that needs to be done and required changes from configuration file ...

hi,

what are the points to be considered to make a job run in multiple instances.

Thanks,
bhasan.

hi chulett,

Thanks for your patience in replying to all my questions.

Thanks,
Bhasan.

Thanks again. How can we access that XMETA database repository? is it not in Universe database? I am interested to know the details. Please provide me the related links, where can i find those info.

Thanks,
Bhasan.

Thanks for your prompt reply chulett. May i know those two places where the details of the objects are stored?

Adding to the previous post.
-- I cannot rename and move the jobs using Universe SQL commands in 8.1 version.

hi Chulett,

May i know the reason. one more doubt am able to rename the jobs, move the jobs from one folder to another in Datastage 7.5. but am unable to do the same in Datastage 8.1. Are there any changes in the properties in the table DS_JOBS in 8.1 version.

Thanks,
bhasan.

Hi all,

Is it possible to create a copy of an existing job using Universe commands. I mean by using Universe SQL Commands. (Using insert sql statement).

Thanks,
bhasan.

Hi, Thanks for your reply. Actually the job is designed to implement SCD type2 (using flag y/n), in that i had used the Oracle stage where i was allowed to upsert(insert as well as update). In that i used the same id for refering the rows. I guess i got that error in that place. Can you please help ...