DIRECT NO processing phases

This topic describes the processing phases of UNLOAD PLUS and their primary functions when you use DIRECT NO.

Related topics

Data sets for DIRECT NO

Understanding UNLOAD PLUS execution modes

Number of DB2 threads that UNLOAD PLUS uses

Object-status-with-DIRECT-NO

DIRECT NO restrictions

Data translation

How-UNLOAD-PLUS-works


Phase

Description

UTILINIT

During this phase, UNLOAD PLUS completes the following processes:

  • Initializes the job
  • Reads, parses, and verifies the UNLOAD command
  • Extracts Db2 SQL SELECT statements
  • Prepares the SELECT statements
  • Processes object definition information related to the result table
  • Dynamically allocates output data sets

UNLOAD

During this phase, UNLOAD PLUS completes the following processes:

  • Processes the SELECT statement
  • Uses Db2 dynamic SQL programming techniques to read the data

While fetching each row or rowset, UNLOAD PLUS converts the data to its final output format and writes to the output data sets (SYSRECnn, SYSREDnn, and referenced files).

UTILTERM

During this phase, UNLOAD PLUS completes the following processes:

  • Performs the termination processing for the utility
  • Creates the control statement data set (SYSCNTLn)
  • Optionally updates the BMCHIST table in the UNLOAD PLUS database

The following figure displays the processing that occurs during each phase:

DIRECT_NO_processing_phase.png

 

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