Technical Blog Post
Abstract
db2 command receives error SQL10007N Message "-1390" could not be retrieved. Reason code: "6"
Body
db2 command receives following error regardless of what is the parameter used with db2 command:
SQL10007N Message "-1390" could not be retrieved. Reason code: "6".
To diagnose the problem, take a db2 trace on client side:
db2trc on -f db2trc.dmp
db2
db2trc off
db2trc flw db2trc.dmp db2trc.clw
db2trc fmt db2trc.dmp db2trc.fmt
The following are found in db2trc :
65405 | | | | | | sqlnlscmsg entry
65406 | | | | | | sqlnlscmsg data [probe 10]
65407 | | | | | | sqlnlscmsg data [probe 20]
65408 | | | | | | sqlnlscmsg data [probe 60]
65409 | | | | | | sqlnlscmsg data [probe 70]
65410 | | | | | | sqlnlscmsg data [probe 377]
65411 | | | | | | sqlnlscmsg data [probe 100]
65412 | | | | | | sqlnlscmsg exit [rc = 0x870F00CD = -2029059891 = SQLO_UNEXPECTED_SYSERR]
65413 | | | | | sqlnlsMessage data [probe 30]
65414 | | | | | sqlnlsMessage data [probe 170]
65415 | | | | | sqlnlsMessage exit [rc = 0xFFFFFFFD = -3]
65412 exit DB2 UDB National Language Support sqlnlscmsg cei (2.3.56.34.2)
pid 7360 tid 6112 cpid -1 node -1
rc = 0x870F00CD = -2029059891 = SQLO_UNEXPECTED_SYSERR
65414 data DB2 UDB National Language Support sqlnlsMessage cei (3.3.56.65.2.170)
pid 7360 tid 6112 cpid -1 node -1 probe 170
bytes 78
Data1 (PD_TYPE_DEFAULT,70) Hexdump:
5351 4C31 3030 3037 4E20 4D65 7373 6167 SQL10007N Messag
6520 222D 3133 3930 2220 636F 756C 6420 e "-1390" could
6E6F 7420 6265 2072 6574 7269 6576 6564 not be retrieved
2E20 2052 6561 736F 6E20 636F 6465 3A20 . Reason code:
2236 222E 0A00 "6"...
The above indicate db2 can't access message file db2sql.mo under <Db2_home_dir>/SQLLIB/msg/en_US/db2sql.mo
The following is an example of the file location on Windows:
C:\IBM\SQLLIB\msg\en_US\db2sql.mo
To resolve this problem, verify the access of this file including file location, size, and permissions.
UID
ibm13286023