The CPU Cost of a DB2 I/O contd >The only difference between the two queries was physical I/O And the dynamic statement cache >Here is the maths… The fetch I/O CPU difference –2826us – 738us = 2088us Minus I/O CPU time for the asynchronous I/O –2088us – (7us * 89) = 1465us Divide this figure by the 21 synchronous I/Os –1465us / 21 = 69.76us per synchronous I/O >The accepted figure is 33us per synchronous I/O (4K page) This will alter with different machines, OS versions etc.
{}