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

Modified date:
16 June 2018

UID

swg21684241