Hello,
I have a Linux box (RH 4 Update 2 / kernel 2.6) running DB2 V8 FP 10.
My application is continuosly inserting data to a table. The statement
is a simple "insert into table values (a,b), ... (c,d)". 50 rows are
inserted per transaction, and a Commit is issued after the insert.
I created event monitor and got odd insert times. They vary from 0.5s
to 40+s !
I have taken snapshots and there does not seems to exist any lock-wait
that could explain this delay. Also, examining the operating system
performance counters, I can see that my CPU spends about 50% on iowait
operations. Memory is fairly constrained, but eventually there is about
1GB of free RAM available. (out of 6Gb + 2Gb/swap)
Can anyone suggest something that may be looked within DB2 to
understand why my system is spending too much time doing IO operations?
I have taken explain snapshots on the INSERT statement and all costs
seems very low.
I just need to make sure this is not a DB2 problem, before contacting
our system admins.
db2diag.log does not have a single error message.
Thanks in advance,