IBM Support

Thresholds for determining whether your DOORS Next instance has exceeded the capacity of Microsoft® SQL Server.

News


Abstract

IBM Engineering DOORS Next V7 using Microsoft® SQL Server does not scale to enterprise-sized data. Evaluate your data size by using the following information and consider alternative database and deployment options.

Content

We anticipate performance issues if your requirements data exceeds any of the following thresholds. If so, or if you anticipate these conditions will be the case in the future, we recommend migrating your database to Oracle® Enterprise Edition or IBM Db2® before performing the upgrade to V7.
You can use repodebug->repository->rawSql to issue these SQL queries. (Instructions on how to enable full repodebug functionality can be found here.)
  1. Number of project areas managed by the RM server that do not have configuration management enabled:
    • Number of opt-out projects.
    • Threshold:  10 or more
    • select count(*) from VVCMODEL.PLE_ENABLED_PROJECT_AREA_ID
  2. Number of RM components on server in one global configuration (for all project areas managed on the server):
    • Number of components
    • Threshold: 10 or more
    • select PART_OWNER_ITEM_ID, COUNT(PART_OWNER_ITEM_ID) FROM GC.DB_PART_BINDING group by PART_OWNER_ITEM_ID
      Note: this query is only valid when the Global Configuration Management application is installed. Otherwise, it returns an error.
  3. Number of artifact versions in all project areas managed by the RM server
    • Number artifact versions
    • Threshold:  > 1 million
    • select count(*) from VVCMODEL.VERSION
  4. Artifacts with many versions in all project areas managed by the RM server
    • Artifacts with the highest version count
    • Threshold:  counts > 100
    • select TOP 100 CONCEPT, count(CONCEPT) from VVCMODEL.VERSION WHERE CONCEPT like '%resource%' group by CONCEPT having count(CONCEPT) > 1 order by count(CONCEPT) DESC
  5. Number of change sets per stream
    • Check the number of change sets per stream
    • Threshold:  > 1000
    • select TOP 100 PARENT_STREAM_ITEM_ID, count(PARENT_STREAM_ITEM_ID) from VVCMODEL.CHANGE_SET group by PARENT_STREAM_ITEM_ID order by count(PARENT_STREAM_ITEM_ID) DESC
This document refers to DOORS Next (the RM application). Note that some customers with large Engineering Workflow Management (also known as Rational Team Concert) deployments have decided to migrate from Microsoft® SQL Server to Oracle® or Db2® for better performance.
Alternatives
As part of your ELM licenses IBM makes available Db2® Standard Edition licenses (no extra license cost). Alternatively, you could use Oracle® Enterprise Edition.
 
If your organization cannot provide effective database administration for Oracle® or Db2®, then we suggest you consider moving to a managed service offered by IBM or a business partner. IBM offers monthly rental (SaaS) offerings as well as bring-your-own-licenses managed services, where you can make use of existing licenses, including tokens. As part of moving to IBM offerings, IBM can take on the burden of migrating your databases and moving your data.
 
We recently developed a faster database migration feature, which we are introducing as new repotools commands. For more information, see https://jazz.net/wiki/bin/view/Deployment/OptimizedConcurrentDatabaseMigration. Contact IBM Support for the latest status in delivering these new commands in an interim fix.

[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSUVLZ","label":"IBM Engineering Requirements Management DOORS Next"},"ARM Category":[{"code":"a8m50000000Cj1gAAC","label":"DOORS Next->Administration"},{"code":"a8m0z000000Gn1nAAC","label":"ELM->System Requirements"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0.0;7.0.1;7.0.2"}]

Document Information

Modified date:
18 February 2022

UID

ibm16491169

Page Feedback