Background Process for Reorgcheck

[naval123]

HI

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

Thanks

[SaadAli]

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