mpxredvd utility

The mpxredvd utility regenerates derived data into the database, or .unl files, or bulk cross match (BXM) files.

This utility can be run from the command line or InfoSphere® MDM WorkbenchVirtual MDM > New Job Set. S

All options and flags are case independent, option values are not.

-dbupdate and, or -unlOutdir -unlOutSegs and, or-bxmOutDir must be specified.

-memType and -entType cannot be specified at the same time.

Before you run a utility, make sure that you have set the necessary operational server environment variables. For information about the variables, see the operational server environment variables topic.

Table 1. mpxredvd utility options
Option Type Description Default
-unlOutDir dirName .unl file output directory. The output of the mpxredvd utility is the derived data segments (comparison, bucket and, optionally, query data), which have their own .unl files (mpi_memcmpd, mpi_membktd, and mpi_memqryd) written to the directory specified here. This directory is relative to the project work directory on the hub:

WAS_PROFILE_HOME\installedApps\YOUR_CELL_NAME\MDM-native-IDENTIFIER.ear\native.war\work\project_name\work\unl_output_dir

Use -unlOutDir with-unlOutSegs to indicate whether the mpxredvd utility should generate .unl files during processing. Also with -unlOutSegs, create .unl files that contain bucketing data or comparison data, or instruct mpxredvd to generate query .unl files during processing (the files are used by the relationship linker).

NONE
-unlOutSegs segList List of segments to include in the output. Use with -unlOutDir to indicate whether mpxredvd should generate .unl files during processing. Also with -unlOutDir, creates .unl files that contain bucketing data or comparison data, or instructs mpxredvd to generate query .unl files during processing (the files are used by the relationship linker). NONE
-encoding encoding Encoding of .unl files; options are LATIN1, UTF8, or UTF16 LATIN1
-bxmOutDir dirName .bin output directory. Indicates where you want the BXM output files to be located. This directory is relative to the project work directory on the hub:

WAS_PROFILE_HOME\installedApps\YOUR_CELL_NAME\MDM-native-IDENTIFIER.ear\native.war\work\project_name\work\bxm_output_dir

NONE
-{no}bxmBktd   Generate MEMBKTD output. In combination with -{no}bcmCmpd, instructs the mpxredvd utility to generate output files for bulk cross matching. -bxmBktd
-{no}bxmCmpd   Generate MEMCMPD output. In combination with -{no}bxmBktd, instructs mpxredvd to generate output files for bulk cross matching. -bxmCmpd
-{no}bxmQryd   Generate MEMQRYD output. Indicates whether mpxfsdvd should generate query BXM files during processing. These files are used by the relationship linker. -bxmQryd
-nMemParts N Number of member partitions. Setting this partition depends on the size of your data set, your algorithms, and how much memory you have access to on the hub. The utility that uses the mpxredvd output (such as the mpxfreq utility) must use a matching MemPart value. Use the default unless you need the memory. The higher the member partitions the slower your mpxcomp process, as the hub must do more duplicate comparisons. 1
-nBktParts N Number of bucket partitions. Setting this partition depends on the size of your data set, your algorithms, and how much memory you have access to on the hub. Use the default unless you need the memory. 1
-minBktTag N Minimum bucket tag (0=any). The lowest bucketing role designation used in the algorithm to include in the process. 0
-maxBktTag N Maximum bucket tag (0=any). The highest bucketing role designation used in the algorithm to include in the process. 0
-nQryParts N Number of query partitions. Setting this partition depends on the size of your data set, your algorithms, and how much memory you have access to on the hub. Use the default unless you need the memory. This option is enabled only when the option to Generate query BXM is also enabled. 1
-minQryRole N Minimum query role to use (0=all). The lowest query role designation used in the algorithm to include in the process. This option is enabled only when the option to Generate query BXM is also enabled. 0
-minMemRecno N Minimum memrecno at which to start the rederivation 0
-maxMemRecno N Maximum memrecno at which to end the rederivation 0
-blkSize N Number of members in a block 1000
-buffSize N Size for each input and output (I/O) buffer 65536
-{no}dbUpdate   Database update -nodbUpdate
-memType memName Member type name. If you have multiple member types in the hub database and need to derive data for only one of those member types, select the member type here; otherwise, select ALL. NONE
-entType entName Entity type name NONE


Last updated: 2 Nov 2018