Db2 data migration del, ixf

Db2 data migration del, ixf is using db2 import from test. when del of del insert into table is used to import data, the following error occurs: the number of data entries exported and the number of imported data entries are equal to the number of data entries in the database, it was strange that the del file stored data by row, because a field in the database stores data by text domain, if the text content containing the carriage return is displayed in the del file with another line, the imported data is mistakenly regarded as a data item, but the structure is incorrect, so the data cannot be imported. Later, the data was exported in ixf format, and the import was normal. After turning back to the system, we have taken a look at the DB2 data migration knowledge, which is roughly as follows: export; import: import, load; data movement format: ASC \ DEL text file; WSF worksheet format, it is mainly used for LOTUS software; IXF integrated exchange format; ASC, DEL, WSF may cause data loss across platforms, IXF is used across platforms; DEL files are visible, and IXF files are not visible. Export command: db2 export to test. ixf of ixf select * from table; import command: db2 import from test. ixf of ixf insert_update into table; the insert methods include insert, insert_update, replace, replace_create (only in ixf format), and create (only in ixf format ); db2move can be used to migrate the entire database. The syntax format is db2move <dbname> <action> <option>. Actions include export, import, copy, and load. The command: db2move mydatabase export is imported to the current directory;