News
Abstract
IBM DOORS Next 7.x changed the underlying data store from Jena to a relational database.
As a result, underlying queries might run differently in 7.x.
Some customers encountered issues that impact application performance.
While performance can depend on specific customer data characteristics and use cases, the information in the table provides insight into some of those types of queries.
Content
Customers that use DOORS Next 7.x can encounter performance issues with the use cases listed in the table.
The use cases in the table have one of two main categories:
1) The underlying database chooses suboptimal execution plans upon running these use cases.
The issues are observed with Oracle or Db2 and impact the database server by causing excessive database calls, which consume significantly more CPU on the database server. When multiple users are running on the server, these slow queries can queue up and result in sudden increases in CPU (sometimes up to 100% of available CPU).
The issues are observed with Oracle or Db2 and impact the database server by causing excessive database calls, which consume significantly more CPU on the database server. When multiple users are running on the server, these slow queries can queue up and result in sudden increases in CPU (sometimes up to 100% of available CPU).
If you colocate your Engineering Lifecycle Management (ELM) applications on one database server, then these issues impact all applications' performance.
IMPORTANT NOTE: While IBM Engineering Requirements Management DOORS Next 7.0.x can scale to higher levels of data and concurrent users than 6.0.x, the techniques that improve query performance with Db2, and Oracle are not sufficient with Microsoft SQL Server. Our analysis of this issue is on-going.
We recommend that clients who are using IBM DOORS Next Generation 6.0.x with Microsoft SQL Server do not upgrade to ELM 7.0.x currently.
Microsoft SQL Server issues are not listed in this technote. For more information, see Performance considerations: Microsoft® SQL Server® and IBM® DOORS® Next 7.0.x (Engineering Lifecycle Management)
2) The IBM DOORS Next application (the underlying Java virtual machine) exhausts the allocated maximum heap space.
The use cases listed in the table contain two issues that can cause heap exhaustion from single-user actions (Audit History and Link by attribute).
It is also possible that when the database queries start to overload the database server, the DOORS Next server slows down or becomes unresponsive, eventually requiring a restart.
The use cases listed in the table contain two issues that can cause heap exhaustion from single-user actions (Audit History and Link by attribute).
It is also possible that when the database queries start to overload the database server, the DOORS Next server slows down or becomes unresponsive, eventually requiring a restart.
As always, with any performance issue, run update statistics regularly, as out-of-date statistics can be the cause of reported performance issues. Db2 users can run "reorgchk" weekly as we advise against using AUTO_STMT_STATS.
|
|
|
|
interim fix
|
interim fix
|
interim fix
|
| Rich hover from other ELM applications | User does not see impact. Heavy DB server CPU | iFix009 | iFix007 | iFix002 | |
| Long loading times for filtered views (traceability) | Filtered views take a long time to load or never load. | iFix009 | iFix007 | iFix002 | |
| DN Baseline views fail to open |
Loading views with many traceability link columns encounters timeout before loading is complete.
Long running queries on db server.
|
Defect 139809 (Db2) | Upgrade to 7.0.2 | iFix008 | iFix004 |
|
Change set delivery
|
Change set delivery does not complete
Heavy CPU on Db server (Oracle)
|
Defect 525879 (Oracle | iFix009 | iFix007 | iFix002 |
| Opening modules from a baseline | Opening modules from a baseline is slow | Defect 143072 (Db2) | n/a | n/a | TBC |
| Compare Baseline |
Compare a stream to another stream or baseline is slow. Deliver a stream to another stream is slow, or times out. |
Defect 526065 (All) | TBA | TBA | iFix008 |
| Create, delete, or update links in an opt-out project area with several users simultaneously |
Standard operations become slower to the user when Links Explorer is open
Long running queries on db server.
|
Defect 529639(Db2) | TBA | TBA | iFix008 |
| Open Audit History |
Audit history fails to load.
Application JVM runs out of heap space
|
iFix009 | iFix007 | iFix002 | |
| Link by attribute |
Operation times out for the user
Application JVM runs out of heap space
|
iFix008 | iFix007 | iFix002 |
All fixes in the table with a designated interim fix are also available in the most recently released interim fix for that stream.
You can keep track of defects and interim fixes by referencing the ELM Maintenance Schedule on jazz.net, and subscribing to individual defects.
The list in the table is not exhaustive. We have created a section within the Performance report for DOORS Next 7.0.2 iFix008 of additional, less severe, defects that relate to performance.
IBM recommends that you apply the most recently released interim fix before you upgrade and continue to apply the most recently released interim fixes to ensure that you do not encounter known, fixed issues. The list in the table contains issues that are not yet in an interim fix for awareness and to allow planning for production upgrades.
If you feel you are running into any of these issues, or any additional use cases not listed, open a case with IBM Customer Support.
The use cases in the table might not be encountered in all clients' systems.
DOORS Next performance for common use cases can vary greatly depending on the data's characteristics. These key characteristics include the number, size, and type of artifacts in the system and the relationships between them.
For guidance on testing your data before upgrade, read Recommendations when you are planning and implementing your ELM DOORS Next 7.0.x upgrade project.
Related Information
[{"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":"a8m50000000Cj1WAAS","label":"DOORS Next Generation->Performance"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0.0;7.0.1;7.0.2"}]
Was this topic helpful?
Document Information
Modified date:
13 January 2022
UID
ibm16391660