Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Recover for Db2 13.1.

Defining sort work data sets


You can define index sort work data sets in the following ways:

  • Let the sort routine make the allocations dynamically by using installation defaults.
  • Specify SORTDEVT and SORTNUM and let the sort routine dynamically make the allocations.
  • Specify only SORTDEVT, and let BMCSORT determine the number of data sets.
  • Code the DD statements in the JCL for the ddnames as follows:
    • L001WK01 through L001WKnn for log sorts (non-parallel)
    • LxxxWKnn for log sorts

      xxx is the number of the log sort and is a number between 1 and the value that is specified for MAXLSORT. nn is the number of the work data set.

    • LOGOUnnn sort message files

      nnn is the number of the log sort and is a number between 1 and the value that is specified for MAXLSORT.

    • S001WK01 through S001WKnn for key sorts (non-parallel)
    • SxxxWK01 through SxxxWKnn

      xxx is a number between 1 and the value of the MAXKSORT option and nn is a number between 1 and the value specified for SORTNUM installation option or the OPTIONS SORTNUM parameter, for key sort work files for multiple index key sorts running in parallel in subtasks.



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*