Running Export in batch

If you want to export large Db2® tables, you can perform the export in a batch job.

If you select the Batch execution option on the Export Options (1 of 3) panel, the Export utility builds the necessary JCL to perform the export function in a batch job. The generated JCL is displayed using the ISPF editor, where you can review the JCL and submit the job for batch processing. If you select the Batch, using Db2® utility option, the JCL is set up for the Db2® UNLOAD utility, and displayed for review before submission.

If you have one or more data sets that contain the template that describes the record structure of your input data, you can specify the data set details (or TSO ALLOC statement) in the generated JCL with the keywords TINPUT or TCIN.

Similarly, if you have one or more data sets that contain the template that describes the record structure of your output data, you can specify the data set details (or TSO ALLOC statement) in the generated JCL with the keywords TOUTPUT or TCOUT.

If the export data set does not already exist, you are prompted to create it. However, you can defer the creation of the export data set until batch job execution time by selecting the Batch data set creation option. If you select this option, FM/Db2 creates a new sequential export data set in the JCL for the batch job.

Related references