Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Does DB2/400 have the equivalent of runstats?

740 views
Skip to first unread message

Fuzzy

unread,
Nov 19, 2001, 7:19:57 PM11/19/01
to
Hi all,

DB2 on every other platform has the concept of optimiser statistics to
help the db engine best optimise SQL queries. These are generated
using the RUNSTATS command.

Does DB2/400 have the same concept, and if so, a command like RUNSTATS
to generate the stats?

Ciao
Fuzzy
:-)

Newsgroups

unread,
Nov 20, 2001, 6:15:31 AM11/20/01
to
No other DB2 platform automacally optimizes the RDBMS for you. RUNSTATS is
unncessary for DB2/400.

Dave


"Fuzzy" <fuz...@nospam.usa.net> wrote in message
news:3bf9a15d...@news.netspeed.com.au...

Marc Rauzier

unread,
Nov 20, 2001, 6:43:24 AM11/20/01
to
Newsgroups racontait dans comp.sys.ibm.as400.misc:

> No other DB2 platform automacally optimizes the RDBMS for you.
> RUNSTATS is unncessary for DB2/400.

Not exactly. The DB2/400 optimizer is able to suggest you to create
permanent indexes when it creates a temporary one. It does never
create it in a permanent way, which could be said as an automatic
optimization.

>
> Dave
>
>
> "Fuzzy" <fuz...@nospam.usa.net> wrote in message
> news:3bf9a15d...@news.netspeed.com.au...
>> Hi all,
>>
>> DB2 on every other platform has the concept of optimiser
>> statistics to help the db engine best optimise SQL queries. These
>> are generated using the RUNSTATS command.
>>
>> Does DB2/400 have the same concept, and if so, a command like
>> RUNSTATS to generate the stats?

You can use the database monitor thru Operations Navigator.

>>
>> Ciao
>> Fuzzy
>> :-)
>
>
>

--
Cordialement/Best regards
Marc Rauzier

Kent Milligan

unread,
Nov 20, 2001, 10:05:41 AM11/20/01
to
No - DB2 UDB for iSeries automatically keeps the stats updated in the Table and
Index objects as the data is changed. You can find a few more details at:
http://www.iseries.ibm.com/developer/bi/documents/strategy/strategy.html

--
Kent Milligan, DB2 & BI team
PartnerWorld for Developers, iSeries
km...@us.removethis.ibm.com GO HAWKEYES!!
>>> www.iseries.ibm.com/db2
(opinions stated are not necessarily those of my employer)

Dale A. Berta

unread,
Nov 20, 2001, 4:56:23 PM11/20/01
to
You also should try running your queries/SQL with debug active, then check
the messages in the joblog. These messages will tell you which access paths
are considered (and why they weren't used), and sometimes tells you what
access path to create (permanently) to improve future performance of the
same query.

"Fuzzy" <fuz...@nospam.usa.net> wrote in message
news:3bf9a15d...@news.netspeed.com.au...

Fuzzy

unread,
Nov 26, 2001, 5:39:40 PM11/26/01
to
On Tue, 20 Nov 2001 00:19:57 GMT, fuz...@nospam.usa.net (Fuzzy)
wrote:

Thanks everyone for the responses ... things are much clearer now.

Ciao
Fuzzy
:-)

0 new messages