IBM DB2 Database Manager Settings

The Upgrade Setting column in the following table provides guidelines for setting configuration parameters specifically to optimize upgrade performance. Set these parameters for each IBM DB2 instance.

Parameter Explanation Upgrade Setting

Parameter	Explanation	Upgrade Setting
`SHEAPTHRES`	Sort heap threshold (4 KB) If you reset `SHEAPTHRES` or `SORTHEAP`, then rebinding the instance is recommended.	Double the value allocated for `SORTHEAP`. See the following table.

SHEAPTHRES

Sort heap threshold (4 KB)

If you reset SHEAPTHRES or SORTHEAP, then rebinding the instance is recommended.

Double the value allocated for SORTHEAP. See the following table.