Sysdistrib behavior: 11.50 versus 11.70

Posted in 2013

Plugge, Joe R. — Mon, 11 Nov 2013 19:31:42 — source: IIUG Forums & Mailing Lists

Interesting behavior I noticed between 11.50 and 11.70 regarding the sysdistrib table. On 11.50.FC9XA if I run dostats on a table, it updates the sysdistrib for that table. If I run it on 11.70.FC3, it does not. I have to run dostats with the -L and then re-run the dostats for the sysdistrib table to get updated. Anybody else notice this behavior? Joe

↪ replying to Plugge, Joe R.

Art Kagel — Mon, 11 Nov 2013 19:41:16 — source: IIUG Forums & Mailing Lists

In v11.70 and later, if AUTO_STAT_MODE is set in the onconfig file (default if not present), update statistics will ONLY perform work if the number of inserts, updates, and deletes against the table since the last time stats were updated exceeds the STATCHANGE level that is set either in the ONCONFIG file or as an attribute to individual tables. The default STATCHANGE level is 10%. This is similar to use the dostats "-b -B 10" options. If this threshold of changes has not been exceeded then update statistics doesn't do anything, the commands that dostats runs become no-op. You can change the behavior back to the way it worked in v11.50 and earlier by setting AUTO_STAT_MODE to zero (0). You can override this no-op behavior in individual update statistics comands by adding the FORCE clause which can be enabled in dostats using the --force-run option. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Nov 11, 2013 at 2:31 PM, Plugge, Joe R. <JRPlugge@west.com> wrote: > Interesting behavior I noticed between 11.50 and 11.70 regarding the > sysdistrib table. On 11.50.FC9XA if I run dostats on a table, it updates > the > sysdistrib for that table. If I run it on 11.70.FC3, it does not. I have to > run dostats with the -L and then re-run the dostats for the sysdistrib > table > to get updated. Anybody else notice this behavior? > > Joe > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e011827aeff198204eaebe99e

↪ replying to Art Kagel

Plugge, Joe R. — Mon, 11 Nov 2013 20:15:55 — source: IIUG Forums & Mailing Lists

Thanks Art .... I appreciate it. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Monday, November 11, 2013 1:41 PM To: ids@iiug.org Subject: Re: Sysdistrib behavior: 11.50 versus 11.70 [31923] In v11.70 and later, if AUTO_STAT_MODE is set in the onconfig file (default if not present), update statistics will ONLY perform work if the number of inserts, updates, and deletes against the table since the last time stats were updated exceeds the STATCHANGE level that is set either in the ONCONFIG file or as an attribute to individual tables. The default STATCHANGE level is 10%. This is similar to use the dostats "-b -B 10" options. If this threshold of changes has not been exceeded then update statistics doesn't do anything, the commands that dostats runs become no-op. You can change the behavior back to the way it worked in v11.50 and earlier by setting AUTO_STAT_MODE to zero (0). You can override this no-op behavior in individual update statistics comands by adding the FORCE clause which can be enabled in dostats using the --force-run option. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Nov 11, 2013 at 2:31 PM, Plugge, Joe R. <JRPlugge@west.com> wrote: > Interesting behavior I noticed between 11.50 and 11.70 regarding the > sysdistrib table. On 11.50.FC9XA if I run dostats on a table, it > updates the sysdistrib for that table. If I run it on 11.70.FC3, it > does not. I have to run dostats with the -L and then re-run the > dostats for the sysdistrib table to get updated. Anybody else notice > this behavior? > > Joe > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e011827aeff198204eaebe99e ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.