runstats in UDB environment

John Lantz

runstats in UDB environment
I have an table in the UDB EE environment with 5 indexes on it and I'm
having trouble running RUNSTATS. The syntax I'm using is "RUNSTATS ON
TABLE xxx.xxx AND INDEXES ALL SHRLEVEL CHANGE" When I try to run RUNSTATS,
I get the SQL2314W message. The error says that you should issue a
runstats for both the table and index. I thought that was what I was
doing. Is it because the tables are being updated as I run this command in
the middle of the day?

Thanks



[login to unmask email]

Re: runstats in UDB environment
(in response to John Lantz)
John,

Give this a try...

runstats on table <schema.table> with distribution and detailed indexes all
shrlevel change;

Regards,
Jay


Jay Reavill
[login to unmask email]
IBM Global Services
Tampa, Florida
Tel: (813) 356-5317, Tie Line 8-697-5317

-----------------------------------------------------
Happiness is not around the corner.
Happiness is the Contour (SVT) of the road.
-----------------------------------------------------
The early bird gets the worm,
but the second mouse gets the cheese.
-----------------------------------------------------




John Lantz
<[login to unmask email] To: [login to unmask email]
HNA.COM> cc:
Sent by: DB2 Data Subject: runstats in UDB environment
Base Discussion
List
<[login to unmask email]
LASSOC.COM>


12/31/02 09:39 AM
Please respond to
DB2 Data Base
Discussion List





I have an table in the UDB EE environment with 5 indexes on it and I'm
having trouble running RUNSTATS. The syntax I'm using is "RUNSTATS ON
TABLE xxx.xxx AND INDEXES ALL SHRLEVEL CHANGE" When I try to run RUNSTATS,
I get the SQL2314W message. The error says that you should issue a
runstats for both the table and index. I thought that was what I was
doing. Is it because the tables are being updated as I run this command in
the middle of the day?

Thanks



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can