Db2 import and export table data

Db2 import and export table data 1. export the DEL Text File export to D: \ t_testtable2012121_del of del select * from T_TESTTABLE @ www.2cto.com 2. export the ixf text file. the ixf file contains the table structure. The db2 database information export to D: \ t_testtable2012121_ixf of ixf select * from T_TESTTABLE @ 3. insert import from d: \ t_testtable2012121_del of del insert into T_TESTTABLE @ import from d: \ t_testtable2012121_ixf of ixf insert into T_TESTTABLE @ 4. import data replace import from d: \ t_testtable2012121_del of del replace into T_TESTTABLE @ import from d: \ t_testtable2012121_ixf of ixf replace into T_TESTTABLE @ www.2cto.com 5. import data to create a table structure and import data import from D: \ T_TESTTABLE20121220.ixf of ixf create into T_TESTTABLE @ 6. load client from d: \ t_testtable2012121_ixf of ixf insert into T_TESTTABLE @ load client from d: \ t_testtable2012121_del OF del insert into T_TESTTABLE @ 7. the imported data contains the table load client from d: \ t_testtable2012121_ixf of ixf modified by identityoverride insert into T_TESTTABLE @ 8. solve the Problem OF garbled Chinese characters in the DEL file for data import load client from d: \ t_testtable201212?del OF del modified by codepage = 1386 insert into T_TESTTABLE @ if there are Chinese garbled characters and identities, write the first 9 in codepage. when importing a data load table, the table locks the load client from c: \ empty file. txt of del terminate into T_TESTTABLE @