Note the Chinese garbled characters in the load command for DB2 data import solution: when you use the load command on windows to import tables to the database today, the Chinese characters in the data are garbled. Command: The Chinese characters in the table www.2cto.com db2 load from d: \ user.txt of del insert into useruser are garbled. Www.2cto.com solution: add the codepage option when using the load command. Command: db2 load from d: \ user.txt of del modified by codepage = 1386 insert into usercodepage = 1386 for GBK, 1208 for UTF-8. NOTE: If db2 is installed on a linux server, using the load command to import data is faster, but it is possible
As a result, the backup of the db2 database on linux is suspended and data cannot be written to the database.
Backup. Therefore, use this command with caution and try to use other methods instead.