Metadata repository for IS v8 (mandatory or non-mandatory??)

ds_is_fun · Post by **ds_is_fun** » Sun Aug 05, 2007 9:40 am

Is it mandatory to have a database for metadata repository for Information Server? Can we choose not to have a database metadata repository.

ray.wurlod · Post by **ray.wurlod** » Sun Aug 05, 2007 2:36 pm

It is mandatory.

If you don't have one of your own, a copy of DB2 version 9 ships with IIS and you can use that.

vmcburney · Post by **vmcburney** » Sun Aug 05, 2007 7:19 pm

I've been able to run the Metadata Server on the bundled DB2 database and on the free SQL Server Express. It also runs on Oracle. The database server does not need to be on the same machine as the metadata server though you want fast connectivity between the two. You could put the DataStage Server, the Metadata Server and the repository on different machines.

ray.wurlod · Post by **ray.wurlod** » Mon Aug 06, 2007 1:49 am

But... it must be DB2 version 9, or Oracle version 10g. Any earlier release will not work.

ds_is_fun · Post by **ds_is_fun** » Mon Aug 06, 2007 7:59 am

To use the bundled DB2 which installs with IS, do we have to buy a separate license to maintain it. OR is it considered to bundled with the IS license?

ray.wurlod · Post by **ray.wurlod** » Mon Aug 06, 2007 2:33 pm

Bundled, but licensed only to be used as IIS Repository.