Previous Topic: UsageNext Topic: Examples

Utility Statements › BUILD › JCL Considerations

JCL Considerations

When you submit a BUILD statement through the batch command facility, the JCL to execute the facility must include statements to define:

BUILD utility uses intermediate work files

Each step of the build process, except BUILD STEP4, produces intermediate work files to be used by the next step. If you run a complete BUILD without separating steps, data is sorted in the intermediate files between the steps automatically. If you run a stepped BUILD, you must run the intermediate sorts.

Note: When running a complete BUILD,SYS002 and SYS003 must point to the same intermediate file. If the database being processed is so large that the intermediate file must be a multi-volume file, it is required that all extents of the file be physically allocated prior to the initiation of the BUILD utility. If this cannot be done, then run a stepped BUILD. When running a stepped BUILD, SYS002 and SYS003 must point to different intermediate files. The data that is output in SYS003 by each step is input to the next step in SYS002.

The following table shows the output of the steps of the BUILD process:

Step

Output

Size

Step 1

SYS003

For each record:
(MAX SORT CONTROL KEY SIZE) + (MAX FOREIGN KEY SIZE) + 24

 

SYSPCH contains sort parameters

80 bytes

Step 2

SYS003

For each record:

(MAX SORT CONTROL KEY SIZE) + (MAX FOREIGN KEY SIZE) + 24

 

SYSPCH contains sort parameters

80 bytes

Step 3

SYS003

For each prefix:

56 bytes

 

SYSPCH contains sort parameters

80 bytes

Note: For more information about the generic JCL used to execute the batch command facility, see the chapter specific to your operating system.