Before you begin...

To reorganize a table, you must have one of the following authorities:

• SYSADM
• SYSCTRL
• SYSMAINT
• DBADM
• CONTROL privilege on the selected table

For an indication of whether it would be beneficial to reorganize your table, you can run the REORGCHK command. This command is used through the Command Center.

A table cannot be reorganized if both of the following statements are true:

• The table resides in one or more database managed space (DMS) table spaces.
• An online backup of a table space that contains the table is currently in progress.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]