db2导出导入数据时间统计

trzxycx

　　导出数据原始总量4000万
db2inst2@gd1:~>  time db2 "import from bt_clear_trans_201510.del of del  commitcount 1000 insert into epay.bt_clear_trans";
SQL3109N  The utility is beginning to load data from file
"bt_clear_trans_201510.del".
SQL3221W  ...Begin COMMIT WORK. Input Record Count = "1000".
SQL3222W  ...COMMIT of any database changes was successful.
...
Number of rows read         = 2687797
Number of rows skipped      = 0
Number of rows inserted     = 2687797
Number of rows updated      = 0
Number of rows rejected     = 0
Number of rows committed    = 2687797

real    9m41.979s
user    0m0.016s
sys     0m0.016s

db2inst2@gd1:~> time db2 "import from ht_trans_201510.del of del  commitcount 1000 insert into epay.ht_trans";
SQL3109N  The utility is beginning to load data from file
"ht_trans_201510.del".
SQL3221W  ...Begin COMMIT WORK. Input Record Count = "1000".
SQL3222W  ...COMMIT of any database changes was successful.
SQL3221W  ...Begin COMMIT WORK. Input Record Count = "2000".
...  
SQL3221W  ...Begin COMMIT WORK. Input Record Count = "2687000".
SQL3222W  ...COMMIT of any database changes was successful.
SQL3110N  The utility has completed processing.  "2687797" rows were read from
the input file.
SQL3221W  ...Begin COMMIT WORK. Input Record Count = "2687797".
SQL3222W  ...COMMIT of any database changes was successful.
SQL3149N  "2687797" rows were processed from the input file.  "2687797" rows
were successfully inserted into the table.  "0" rows were rejected.

Number of rows read         = 2687797
Number of rows skipped      = 0
Number of rows inserted     = 2687797
Number of rows updated      = 0
Number of rows rejected     = 0
Number of rows committed    = 2687797

real    9m15.941s
user    0m0.012s
sys     0m0.016s
向空表中导入数据
db2inst2@gd1:~> time db2 "export to ht_trans_201508.del of del select * from ht_trans where TRANS_DATE>=date('2015-08-01') and TRANS_DATE<date('2015-09-01')";
SQL3104N  The Export utility is beginning to export data to file
"ht_trans_201508.del".
        SQL3105N  The Export utility has finished exporting "4307761" rows.

Number of rows exported: 4307761

real    3m25.681s
user    0m0.012s
sys     0m0.016s
db2inst2@gd1:~>  time db2 "export to ht_trans_201507.del of del select * from ht_trans where TRANS_DATE>=date('2015-07-01') and TRANS_DATE<date('2015-08-01')";
SQL3104N  The Export utility is beginning to export data to file
"ht_trans_201507.del".
SQL3105N  The Export utility has finished exporting "3988996" rows.

Number of rows exported: 3988996

real    3m5.855s
user    0m0.012s
sys     0m0.012s

db2inst2@gd1:~> time db2 "export to ht_trans_201506.del of del select * from ht_trans where TRANS_DATE>=date('2015-06-01') and TRANS_DATE<date('2015-07-01')";
SQL3104N  The Export utility is beginning to export data to file
"ht_trans_201506.del".
SQL3105N  The Export utility has finished exporting "3494833" rows.

Number of rows exported: 3494833

real    2m43.398s
user    0m0.012s
sys     0m0.016s
db2inst2@gd1:~> time db2 "export to ht_trans_201505.del of del select * from ht_trans where TRANS_DATE>=date('2015-05-01') and TRANS_DATE<date('2015-06-01')";
SQL3104N  The Export utility is beginning to export data to file
"ht_trans_201505.del".
SQL3105N  The Export utility has finished exporting "3062974" rows.

Number of rows exported: 3062974

real    2m21.347s
user    0m0.020s
sys     0m0.008s
db2inst2@gd1:~> time db2 "export to ht_trans_201504.del of del select * from ht_trans where TRANS_DATE>=date('2015-04-01') and TRANS_DATE<date('2015-05-01')";
SQL3104N  The Export utility is beginning to export data to file
"ht_trans_201504.del".
SQL3105N  The Export utility has finished exporting "2794188" rows.

Number of rows exported: 2794188

real    2m12.392s
user    0m0.012s
sys     0m0.012s