International Informix Users Group

	Informix News

16 October 08 - VendorRate - Informix Earns Top Customer Satisfaction Score on VendorRate in Q3... Read 14 August 08 - IIUG.org - Sellout Expected for the 2009 IIUG Informix Conference... Read 29 April 08 - IntelligentEnterprise.com - IBM Informix Upgrade Enhances Clustering, Database Management... Read 29 April 08 - itweek.com - IBM 'Cheetah 2' mauls data costs... Read 28 April 08 - eWeek.com - IBM Uncages Cheetah 2 Data Server... Read 28 April 08 - CNNMoney.com - IBM Helps Clients Reduce Data Management Costs With New Informix Dynamic Server... Read 09 April 08 - CNNMoney.com - MediaSpan Embeds IBM Informix Dynamic Server Software for Delivering News to Print, Web and Wireless Devices... Read 08 April 08 - IT-Director.com - Informix seeks developers... Read 18 February 08 - marketwire.com - Icarus Studios Partners With IBM to Upgrade Performance, Availability for Its Online Games... Read 17 January 08 - eWeek.com - IBM Adds Mac Support to IDS for Higher Education... Read 17 January 08 - informationweek.com - Lotus Notes For iPhone Signals Closer Ties Between IBM, Apple... Read 16 January 08 - marketwire.com - IBM Informix Dynamic Server to Deliver Support for Mac OS X... Read 16 January 08 - internetnews.com - IBM's IDS to Support Mac Platform... Read 28 June 07 - REG Developer - IBM and Informix tie down Cheetah... Read 27 June 07 - CBRonline.com - IBM corrects its own Informix customer figures... Read 14 June 07 - vnunet.com - IBM changes spots with Informix 'Cheetah' database... Read 14 June 07 - eChannelLine - IBM expands scope for IDS... Read 14 June 07 - Resellernews - IBM: Informix database alive and kicking... Read 13 June 07 - DB2 Magazine - Cheetah is now out of the gate... Read 12 June 07 - IBM - IDS 11 release announcement (pdf)... Read 12 June 07 - ChannelWeb Network - IBM Uncages IDS 11, Aka Cheetah, Database... Read 12 June 07 - eWeek.com - IBM's 'Cheetah' Ready to Pounce... Read 12 June 07 - InformationWeek - IBM Unleashes 'Cheetah' Database... Read 12 June 07 - WebWire - IBM Strengthens Database Portfolio With New Informix Dynamic Server... Read 12 June 07 - Intelligent Enterprise - IBM Unveils Informix Upgrade... Read 12 June 07 - ComputerWeekly.com - IBM's Cheetah IDS makes leap to better data centre clustering... Read 12 June 07 - ebiz - IBM Unveils Next Generation Informix Dynamic Server... Read 12 June 07 - computerworld.com - Will 'Cheetah' help IBM's Informix chase down market share?... Read 12 June 07 - Internetnews.com - No Data Can Outrun This 'Cheetah'... Read 12 June 07 - de.internet.com - IBM neuer Datenbank-Server mit Codenamen Cheetah ist fertig... Read 12 June 07 - verifox.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read 12 June 07 - golem.de - Informix 11 vorgestellt... Read 12 June 07 - Computerwoche.de - IBM stellt neue Informix-Version vor... Read 12 June 07 - IBM.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read 12 June 07 - Heise - IBM gibt Informix 11 frei... Read 25 May 07 - Taiwan.CNET.com - Local Taiwan Informix user group established... (Chinese language) ... Read 18 May 07 - ChannelWeb Network - IBM Musters Partners For Cheetah Release... Read 18 May 07 - eWeek.com - IBM Looks to 'Cheetah' to Speed Up Blade Servers... Read 7 May 07 - DB2 Magazine - SQL Shortcuts - Use these tricks to generate IDS SQL scripts... Read Previous news items

Home Member Area About IIUG

[ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

RE: Re: Update Statistics - Questions

Posted By:
Date:

You have to run update stats against the tables where indexes, or data has
changed.

Using PDQPRIORITY could be a good idea.
Document http://www.iiug.org/iuc2002_pdf/d13.pdf discuss update stats and
handles also PDQPRIORITY for stats.
But don't use it for update stats for procedure because PDQPRIORITY will be
stored in the procedure, so later when executing the procedures everyone has
this PDQPRIORITY and everyone try to catch enough resources. And this can
cause very much problems. I've the experience. (See also performance guide)

On the other hand you could find on the IIUG site a program 'dostats' that
do very well the work for you and there exists a script that allow to start
multiple 'dostats' program in parallel. Very efficient on multi-processors.

Yves

-----Original Message-----
From: nobody@ace.iiug.org [mailto:nobody@ace.iiug.org]
Sent: donderdag 8 mei 2003 10:55
To: ids@iiug.org
Subject: Re: Re: Update Statistics - Questions [1094]

Hi!

I actually do a lot of work with Informix migration to IDS9.30 and analyses
with performance.
When I have to run "update statistics low drop distributions"?
When I have to run "update statistics low" or " medium/high"?
When run "update statistics" every night on our databases.

When I run "update statistics low drop distributions" it tooks a very long
time.
Are there any possibilities to speed up this job ( I have read something
with PDQ???? )?

IDS 9.30FC3X3
Unix Tru64 5.1B

Regards
Wolfgang

------_=_NextPart_001_01C315F8.030F1A60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>RE: Re: Update Statistics - Questions [1094] </TITLE>
</HEAD>
<BODY>

You have to run update stats against the tables where =
indexes, or data has changed.


Using PDQPRIORITY could be a good idea. 
 Document <A =
HREF=3D"http://www.iiug.org/iuc2002_pdf/d13.pdf" =
TARGET=3D"_blank">http://www.iiug.org/iuc2002_pdf/d13.pdf</A> discuss =
update stats and handles also PDQPRIORITY for stats.
 But don't use it for update stats for procedure =
because PDQPRIORITY will be stored in the procedure, so later when =
executing the procedures everyone has this PDQPRIORITY and everyone try =
to catch enough resources. And this can cause very much problems. I've =
the experience. (See also performance guide)

On the other hand you could find on the IIUG site a =
program 'dostats' that do very well the work for you and there exists a =
script that allow to start multiple 'dostats' program in parallel. Very =
efficient on multi-processors.

Yves


-----Original Message-----
 From: nobody@ace.iiug.org [<A =
HREF=3D"mailto:nobody@ace.iiug.org">mailto:nobody@ace.iiug.org</A>]</FON=
T>
 Sent: donderdag 8 mei 2003 10:55
 To: ids@iiug.org
 Subject: Re: Re: Update Statistics - Questions =
[1094] 

 

Hi!


I actually do a lot of work with Informix migration =
to IDS9.30 and analyses with performance.
 When I have to run "update statistics low drop =
distributions"?
 When I have to run "update statistics low" =
or " medium/high"?
 When run "update statistics" every night =
on our databases.


When I run "update statistics low drop =
distributions" it tooks a very long time.
 Are there any possibilities to speed up this job ( I =
have read something with PDQ???? )?


IDS 9.30FC3X3
 Unix Tru64 5.1B


Regards
 Wolfgang


</BODY>
</HTML>
------_=_NextPart_001_01C315F8.030F1A60--

Messages In This Thread

Update Statistics - Questions
Meza, Silvana -- Wednesday, 15 January 2003, at 5:07 p.m.
- Re: Update Statistics - Questions
  ART KAGEL, BLOOMBERG/ 65E 55TH -- Thursday, 16 January 2003, at 9:08 a.m.
  - Re: Re: Update Statistics - Questions
    WOLFGANG NEUMAR -- Thursday, 8 May 2003, at 4:54 a.m.
    - RE: Re: Update Statistics - Questions
      Support Informix -- Friday, 9 May 2003, at 3:57 p.m.
- Fwd: Re: How to Reclaim Space in the chunks
  ART KAGEL, BLOOMBERG/ 65E 55TH -- Monday, 27 January 2003, at 11:34 a.m.
  - Re: Fwd: Re: How to Reclaim Space in the chunks
    Martin Fuerderer -- Tuesday, 28 January 2003, at 3:38 a.m.

[ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.