Re: Buffer Waits

I re-read my note on buffer waits and realized that I left out an important piece of information. My buffer waits for any one query could increase by 10,000 or more. Why are buffwaits so high when I am doing only read activity? Is this normal and I shouldn't worry about it? While looking at the onstat -p output I come up with one more question. Why is there a lock request issued for every page read in a query? Just curious. Thanks to those of you who wrote me wanting to know why I was complaining about buffer waits near 0. Since I work at a university perhaps I'll signup for a class on writing. Dale Forrey, DBA email: forrey@wsu.edu Information Technology FAX: (509) 335-0540 Washington State University Phone: (509) 335-7098 PO Box 641222 Pullman, WA 99164-1222 ADABAS 6.2.1 on OS/390 Natural 2.2.8 Predict 3.4.1 Informix 7.30 UC3-1 on AIX 4.3.1