Displaying 1 result from an estimated 1 matches for "wc8ws".
Did you mean:
iccws
2016 Apr 14
0
How to optimize for IBM db2?
Hi.
I have performance problems with IBM DB2 10.5 server on KVM guest:
[db2inst1@wc8ws-auth ~]$ time db2 create db test
DB20000I The CREATE DATABASE command completed successfully.
real 7m46.155s
user 0m0.022s
sys 0m0.027s
It takes 30 seconds to create a database on an image mounted with -oloop.
I think it's because db2 uses O_DIRECT to ensure con...