DB2 data export Import del vs. ixf format differences

Before doing data migration encountered garbled some of the pits, summed up. General Import and Export:

 to /Home/Select*from/home /  of Insert  into TableName

 to /Home/Select*from/home / Insert  into TableName

Solve garbled problem export

 DB2 export to  / home/ xxxx.del of  del modified by  codepage=  1208  select  *   From   TABLENAMEDB2 export  to  / home/ xxxx.ixf of  IXF modified by  codepage=  1208  select  *  Span style= "COLOR: #0000ff" >from  tablename (recommended) 

Del and IXF differences

The DEL format is a text file, the file is stored by line, and the text content containing the carriage return in the Del file will be another row, the Del file is visible. The IXF format holds the structure and data, is a binary file, and the Ixf file is not considered.

DB2 data export Import del vs. ixf format differences