According to the DB2 manual, I didn't notice an SQL command for RUNSTATS.
Is it possible to perform something like RUNSTATS via an SQL statement?
Im using 8.1.3 PE on w2k.
Thanks

Some of the statistics in the catalog can be updated manually with an SQL statement. For example you could count the rows in an SQL statement and update the CARD column in syscat.tables. But you will not get all statistics, and it will not be as efficient, so I can't imagine why you want to do that.

Thanks for your reply.
To add some more background information, the reason why I was asking, was
because Im interfacing via php, and Im looking to see if I can maintain tables,
like how mySQL/PostgreSQL has Optimize/Vacuum.

So Im taking it as it cannot be done, and thats not a problem for me.
Just wanted to make sure that I didn't miss anything in the manual...
Thanks

If you can issue a db2look command, so you can get the UPDATE statements to SYSSTAT.xxx to update info for the table.
db2look -d db-alias -z schemaname -t tablename -e -m

HTH,
Ruby

If you will be able to issue OS commands from a php script (Some languages, eg C, Java ,provide options to call system commands ...

From the system command shell, you can issue RUNSTATS

Cheers
Sathyaram