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 UNLOAD PLUS for DB2 13.1.

DIRECT NO processing phases

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

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 processing that occurs during each phase:

DIRECT_NO_processing_phase.png

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


 

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