Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Accessing reorg time

One Search400.com member writes, "We have sales order file that is about 27 GB in size and contains 27 million records. The file has approximately 12 million deleted records. Is it possible to reorg that file dynamically? How can I assess the time it will take to complete the reorg in the event I arrange the process on a dedicated mode?" DB2 expert Kent Milligan responds.

We have sales order file that is about 27 GB in size and contains 27 million records. The file has approximately 12 million deleted records. Is it possible to reorg that file dynamically? How can I assess the time it will take to complete the reorg in the event I arrange the process on a dedicated mode?
Yes, with the V5R3 enhancements to the RGZPFM CL command. The new Lock parameter allows you to allow read and/or write access during the reorg. In addition, the ALWCANCEL parameter allows you to run the reorg for a while and then stop the reorg than restart the reorg again later -- DB2 picks up the reorg from where it was stopped previously.

You might also want to consider reusing deleted records to minimize the need for reorg operations.

Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close