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

Shared Mailbox Functionality - Excessive SQL Activity to Confirm UserRights

Sterling B2B Integrator - Mailboxes - Shared Mailbox Functionality

When users attempt to access Mailboxes via SFTP/FTP, attempts to download files stored in Shared Mailboxes can generate excessive SQL activity while Sterling B2Bi attempts to verify users' permissions, scaling in direct proportion to the number of users with access to the shared resources.

Under periods of high load, this results in extreme performance degradation as the number of queries increases by a factor of the simultaneous attempts to request files, with failed or delayed queries causing transfer failures or greatly reduced file transfer speeds.

While increases to the UserRightsCache value have generally improved performance, the preferred resolution would be revision of the Shared Mailbox system to be less reliant on these numerous and inefficient queries.
  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Dec 19 2017
How will this idea be used?
What is your industry?
What is the idea priority? High
DeveloperWorks ID DW_ID92804
RTC ID RTC_ID510438
Link to original RFE http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=92804
  • Attach files