an intersting example for db2batch from IBM
[db2inst1@s3 ~]$ db2batch -d sample -f testdata.db2 -o r 0 p 3 | tail -18
* Summary Table:
Type Number Repetitions Total Time (s) Min Time (s) Max Time (s) Arithmetic Mean Geometric Mean Row(s) Fetched Row(s) Output
--------- ----------- ----------- -------------- -------------- -------------- --------------- -------------- -------------- -------------
Statement 1 1 1.596828 1.596828 1.596828 1.596828 1.596828 0 0
Statement 2 1 0.015400 0.015400 0.015400 0.015400 0.015400 0 0
Statement 3 1 0.000530 0.000530 0.000530 0.000530 0.000530 100 0
Statement 4 1 0.410534 0.410534 0.410534 0.410534 0.410534 0 0
* Total Entries: 4
* Total Time: 2.023292 seconds
* Minimum Time: 0.000530 seconds
* Maximum Time: 1.596828 seconds
* Arithmetic Mean Time: 0.505823 seconds
* Geometric Mean Time: 0.048095 seconds
---------------------------------------------
* Timestamp: Tue Mar 31 2015 04:35:57 GMT
如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！
赞0作者其他文章
评论 1 · 赞 0
评论 0 · 赞 1
评论 0 · 赞 2
评论 0 · 赞 0
评论 0 · 赞 2
添加新评论0 条评论