DB2 Configuration - Multiple Servers

[laknar]

Consider you are writing datasets called A(Config File1) and B(Config File2)

First Config File.

DataSet Data files are created on both dsserver1 and dbserver1

Second COnfig File.

First Config File.

DataSet Data files are created on both dsserver2 and dbserver2

When reading the Dataset files you should use the corresponding configuration files.

A(Config File1)
B(Config File2)

[senthil_tcs]

Hi,

Thanks, Is it possible to pass more than one more config for each job? Currently we are defining a parameter set with different set of config files and pass the appropriate value through sequencer activity. In the same transform job I need to use both the dataset created using config file 1 and also the config file 2. I am wondering why the dataset is getting created in DBSERVERS? Due to this I am unable to use the datasets created from 2 extract jobs.

Consider you are writing data sets called A(Config File1) and B(Config File2)

First Config File.

DataSet Data files are created on both dsserver1 and dbserver1

Second COnfig File.

First Config File.

DataSet Data files are created on both dsserver2 and dbserver2

When reading the Dataset files you should use the corresponding configuration files.

A(Config File1)
B(Config File2)

[laknar]

Design seperate jobs for each dataset and write into file.
i wonder how the datasets are created in one project but by using different config files.

Is the datasets created on same project?

we can do by passing $APT_CONFIG_FILE as parameter and read the datasets into sequential file and combine both the sequential files.
but i believe we have to do it in seperate jobs.

This is one way to combine the two datasets.