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.
Log InLog in to view more of this document
Was this topic helpful?
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