IBM Support

About one Oracle database instance hosting multiple Data Warehouse databases in Jazz

Technote (FAQ)


Can one Oracle database instance host multiple Data Warehouse (DW) databases in IBM Rational Jazz?


Not in IBM Rational Team Concert (RTC) 3.x, due the following reasons:

  • Oracle does not have the concept of a schema. It has the concept of users owning tables.
  • One single DW database requires a DW user schema, as well as a set of users schema with hard coded names such as Config, RIASSET, RIBA, RICALM, RIDW, RIODS, RISCHK. These users schema can not be renamed, and for that reason, only one DW db can be hosted in one oracle DB instance.

However, DW supports schema prefix in RTC 4.0 and will allow you to host multiple DW databases in one single Oracle DB instance.

Multiple RTC instances sharing the same JTS can use the same data warehouse. There should be one data warehouse per JTS.

Leverage the Jazz Community

Jazz and Rational Team Concert have an active community that can provide you with additional resources. Browse and contribute to the User forums, contribute to the Team Blog and review the Team wiki.
Refer to technote 1319600 for details and links.

Document information

More support for: Rational Team Concert

Software version: 3.0.1,,,

Operating system(s): AIX, IBM i, Linux, Solaris, Windows, z/OS

Reference #: 1580159

Modified date: 06 December 2014