SORT LIBRARY field

The value of the SORT LIBRARY field specifies the name of the data set where the DFSORT load module resides.

Acceptable values: valid data set name: see Valid data set name
Default: SYS1.SORTLIB
Update: cannot change during update
DSNZPxxx: none

If you use the Db2 Sort for z/OS product, Db2 does not use the value of this field. However, you should set this value to a valid data set name in case you need to use DFSORT as a fallback. Start of changeThe following guidance applies if Db2 Sort for z/OS is not installed.End of change

If you use DFSORT, and your load library is not in the link list, you can change the DSNUPROC JCL procedure in job DSNTIJMV.

If DFSORT is installed as your primary z/OS® sort product, you do not need to take any action to make DFSORT available to Db2. If multiple releases of DFSORT are installed, ensure that DFSORT R14 is found first in the system search order.

If DFSORT is not installed as your primary z/OS sort product, use one of the following methods to enable Db2 to use DFSORT:

  • Add the DFSORT SORTLPA library to the link pack area list; then add the DFSORT SICELINK library to the link list.
  • Add the DFSORT SICELINK library to the link list; then add the DFSORT SORTLPA library to the link list.
    Important: If any non-IBM primary sort product is installed in the link list, install DFSORT in the link list, in system search order, after the non-IBM primary sort product.
    Recommendation: If any non-IBM primary sort product is installed in the link pack area, add the DFSORT libraries to the link list.
  • Add the DFSORT SICELINK library to the JOBLIB statement; then add the DFSORT SORTLPA library to the JOBLIB statement.
  • Add the DFSORT SICELINK library to the STEPLIB DD statement; then add the DFSORT SORTLPA library to the STEPLIB DD statement.
  • Add the DFSORT modules to a private library that is equivalent to one of the above configurations.
    Important: If your non-IBM primary sort product is run from a private library, you must use DFSORT in the same way.

If you install DFSORT in the link pack area or link library, you must install it after you install the non-IBM primary sort product.

Db2 uses only the SORT and MERGE functions in DFSORT. If you want to use DFSORT for any other uses outside of this limited Db2 support, you must separately order and license DFSORT.