Reorg in DB2

xcorpius used Ask the Experts™
Could you explain me how to do a reog and types of reorg in db2 databases?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2013
Top Expert 2013
You should always go to the appropriate Infocenter (if IBM software) first:

The chapter on reorganizations is here:

Get into details by expanding the topic "Maintaining the organization of your tables and indexes" on the left.


Minor note -- The platform that DB2 is running on can make a difference. The AS/400 platform series does not use (nor require) most of what's in the links above. In that series of systems, DB2 is integrated with the OS and all compilers, so table reorgs use a standard platform OS command (RGZPFM) rather than any DB2-specific functions.

This comment probably is irrelevant to the OP, but later viewers might benefit.


Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial