db2导出导入数据时间统计
导出数据原始总量4000万db2inst2@gd1:~>time db2 "import from bt_clear_trans_201510.del of delcommitcount 1000 insert into epay.bt_clear_trans";
SQL3109NThe 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 delcommitcount 1000 insert into epay.ht_trans";
SQL3109NThe 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.
SQL3110NThe 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')";
SQL3104NThe Export utility is beginning to export data to file
"ht_trans_201508.del".
SQL3105NThe 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')";
SQL3104NThe Export utility is beginning to export data to file
"ht_trans_201507.del".
SQL3105NThe 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')";
SQL3104NThe Export utility is beginning to export data to file
"ht_trans_201506.del".
SQL3105NThe 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')";
SQL3104NThe Export utility is beginning to export data to file
"ht_trans_201505.del".
SQL3105NThe 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')";
SQL3104NThe Export utility is beginning to export data to file
"ht_trans_201504.del".
SQL3105NThe Export utility has finished exporting "2794188" rows.
Number of rows exported: 2794188
real 2m12.392s
user 0m0.012s
sys 0m0.012s
页:
[1]