PRMORPH Best Practice

Document ID : KB000021883
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

After executing PRMORPH 'orphan cleanup utility' in commit mode with option #0 'Process all the above', a subsequent run in report mode may show many more objects which are orphans in the Repository.

Solution:

This occurs because as orphans are deleted from the Repository, additional ones may surface that were related in some way to the original objects. For this reason, it is recommended to invoke the PRMORPH utility four times specifying a different option for each pass to ensure that all orphans in the Repository are removed.

  1. On the first pass specify option #2 'Process Orphaned ENTITIES'.
  2. On the 2nd pass specify option #1 'Process Orphaned XREFs'.
  3. On the 3rd pass specify option #3 'Process Orphaned Relationships'.
  4. On the 4th pass specify option #0 '(DEFAULT) Process all of the above;