restructure and reorg
search cancel

restructure and reorg

book

Article ID: 72487

calendar_today

Updated On:

Products

IDMS IDMS - Database IDMS - ADS

Issue/Introduction



Need to run a Restructure and Reorg for a database.  Which should be done first?

Environment

Release: IDADSO00100-18.5-ADS-for CA-IDMS
Component:

Resolution

Recommendation is to run the Restructure first then the Reorg.  If the Restructure affects any key values, you want the Reorg to be able to use these new key value, ie index key, calckey.  After the Restructure is run, you run the Reorg. The Reorg needs to use a subschema that represents the database as it is after the Restructure. This will allow the Reorg to read the records at their new length.