Administrative and Operational Enhancements › Utility Enhancements › IDMSDBAN Sort Control

IDMSDBAN Sort Control

With Version 18.0, there is a new SYSIDMS DBAN_SORT_PASSES parameter that specifies the number of sorts to perform. The SYSIDMS parameter gives you control over the number of sorts IDMSDBAN uses when auditing index orphan chains. Adjusting this number may enable IDMSDBAN to detect more errors.

DBAN_SORT_PASSES=sort-passes

Specifies the number of sorts that IDMSDBAN uses when auditing index orphan chains.

Default: 1

The higher the number of sorts, the greater the number of errors that can be detected, if any exist. However, increasing the number of sorts also increases the overhead for auditing orphan chains, which can be significant when processing large indexes. Because most errors are detected with a single sort, the default of one is sufficient in most cases. You should increase the number of sorts beyond 1 only when you need to identify every error in an index.