Using the operational server utilities
There are a number of command-line utilities that are used with the operational server. These utilities are primarily used by the implementation and IBM® Software Support teams. Some of these utilities are also available as jobs in InfoSphere® MDM Workbench.
Before you begin
To run a utility from the command line, you must have the
MAD_ROOTDIR, MAD_DBTYPE, MAD_CONNSTR, and MAD_CTXLIB variables set
in your environment. If you are using a Linux or UNIX operating system, the appropriate
library path variables must contain MDM_INSTALL_HOME/lib:
- Linux or Solaris: LD_LIBRARY_PATH
- IBM AIX®: LIBPATH
Procedure
- On the command line, go to the InfoSphere MDM installation directory (MDM_INSTALL_HOME). Then go to the bin directory.
- To view command-line usage for any utility, run the command
applicable for your operating system. Where utility is
the utility name.
- Microsoft Windows: utility.exe (for example, mpxdata.exe
- Linux or UNIX: utility (for example, mpxdata)
- Run the utility according to the usage output or the information provided in the utility topics. While the information in the topics covers greater detail than the usage output, it is a good idea to supplement the topic information with the usage output.
- Operational server environment variables
A set of environment variables must be set to fully enable the virtual MDM command-line utilities. - madcode utility
The madcode utility displays strings in Soundex, METAPHONE, and IDENTAPHONE form. - madconfig utility usage for virtual MDM implementations
The madconfig utility is internally used by IBM InfoSphere Master Data Management components and is used externally to configure various components. - maddbx utility
The maddbx utility allows for database operations to retrieve information about a database, create, or delete tables and indexes, along with several other database-related operations. - madentcreate utility
The madentcreate utility creates database tables and indexes to support a new entity type (enttype). - madentdrop utility
The madentdrop utility drops database tables and indexes of an entity type (enttype). - madentload utility
The madentload utility loads the entity tables from .unl files. - madentreset utility
The madentreset utility truncates an entity. - madentunload utility
The madentunload utility unloads one or more entity tables into .unl files. - madhubcreate utility
The madhubcreate utility creates database tables and indexes, and initializes base tables to support a new MDM software installation. - madhubdrop utility
The madhubdrop utility drops the database tables and indexes of an MDM installation. - madhubload utility
The madhubload utility loads one or more virtual MDM tables from .unl files. - madhubreset utility
The madhubreset utility truncates an operational server instance. - madhubunload utility
The madhubunload utility unloads one or more core (non-entity) tables into .unl files. - madload utility
The madload utility loads a database table from a .unl file. - madpass utility
The madpass utility generates the encrypted form of a plain text password. - madpwd2 utility
The madpwd2 utility takes a plain text password and encrypts it, enabling administrators to type encrypted text in configuration and profile files. - madpwd3 utility
The madpwd3 utility takes a plain text password and encrypts it by using the Advanced Encryption Standard (AES) 128, 192, or 256-bit encryption method. - madsql utility
The madsql utility runs an SQL statement or file of SQL statements through the operational server interface. - madunload utility
The madunload utility unloads database tables into .unl files. - mpidelete utility
The mpidelete utility enables command-line access to the MEMDELETE (member delete) interaction. - mpidrop utility
The mpidrop utility enables command-line access to the MEMDROP (member drop) interaction. - mpiengget utility
The mpiengget utility outputs the logging levels that you have set in real time. - mpimcomp utility
The mpimcomp utility enables command-line access to the MEMCOMPARE (member compare) interaction. - mpimerge utility
The mpimerge utility enables command-line access to the MEMMERGE (member merge) interaction. - mpimshow utility
The mpimshow utility is a diagnostic utility used to dump the in-memory contents of a member identified by a memRecno. The entire contents of the member are dumped to stdout, including associated derived data. - mpinetget utility
The mpinetget utility captures operational server performance statistics without needing to shut down the operational server. - mpitxm utility
The mpitxm utility can be used to update members without having to shut down the operational server. - mpiunmrg utility
The mpiunmrg utility enables command-line access to the MEMUNMERGE (member unmerge) interaction. - mpxbchk utility
The mpxbchk utility is an optional diagnostic utility used to check bucket sizes during bulk cross match operations. - mpxcomp utility
The mpxcomp utility enables the comparison of records and is one of the processes used during bulk (BXM) and incremental cross matches (IXM). - mpxconv utility
The mpxconv utility is a weight generation program to check for weight table convergence. - mpxdata utility
The mpxdata utility uses raw data to build member unload files (.unl), generate comparison strings, assign bucket hashes, and create binary files. - mpxdedup utility
The mpxdedup utility is used in hierarchy bulk cross match operations to remove duplicate values. - mpxdist utility
The mpxdist utility is a weight generation program used to compute weight distributions, and clerical review and auto-link scores. - mpxdump utility
The mpxdump utility dumps binary files to text format. - mpxfreq utility
The mpxfreq utility creates frequency files to support weight generation. - mpxfsdvd utility
The mpxfsdvd utility enables the creation of bulk cross match (BXM) files from .unl files. - mpxfstree utility
The mpxfstree utility is used in hierarchy implementation to create a binary representation of an externally defined hierarchy for use in the hierarchy linking utility (mpxtrex). - mpxglink utility
The mpxglink utility creates group entity linkages. - mpxitob utility
The mpxitob utility is a weight generation program to generate bucket records from item records. - mpxlink utility
The mpxlink utility is a cross match program that enables entity linkage. - mpxpair utility
The mpxpair utility is a cross match program used to generate random pairs for weight generation. - mpxprep utility
The mpxprep utility is a cross match program used to generate bulk cross match (BXM) data. - mpxfprof utility
The mpxfprof utility produces diagnostic information about the size and the number of fields and records in a data file. - mpxrebkt utility
The mpxrebkt utility regenerates bucket data into the database, or .unl files, or bulk cross match (BXM) files. - mpxredvd utility
The mpxredvd utility regenerates derived data into the database, or .unl files, or bulk cross match (BXM) files. - mpxrule utility
The mpxrule utility is a cross match program that generates bulk cross match (BXM) data. - mpxsmooth utility
The mpxsmooth utility is used during the weight generation process. - mpxsort utility
The mpxsort utility is used to reorder a binary file generated from the bulk cross match (BXM) and incremental cross match (IXM) utilities. - mpxstd utility
The mpxstd utility is a diagnostic utility that displays the standardized output from various standardization routines. - mpxwgts utility
The mpxwgts utility generates weight tables. - mpxxeia utility
The mpxxeia utility is a cross match program used to unload existing entity linkage data from the database. - mpxxtsk utility
The mpxxtsk utility is a cross match program that unloads existing task data.
Last updated: 2 Nov 2018