Dear Listers, I seen in the recent days about death by random I/O. While co realting the same with my problem I had seen that one query was behaving very badly and after tuning it worked okay. Here is the instances for this. Before tuning the ratio of SYNC read I/O to Number of GETPAGES was high. After tuning the query the ratio decreased to one 10th of the earlier value. Now I ask you all to answer and favor me. Was this the cause that WAIT time in DB2 was high. I mean the Ratio of GETPAGES/SYNC I/O is more means more DB2 I/O wait. If this is true what has caused this.
Second question. I had seen that the SYNC READ WAIT and ASYNCH read I/O wait was more for the query. Out of these which causes more Db2 I/O wait. Cost wise which is cheaper whether SYNC READ I/O wait or ASYNCH read I/O wait.
I would wait for your reponses.
Sign-up for Ads Free at Mail.com