Reorg in DB2

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

Do more with

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

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

The chapter on reorganizations is here:

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/t0024848.htm

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

wmp

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.

Tom

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