467,202 Members | 1,106 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,202 developers. It's quick & easy.

Background Process for Reorgcheck

HI

Plz tell me
what are the background process for reorgchk? Tell the parameters associated with reorgchk?

Thanks
Aug 16 '07 #1
  • viewed: 1816
Share:
1 Reply
Hi,

Calculates statistics on the database to determine if tables or indexes, or both, need to be reorganized or cleaned up.

Command syntax

.-UPDATE STATISTICS--.
>>-REORGCHK--+--------------------+----------------------------->
'-CURRENT STATISTICS-'

.-ON TABLE USER-----------------.
>--+-------------------------------+---------------------------><
'-ON--+-SCHEMA--schema-name---+-'
| .-USER-------. |
'-TABLE--+-SYSTEM-----+-'
+-ALL--------+
'-table-name-'

example:

>db2 reorgchk update statistics on table <Schemaname>.<Tablename>

Refer:

http://publib.boulder.ibm.com/infocenter/db2luw/v8//index.jsp

Regards

SaadAli
Aug 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Alan Walkington | last post: by
5 posts views Thread by Joshua Beall | last post: by
1 post views Thread by Ravi Tallury | last post: by
4 posts views Thread by pokémon | last post: by
3 posts views Thread by Jenkins | last post: by
reply views Thread by Gomaw Beoyr | last post: by
2 posts views Thread by Paul Hatcher | last post: by
2 posts views Thread by Hilmar Bunjes | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.