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
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