Editing artifact/view does not get saved immediately and performance of system is very bad
Hi All,
We are running with IBM Jazz 6.0.5 and the performance of the system has been progressively slow.
During so the following types of errors occur which is disrupting business impact.
- Server processing error - When editing any artifact attribute in bulk, the error pops out. The artifact is also not saved and need to wait a period of time (1-2hours but right now either a few minutes or unknown amount of time) and refreshed before it is shown or sometimes completely deleted. The same issue with views
- Performance testing error - When running the performance test project to load artifacts, it takes a very long time before any artifacts are displayed.
- Network connection error - in one of our user cases, it also shown a network connection error.
In any case, these errors seemed to be related to the performance of the system. What else can we do to resolve these errors or improve the system performance?
Thank you.
2 answers
Hi Alan,
You can add performance health check widget to monitor the network and round trip latency.
But, 6.0.5 is very old. If possible please consider upgrading it to latest version
We had a similar issue. On the database server, we had to run:
db2 connect to rm
db2 REORGCHK UPDATE STATISTICS ON TABLE ALL
Then wait overnight as the database maintenance kicked in.
It's as though DB2 checks for race conditions on the entire changes up until you REORG the data, which means over time it gets slower and slower until you run that command.
Comments
Alan Chong
Dec 09 '23, 10:10 p.m.The network connection error has been verified that nothing from our internal infrastructure has caused the connection issue. Connection between application and database was not showing errors as well but the error still popped out for one of our users.