File Sort Utility DD statements


Several DD statements can be used with the File Sort Utility.

The following table describes the DD statements:

Statement

Description

IMSACB DD

(Required) Defines the library containing the DMB for the database. This DD statement is required unless the MODSTAT DD, MODSTAT2 DD, or OLCSTAT DD online IMS statement is provided.

MODSTAT / MODSTAT2

(Optional) Used to identify the active online IMS ACB data set (IMSACBA or IMSACBB). Dynamic allocation can be used for these DD statements.

When one of these DD statements is present, the MODSTAT data set is interrogated to determine whether IMSACBA or IMSACBB is the active library. If the IMSACBA or IMSACBB DD statement is not present in the JCL, the STEPLIB/LINKLIST are searched for a DFSMDA member.

If MODSTAT2 DD is present, the active MODSTAT data set is determined prior to ACBLIB selection. The MODSTAT2 data set is interrogated to determine whether IMSACBA or IMSACBB is the active library. If the IMSACBA or IMSACBB DD statement is not present in the JCL, the STEPLIB/LINKLIST are searched for a DFSMDA member.

If both OLCSTAT and MODSTAT DD statements are present, then OLCSTAT will be used and MODSTAT will be ignored.

OLC STAT DD

(Optional) Used to identify the active online IMS ACB data set (IMSACBA or IMSACBB) in an IMS global online change environment. Dynamic allocation can be used for this DD statement.

When this DD statement is present, the OLCSTAT data set is interrogated to determine whether IMSACBA or IMSACBB is the active library. If the IMSACBA or IMSACBB DD statement is not present in the JCL, the STEPLIB/LNKLIST are searched for a DFSMDA member.

If both OLCSTAT and MODSTAT DD statements are present, then OLCSTAT will be used and MODSTAT will be ignored.

SORTIN DD

(Required) Defines the input data sets that contains the records that are to be processed by the PFPSORT command. The data set can be created in any of the following ways:

  • Fast Path Reorg/EP UNLOAD command with any value specified on the FORMAT keyword
  • IBM Fast Path Basic Tools for OS/390 DEDB Unload Utility with any format specified for unload file
  • Fast Path Reorg/EP FABEUR6 Unload File Create Utility with any value specified on the FORMAT control statement
  • Fast Path Analyzer/EP or BMC AMI Fast Path Online Analyzer for IMS EXTRACT command with the EXTRACT_FORMAT=HDUNLOAD value specified

The PFPSORT command can accept only one unload file as input. If you want to sort more than one unload file in one step, must concatenate the files on the SORTIN DD statement. If the SORTIN DD statement is omitted from the JCL, the File Sort Utility uses the value that you specify on the INPUT_DSN_MASK keyword to allocate the data set name.

SORTOUT DD

(Required) Defines the output data set to contain the sorted records. The output is written in HD Unload format. You can use this data set as input to any of the following:

  • Fast Path Reorg/EP RELOAD command set
  • Fast Path Reorg/EP FABEUR7 Read Unloaded Database Utility
  • Any IMS full-function utility

If the SORTOUT DD statement is omitted from the JCL, the File Sort Utility uses the value that you specify on the OUTPUT_DSN_MASK keyword to allocate the data set name.

SORTWKnn DD

(Optional) Defines the sort work files that your installation’s sort/merge utility uses to sort the records. For more information, see the documentation for your installation’s sort/merge utility.

SORTMSG DD

(Optional) Defines the data set where any error or warning messages will be written.


 

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