Watson Supply Chain Ideas

Use this form to submit an idea for a new product feature. The product team will review your input and provide status updates as decisions are made regarding the request.

Before you submit a new idea, please view requests that have already been submitted. If your idea has already been submitted, you can add comments or vote on the existing idea, thereby indicating your agreement with the idea. We may use this information to help prioritize development of new features.

 

Submit ideas for Watson Marketing and Watson Commerce products

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 but mentioning, that they may disappear after any software update, so the complete solution should consider adding the creation of these indexes during the software/update deployment as the information to the software package.

Our proposal reflects our naming conventions, but GBMS string can be included as a deployment parameter.

create index CC_CLUSTER_EVENT_GBTS on CC_CLUSTER_EVENT(CLUSTER_ID,CLUSTER_EVENT_ID,SOURCE_ID);

create index CC_PROCESS_GBTS on CC_PROCESS(PROC_STATUS,STARTED_DAY,NODE_TYPE_ID);

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Nov 28 2018
How will this idea be used?

ICC gathers all Connect Direct nodes setups in Citi and it is a middleware for automated configuration requests made by all Connect:Direct users. Enhancing ICC DB performance will stabilise and improve this automated service.

What is your industry? Financial Markets
What is the idea priority? Medium
DeveloperWorks ID
RTC ID
Link to original RFE
  • Attach files