Do we need a separate database for each ETL server?

bharathappriyan · Post by **bharathappriyan** » Wed Sep 24, 2014 7:47 am

Hi,

Do we need a separate database for each ETL server?. In my project, two schemas are created instead of two ETL servers. Why do we need to have two schemas or databases for two etl server?

Thanks,
Bharathappriyan

kduke · Post by **kduke** » Wed Sep 24, 2014 8:01 am

They name the schema XMETA. Not sure you can rename it. So it requires different databases. That is the only reason I can think of to force different databases.

bharathappriyan · Post by **bharathappriyan** » Wed Sep 24, 2014 8:14 am

Hi kduke,

Thanks a lot for your reply.

We are using DataStage 7.5 version as well. Does't it have XMETA? My understaning is that from 8x onwards we have that XMETA schema if i am not wrong.

Thanks,
Bharathappriyan.

chulett · Post by **chulett** » Wed Sep 24, 2014 8:20 am

Anything less than 8.x does not have an XMETA repository.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 24, 2014 4:16 pm

Best practice is to have one WAS instance and one XMETA database to control as many engines as you have. Or, perhaps, one for production and one for all non-production environments.