Disclaimer!!!
This is a blog of some personal commands I like to use in my specific needs. If you find this blog and decide to ever use one of my commands do it at your own risk. I am not responsible on the context you apply anything recorded into this blog.
Thursday, April 3, 2008
DB2: Maintenance the 3rs
$ db2 "reorgchk update statistics on table all" > /tmp/reorgchk_rmdb_0216.out $ db2rbind [database] -l /tmp/db2rbind_rmdb_0216.out all $ db2 "reorg table [schema].[table]" $ db2 "reorg indexes all for table [schema].[table]"
No comments:
Post a Comment