RUNSTATS and AS/400 
Author Message
 RUNSTATS and AS/400
Help!

Does the AS/400 have the same concept of statistics as DB2 2 and DB2
UDB?

If so, what's the command?

when I try

RUNSTATS ON TABLE MYSCHEMA.MYTABLE WITH DISTRIBUTION AND DETAILED
INDEXES ALL;

It barfs saying RUNSTATS is an invalid token.

Any ideas?

Ciao
Fuzzy
:-)



Sun, 08 Sep 2002 03:00:00 GMT
 RUNSTATS and AS/400

The AS/400 optimizer does utilize statistics like the other DB2's.  However,
there's no need for a RUNSTAT utility since DB2 UDB for AS/400 automatically
maintains and stores the statistics inside the table & index objects.  

--
Kent Milligan, DB2 & BI team
PartnerWorld for Developers, AS/400

(opinions stated are not necessarily those of my employer)



Sun, 08 Sep 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Programming the AS/400 (Delphi/400 vs LightLib/400 (EasyCom)

2. AS/400 DB2/400

3. AS/400 - Seeking info on using VB to access DB2/400

4. AS/400, anyone used Delphi to access DB2/400

5. US-NC- AS/400 Programmer (AS/400 RPG COBOL Year 2000) DB Basics, Inc.#185

6. Oracle Transparent Gateway to AS/400 - processes on AS/400

7. Rexx/400-DB2/400 ExecSQL/SQLCode -5032

8. Dynamic SQL for DB2/400 from RPG and/or Rexx/400

9. AS/400 DB/400 Gateway?


 
Powered by phpBB® Forum Software