Process Recommendations › Ways to Improve Processes › Specific Encyclopedia Functions › Faster Model Copy and Delete

Faster Model Copy and Delete

You can noticeably improve the performance of the encyclopedia functions Model Copy and Model Delete by altering the DB2 locksize before and after the copy or delete. The purpose of the ALTER command is to change DB2 locksize from PAGE (ANY) to TABLESPACE. Locking at the tablespace level greatly reduces the number of DB2 locks and unlocks that must be performed by IRLM during execution of the function.

Changing the locksize to TABLESPACE means that the entire encyclopedia is locked during execution. Because of this, the change should probably not be considered for peak processing hours. Note also that you need DB2 authority to perform ALTER.