When to use SORTKEYS NO
The SORTKEYS value determines when you can restart a LOAD job on a table space that has LOB columns.
- The default value for SORTKEYS is SORTKEYS 0. If you plan to load a table that has LOB columns using LOAD RESUME YES SHRLEVEL NONE, and you might need to restart the LOAD job with RESTART(CURRENT), you must specify SORTKEYS NO.
- The point at which you can restart LOAD REPLACE SHRLEVEL NONE on a table
that has no LOB columns depends on whether you specify SORTKEYS NO:
- If you specify SORTKEYS NO, you can restart with RESTART(CURRENT).
- If you do not specify SORTKEYS NO, you can restart only with RESTART(PHASE)