First question, why do you want to import 16 million rows? Create the
table yourself first, and then do a LOAD, it will go much faster.
"LeGrand Decius" <[EMAIL PROTECTED]>@lists1.ba.best.com on 08/20/2001
09:38:35 AM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: DB2EUG: Problem with Export ixf format
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.
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
