db2look has a useful option '-m' that allows you to 'replicate' a database's statistics, which is not unlike Oracle's DBMS_STATS.EXPORT_XXX_STATS. One advantage it has over the export is that it gives you an insight into the stats components required, in the form of individual UPDATE statements. The other advantage is that you don't have to prepare a table to be 'exported' or 'imported' into.
eg:
db2look -d sample -t t1 -m -o test.sql
This will 'look' into the database 'sample', pull stats only for table 't1', and redirects the output to file 'test.sql'.
One word: Convenient!
No comments:
Post a Comment