In Control center Queued Process view should be cleared automatically
In the Control Center, for a process or session to be moved from the “Queued Process” view to the “Completed Processes” view, there should be an end event for the process/session. In certain situations, the process may stay in the “Queued Processe...
Adding new indexes to database for enhancing performance.
The current DB settings seems to be insufficient for production environment. The performance dramatically enhanced after adding them during DB analysis made by our DBA team. I have raised TS001613070, and IBM Support agreed to add these indexes bu...
Under ICC database tuning, there is a comment that indicates that records need to be manually pruned from a number of tables:
The CC_PROCESS, CC_PROCESS_DVG, CC_FILE_TRANSFER, and CC_FILE_TRANSFER_DVG tables contain the summarized information for...
Web Console must filter prior to displaying the stats
Every time I select statistics usinig Web Console, ICC does an initial search with no criteria and it takes more than minutes. After this initial search I can include criteria and make a new search. This approach makes a simple selection of statis...
ICC Database tables which hold summarized data can be partitioned
Encountering performance issues with control center due to having a requirement for a large amount summary data to be available. Given that some of the performance issue are due to long running queries, if the tables holding this data were partiti...
There are instances where the queued process monitor shows processes that are sometimes days old. There should be a way to ensure that processes in the Queued Processes are actually running.
Exclude status option to monitor Sterling integrator business process
If we provide option to monitor specific status like success/failure, it is good for ICC DB incase of success status can be avoided so that it will not load lot of events,