db2导出导入数据时间统计
导出数据原始总量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