IBM Support

Deadlocks in Initiate Master Data Service for SQLServer

Question & Answer


Question

We set up our IBM Initiate Master Data Service environment with SQL Server and are seeing deadlocks on the mpi_memhead table during heavy load. Why are we getting them and how can we prevent them? OR We set up our IBM Initiate Master Data Service environment with SQL Server and are seeing slow memput performance with occasional deadlocks being reported in the engine logs while the memgets are running fast. Why are we getting them and how can we prevent them?

[{"Product":{"code":"SSLVY3","label":"Initiate Master Data Service"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"Edition Independent","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Product Synonym

MDS
Master Data Service
MDM
MDM SE
MDMSE
Master Data Management
IBM Infosphere Master Data Service
MDM Standard Edition
MDM Hybrid Edition
Initiate
Hybrid
Physical MDM
Virtual MDM
Hybrid MDM

Document Information

More support for:
Initiate Master Data Service

Software version:
Version Independent

Document number:
250557

Modified date:
16 June 2018

UID

swg21684241

Manage My Notification Subscriptions