Last month, a client told me that on his product server, importing into a table with schema specified took about 700 seconds, while importing into the same table without schema, it only took 100 seconds: db2 "import from date.ixf of ixf commitcount 10000 insert into tbl_cufms_cuslt_settle_rslt_mchnt"                    # this command took about 100 seconds   db2 "import from date.ixf of ixf commitcount 10000 insert into... [More]

Tags:  db2;import;performance