how to execute runstats in stored procedure

[sansaniwal12]

Hi,
we want to execute runstats for all database tables in one go.In db2 v9, there is no such option to run runstats schema vise or for complete database.So,can we execute runstats from a stored procedure.

[Purple]

I have moved this to the forum because you have posted this in the articles section.

MODERATOR

[dewa81]

user REORGCHK command to run runstats on all the tables of the database