Dataset Query

rumu · Post by **rumu** » Thu Feb 04, 2010 6:20 am

Hi All,

I have created a Dataset in a Firts job using 4 node configuration file and trying to read the same dataset in 2nd job while running the job in 2 node configuration file.
The second job is running fine.
Is this ok?since I heard that in such scenerio 2nd job shud abort but it is not happening ...
Could anyone suggest pls?

chulett · Post by **chulett** » Thu Feb 04, 2010 6:26 am

rumu wrote:I heard that in such scenerio 2nd job shud abort

You heard wrong.

abhijain · Post by **abhijain** » Thu Feb 04, 2010 8:06 am

There is no reason why the job should abort. You can create dataset by using any no. of nodes and can use in any other job, which uses different no. of nodes.

The job will work fine without any issues.

priyadarshikunal · Post by **priyadarshikunal** » Thu Feb 04, 2010 8:54 am

Hope this topic helps

viewtopic.php?p=332523&highlight=#332523

hamzaqk · Post by **hamzaqk** » Thu Feb 04, 2010 8:58 am

hmmm well i also had an impression that the DS is configuration file dependent.

chulett · Post by **chulett** » Thu Feb 04, 2010 9:43 am

Well... it is but if the only difference in the 'configuration' is the number of nodes, there wouldn't be any issues.

keshav0307 · Post by **keshav0307** » Thu Feb 04, 2010 11:32 pm

the second job should also have four node to read the dataset..
so if you want to process the data in 2 node in second job, then make the other two node in "read only" pool.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 04, 2010 11:39 pm

Actually (in version 8 and later) DataStage will do this automatically and invisibly.

rumu · Post by **rumu** » Fri Feb 05, 2010 12:33 am

Thanks to every body for your input.
Why I asked that,when I did an initial training on Datastage V8.0,the trainer from IBM itself told this information in the class.She was from IBM software Lab..But when I practically implement this I found job is running fine.hence I asked in this forum.

Thanks again for your valuable input.

Regards,

Rumu

zulfi123786 · Post by **zulfi123786** » Sun Feb 07, 2010 7:12 am

ray.wurlod wrote:Actually (in version 8 and later) DataStage will do this automatically and invisibly.

If the same situation arises in versions prior to 8 do we always need to make the other two node in "read only" pool ? and also can you help me with how to do this. I guess this shold me made in the dataset stage using the option "Node Pool and Resource Constraint", am i right?

ray.wurlod · Post by **ray.wurlod** » Sun Feb 07, 2010 12:27 pm

To be honest, I don't recall. I vaguely remember that the configuration file with which the Data Set had to be read had to be "compatible" with the configuration file used when the Data Set was written.

DSXchange

Dataset Query

Dataset Query

Re: Dataset Query