SORTCHK =YES/NO
Related topics
The SORTCHK parameter determines whether products that use AMISORT apply checksum verification during sort processing. When enabled, Db2 computes a checksum for data before sorting and validates it upon retrieval from sort work data sets. This makes sure that the records are not silently corrupted between write and read operations.
| Value | Description |
| YES | Enables checksum verification for AMISORT. Detects data corruption in sort work data sets before corrupted data is loaded or reorganized into Db2 objects, and is recommended for most environments. A small CPU overhead applies. |
| NO | Disables checksum verification for AMISORT. Consider this only in performance-sensitive batch windows, stable and trusted environments, or for non-critical or easily rebuildable data where the performance trade-off is acceptable. |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*