RE: Re: onstat -g iof sanity check [36143]

John what version of 11.70 did the onstat -g ioh come in?? Bruce Simms Data Base Services TALX, Provider of Equifax Workforce Solutions 2330 Ball Drive St. Louis, MO 63146 Phone (314) 214-7703 Cell (314) 496-6883 FAX (314) 983-3238 Bruce.Simms@Equifax.com IBM Champions -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John Miller iii Sent: Wednesday, December 02, 2015 11:49 PM To: ids@iiug.org Subject: [IE] Re: onstat -g iof sanity check [36143] If you are using a newer version (late 11.7 or any 12) of Informix,&= nbsp; I would start using onstat -g ioh instead of onstat -g iof.&nbs= p; The information is about the same, but with onstat -g ioh you have= 60 one minute averages for each chunk. With onstat -g iof you = have very long running averages and it is very hard to catch spikes.<= br> John F. Miller III STSM, Lead Architect [1]miller3@us.ibm.com 503-747-1366 IB= M Informix Dynamic Server (IDS) [2]-----ids-bounce= s@iiug.org wrote: ----- >To: ids@iiug.org >From: "MARK SCRANTON" >Sent by: [3]= ids-bounces@iiug.org >Date: 12/02/2015 06:35PM >Subject: on= stat -g iof sanity check [36139] > >onstat -g iof output ... <= br>> >The "avg. time" field (under each chunk) is in milliseconds,= correct? >So a >value of 0.0860 =3D 86ms? I'm seeing some sho= cking numbers but want to >confirm >first. IO/s vs. service ti= mes are inverted, which would make sense. > >What are some bas= eline metrics for service times and IO/S on SSD's? I >remember &g= t;all sorts of numbers from over the years but never for SSDs. I'm >s= eeing as low >as 11 IO/S and as high as 86ms service times for kaio = reads. > >Art will enjoy this ... we're still on RAID 5 and th= e chance of >convincing >them of it's "bad choice" is slim. Bu= t I'm hoping Art will chime in >here with >respect to the iof = output. > >Thanks - >Mark Scranton >The Mark Scr= anton Group >[4]mark@markscranton.com > > >*******************= ************************************************** >********** &g= t; Forum Note: Use "Reply" to post a response in the discussion forum. = > > > References 1. =3D"mailto:miller3@us.ibm.com" 2. 3D"mailto:-----ids-bounces@iiug.org" 3. 3D"mailto:ids-bounces@iiug.org" 4. 3D"mailto:mark@markscranton= ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. This message contains proprietary information from Equifax which may be confidential. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify by e-mail postmaster@equifax.com. Equifax® is a registered trademark of Equifax Inc. All rights reserved.

Original post: John what version of 11.70 did the onstat -g ioh come in?? Bruce Simms Data Base Services TALX, Provider of Equifax Workforce Solutions 2330 Ball Drive St. Louis, MO 63146 Phone (314) 214-7703 Cell (314) 496-6883 FAX (314) 983-3238 Bruce.Simms@Equifax.com IBM Champions Reply: I'm not seeing the -g ioh in the 11.70 code at all, not even the last 11.70.FC8W1 release. It does show up immediately in 12.10.xC1 though. Jacques Renaut IBM Informix Advanced Support APD Team