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.
- 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
- 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_IDNote: this query is only valid when the Global Configuration Management application is installed. Otherwise, it returns an error.
- Number of artifact versions in all project areas managed by the RM server
- Number artifact versions
- Threshold: > 1 million
select count(*) from VVCMODEL.VERSION
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
- 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
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.
22 October 2021