Host Encyclopedia Utilities › TIECLEAN

TIECLEAN

Use this utility once a week. This utility deletes all components of any model that does not have a row in the DMDL table

An orphan model can occur if any of the following actions fail:

• Copying a model
• Creating a model from a subset
• Checking in a new model
• Deleting a model

In order to perform incremental COMMITs during these actions, the system inserts the row into DMDL differently depending on the action:

• The row is inserted last when a model is being created (the first three bullets).
• The row is deleted first when a model is being deleted (the fourth bullet).

This utility removes all of the stranded components of the model and allows for the reuse of space. If you are using non-segmented tablespaces, the space is not available until you REORG the database.

This utility performs COMMITs as it runs. You can run this utility daily with a time parameter. If the utility does not complete before exceeding the time parameter, all components prior to the last COMMIT are deleted. Components that did not get deleted are deleted the next time the utility runs. The next run continues the clean up.