Hi all , As a DB2 specialist , i have reports showing a wait for io time in some programs. I did a SMF42 subtype 6 reports and , effectively, my datasets are in the top of the list , cut and pasted below from an Excel sheet. However , don't know if my calculation of the average response time of 9 ; which corresponds to 9 X 128ms = 1152ms , from the manual is correct. And sorry for the dummy question , what is a "correct" average response time , a few ms i suppose ...
Thank you Duc DATASET VOLSER RESPTIME IOCOUNT AVGCONCT AVGPEND AVGDISC DB2XXF0.DSNDBD.F4DB002.F4SS102.I0001.A001 XDBDO0 22.875 5379 5.187 0.125 17.250 DB2XXF0.DSNDBD.F3DB001.F3SS039.I0001.A001 XDBDM5 21.625 1141 16.750 0.125 4.437 DB2XXF0.DSNDBD.F3DB002.F3SS113.I0001.A001 XDBD8A 14.062 7489 1.875 0.125 11.625 DB2XXF0.DSNDBD.F3DB002.IF3TADR1.I0001.A001 XDBI16 12.875 2057 1.750 0.125 10.750 DB2XXF0.DSNDBD.F3DB001.F3SS037.I0001.A001 XDBDH3 9.562 3946 6.125 0.000 3.187 DB2XXF0.DSNDBD.F3DB001.IF3T1BGJ.I0001.A001 XDBI08 9.562 2038 5.625 0.000 3.562 DB2XXF0.DSNDBD.F3DB006.F3PS006.I0001.A003 XDBD53 9.187 1244 5.875 0.125 2.937 DB2XXF0.DSNDBD.F3DB006.F3PS006.I0001.A007 XDBDC0 9.062 1203 5.750 0.125 2.937 DB2XXF0.DSNDBD.F3DB006.F3PS006.I0001.A008 XDBDF6 9.062 1321 6.000 0.125 2.687 DB2XXF0.DSNDBD.F3DB006.F3PS006.I0001.A009 XDBDKD 9.062 1321 5.750 0.125 3.062 DB2XXF0.DSNDBD.F3DB006.F3PS006.I0001.A010 XDBDI2 9.062 1328 6.250 0.125 2.375 DB2XXF0.DSNDBD.F3DB001.IF3TCCTD.I0001.A001 XDBI4C 9.062 1057 5.625 0.000 3.187 DB2XXF0.DSNDBD.F5DB001.F5SS012.I0001.A001 XDBDG0 9.062 1926 7.000 0.125 1.625 ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
