I'm having problems with exporting in IXF format.  When I export a file in IXF format and then load it as a table using the import command, the export numbers and the import numbers do not match.
 
========================================================
I export 16,000,000 rows from a table in IXF format. 
========================================================
connect to proddb user db2admin;
EXPORT TO c:\data\test\test0817.ixf OF IXF
MESSAGES c:\data\test\test\test0817.log
SELECT
  RECNUM, 
  MEMNUM, 
  MEMNAME, 
  LAST_UPD_DATE
FROM PRD.MEMBER where LAST_UPD_DATE > '1999-12-31';
disconnect current;
========================================================
After exporting, I create  a new table using the following in command center:
========================================================
connect to TESTDB user db2admin;
import from f:\data\update\tst\test.ixf of IXF commitcount 1000
create into TST.MEMBER
disconnect current;
 
When create table is complete, I notice 7,435,000 rows were read and 7,435,000 rows were loaded.
 
Has anyone experienced this problem? What am I doing wrong?
 
I'm open to all suggestions..
 
Thank you in advance.

Reply via email to