IBM Infosphere Master Data Management Source system specific delete

This article describes on deleting source system specific data from IBM Infosphere master data management virtual style implementation.

The below code snippet assume that MDM server is installed on DB2 database , but similar steps can be excuted for other Database implementation as well.

Steps:

-> Connect to database.
-> extract all MEMID's for a specific source system.
-> For each MEMID trigger MPIDROP command to delete the MEMID.

db2 +O "connect to <MDMdatabase> user <userid> using <password>"

db2 +O "SET SCHEMA <DB SCHEMA NAME>"

db2 -x "select '<Source System Code>:'||MEMIDNUM from mpi_memhead where srcrecno = <Source id>" | xargs -r -n 1 $MAD_HOMEDIR/bin/mpidrop -conn 'http|<hostname>|<port>|en' -usrLogin <server user id> -usrPass <server password> -rec