Troubleshooting
Problem
Receiving warning SQL3050W during LOAD operation.
Symptom
LOAD completes, but the data is mixed with other characters.
Cause
Code page is different from source and target.
Environment
All
Diagnosing The Problem
On Source:
db2 get db cfg | grep code
Database code page = 819
On Target:
db2 get db cfg | grep code
Database code page = 1208
Resolving The Problem
Check at OS level if the language (LANG) is the same on both servers. If not, correct them to the same language or set the codepage on source session temporarily:
export DB2CODEPAGE=1208
db2 "export to table1.ixf of ixf modified by codepage=1208 select * from db2inst1.table1"
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Routines (SP & UDF) - SQL","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.8;9.7;9.5;9.1;8.2;10.1;10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21650478