IBM Support

When using the madhubload command to load unl data to the database, the data is truncated

Troubleshooting


Problem

When using the madhubload command to load unl data to the database, the data is truncated. This appears to occur whether or not we use Internal Loader.

 

Symptom

The below example demonstrations the issue by comparing the contents of mpi_memcmp from the DB to the data in the unl file.
The data is heavily redacted so please focus just on the length.

 

Stmt[1] = [select * from mpi_memcpcd]
MXMRXXXX|SRXRXXXX|XMPSXQXX|XMPVXX|
1|11|1|XXSX:XXSX::.^10101~10101~10137^X-100:S-S:S-WXXKXR:S-XR:X-701:.S|
1|11|1|11^1^1_X_SXXXX~100_S_WXXKXR_701~71_S_WXXKXR^XXSX:XXSX::.^XXSX|
1|11|1|XXRXXX:XXXX::.^10111^S-XXXXXXXXXXXXX:.S-XXXXXGX:S-XX:.X-10111:.|
3|11|1|RXXX:GXXRGX::.^^S-XXXXXX:.S-XXXXXGX:S-XX:..^M^^^11110115^13^^RX|
1|11|1|XXXGXXM:MXXXK::.~XXX:SXXVXX::.^10111^X-7111:S-XMXRXXX:S-1XX:S-X|
5|11|1|XXRXMXX:KXXXY::.^10131^X-3005:S-X:S-XXWXXXX:.S-XXXXXGX:S-XX:.X-|
1|11|1|XXVXS:KXVXX::.^^S-XX:.S-X:S-XX:..^M^^^11110111^50^^XXVXS:KXVXX:|
7|11|1|KXRYSXXK:JXYXX::.^10051^X-1301:S-X:S-XUXMXG:S-XX:.S-MXPRXSPXXX:|
1|11|1|XRXXXX:XPXXXGXX::.^10101^X-100:S-S:S-RXVXR:S-RX:S-XRX:.S-XXXXXG|
1|11|1|XXYXX:XXRX::.^10151^S-X:S-X:X-1133:S-S:S-XXXXRXX:.S-XURXXXK:S-X|

head mpi_memcmpd.unl
1|11|1|XXSX:XXSX::.^10101~10101~10137^X-100:S-S:S-WXXKXR:S-XR:X-701:.S-XXXXXGX:S-XX:.X-10101:.~X-1:S-X:S-SXXXX:S-SX:.S-XXXXXGX:S-XX:.X-10101:.~X-71:S-S:S-WXXKXR:S-XR:.S-XXXXXGX:S-XX:.X-10101:.~S-QPXX:S-XXXRXSS:.S-XXXXXGX:S-XX:.X-10137:.^M^5111115~5111300^^111101|
1|11|1|11^1^1_X_SXXXX~100_S_WXXKXR_701~71_S_WXXKXR^XXSX:XXSX::.^XXSX|
1|11|1|XXRXXX:XXXX::.^10111^S-XXXXXXXXXXXXX:.S-XXXXXGX:S-XX:.X-10111:.^X^^^11110101^10^^XXRXXX:XXXX::.^XXRXXX|
3|11|1|RXXX:GXXRGX::.^^S-XXXXXX:.S-XXXXXGX:S-XX:..^M^^^11110115^13^^RXXX:GXXRGX::.^RXXX|
1|11|1|XXXGXXM:MXXXK::.~XXX:SXXVXX::.^10111^X-7111:S-XMXRXXX:S-1XX:S-XXXXR:.S-XXXXXGX:S-XX:.X-10111:.^X^1171111^331113117^11110107^15^7111_1XX^XXXGXXM:MXXXK::.~XXX:SXXVXX::.^XXX|
5|11|1|XXRXMXX:KXXXY::.^10131^X-3005:S-X:S-XXWXXXX:.S-XXXXXGX:S-XX:.X-10131:.^X^7115110^^11100110^11^3005_X_XXWXXXX^XXRXMXX:KXXXY::.^XXRXMXX|
1|11|1|XXVXS:KXVXX::.^^S-XX:.S-X:S-XX:..^M^^^11110111^50^^XXVXS:KXVXX::.^XXVXS|
7|11|1|KXRYSXXK:JXYXX::.^10051^X-1301:S-X:S-XUXMXG:S-XX:.S-MXPRXSPXXX:S-XX:.X-10051:.^X^5105111^^11110511^71^1301_X^KXRYSXXK:JXYXX::.^KXRYSXXK|
1|11|1|XRXXXX:XPXXXGXX::.^10101^X-100:S-S:S-RXVXR:S-RX:S-XRX:.S-XXXXXGX:S-XX:.X-10101:.^M^1170117^331111111^11351011^101^100_S_RXVXR^XRXXXX:XPXXXGXX::.^XRXXXX|
1|11|1|XXYXX:XXRX::.^10151^S-X:S-X:X-1133:S-S:S-XXXXRXX:.S-XURXXXK:S-XXX:S-XX:.X-10151:.^X^1313517^317315755^11310111^111^1133_S_XXXXRXX^XXYXX:XXRX::.^XXYXX|
[MXMXMj@MXMXMj-X-mXX1 uXX]$ pXXkXX_wrXXX_wXXX: XXXXXXXXXX XX 111.

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSWSR9","label":"IBM InfoSphere Master Data Management"},"Component":"Engine, madhubload, madunlload","Platform":[{"code":"PF002","label":"AIX"}],"Version":"11.6","Edition":"","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.

Document Information

More support for:
IBM InfoSphere Master Data Management

Software version:
11.6

Operating system(s):
AIX

Document number:
732403

Modified date:
27 April 2022

UID

ibm10732403

Manage My Notification Subscriptions