IBM Support

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

Question & Answer


Question

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

Answer

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.

[{"Product":{"code":"SSUC3U","label":"IBM Engineering Workflow Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Reports","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"3.0.1.3;3.0.1.2;3.0.1.1;3.0.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Product Synonym

Rational Team Concert

Document Information

Modified date:
16 June 2018

UID

swg21580159

Page Feedback