Process Recommendations › Ways to Improve Processes › Specific Encyclopedia Functions › Model Delete › Techniques

Techniques

The following techniques can improve the process involving model delete:

• Schedule model deletes to run in batch during non-peak processing hours.
• Schedule model deletes prior to a REORG.
• Rename models intended for delete and schedule the delete during a time period for batch single stream processing.
• To reduce CPU and elapse time for a model delete, alter the tablespace locksize from ANY to TABLESPACE. The delete function provides an option to lock tables at the table level. You must be an encyclopedia administrator to use this option.

Note: Altering the locksize to TABLESPACE locks all other users out of the encyclopedia tables. See the discussion of faster model copy and delete.