Fast/Unload overview

Fast/Unload is a utility which quickly unloads data from a Model 204 file to one or more sequential data sets. The Fast/Unload base product:

• Provides a data extraction facility that reads data from a Model 204 file.
• Allows the extracted data to be formatted using the UAI statement for file reorganization, when passed as the input of the LAI statement of Fast/Reload.
• Produces an output report containing the job log, job statistics, and any special conditions or errors that might have occurred during the run.

In addition, there are two optional enhancements to Fast/Unload's functionality:

• A compiler that converts a special data language, FUEL, to machine language. The generated machine language performs the output function and other general-purpose manipulation.
• A reporting-facility extension, FSTATS (Field Statistics), that provides field, procedure dictionary, and file Table statistics.

Fast/Unload can either be invoked directly as a standalone load module or from a SOUL program. When invoked as a standalone load module, Fast/Unload enqueues the data file in share mode unless explicitly requested otherwise. If the enqueue fails, the Fast/Unload terminates with an error condition code. Therefore, you must ensure that when Fast/Unload is run as a standalone load module, Model 204 does not have the file enqueued in exclusive mode.

Notes:

• As of Fast/Unload version 4.6, Fast/Unload must be running under z/OS or z/VM CMS.
• As of Fast/Unload version 4.7, Fast/Unload supports EAV (Extended Attribute Volume) disks for Model 204 files, and it supports FILEORG X'200' files.
• As of Model 204 version 7.6, Fast/Unload SOUL Interface (FUSI) requests invoke Fast/Unload code that is contained within the Model 204 load module. Model 204 no longer loads a separate load module for FUSI, and FUSI requests can (if licensed) take advantage of zIIP processing.
• As of Model 204 version 7.7, Fast/Unload is entirely linked with the Model 204 Online load module, and it adopts the Model 204 version number. If you run a Fast/Unload job with a reference to the Model 204 load library, the job can (if licensed) take advantage of zIIP processing.

Fast/Unload topics

The Fast/Unload documentation consists of the pages listed below. This list is also available in a "See also" section on each of the pages.

See the release notes for information about product changes and Model 204 feature support per Fast/Unload version.

Fast/Unload topic list

• Fast/Unload overview
• Fast/Unload invocation
• Fast/Unload program parameters
• Fast/Unload Extraction Language (FUEL)
• Fast/Unload standard #functions
• Fast/Unload BLOB/CLOB processing considerations
• Fast/Unload datetime processing considerations
• Fast/Unload DATESTAT analysis
• Fast/Unload job statistics
• Fast/Unload SOUL Interface
• Fast/Unload with an external sort package
• Fast/Unload with DBCS data
• Fast/Unload customer-written assembler #function packages
• Fast/Unload user exits or filters
• Fast/Unload with Model 204 file groups
• Fast/Unload with Model 204 fieldgroups
• Fast/Unload with the Sir2000 Field Migration Facility
• Fast/Unload floating point arithmetic and numeric conversion
• Fast/Unload program return codes
• Fast/Unload installation
• Fast/Unload customization of defaults
• Fast/Unload SMF record format
• Fast/Unload release notes
• Fast/Unload messages

Fast/Unload SOUL Interface

The Fast/Unload SOUL Interface (FUSI), purchased as a separate Fast/Unload option, allows one to invoke Fast/Unload using the FastUnload or FastUnloadTask method of the Recordset class, or using the $Funload function in a SOUL program.

With this approach, an application builds a set of records to be unloaded, using standard User Language statements; for example, you can reduce unload time by restricting the set of records using indexed Model 204 fields. The Fast/Unload load module runs in a subtask (or PST under CMS) of Model 204. Since the unload is from a Model 204 record set, the Fast/Unload SOUL Interface automatically provides the ability to unload data from a Model 204 group; standalone Fast/Unload provides that functionality by allowing multiple Model 204 file names on the OPEN statement.

The Fast/Unload SOUL Interface processing can be synchronous or asynchronous.

A system manager can cancel or examine Fast/Unload requests, and each user can perform the same functions on asynchronous requests that he or she initiated.

Fast/Unload HPO: zIIP exploitation

Fast/Unload HPO is M204 HPO (offloading Model 204 work to zIIP processors) extended to Fast/Unload.

Fast/Unload support for this specialty-engine processing is initially available in version 7.6 of Model 204 but only for FUSI users. This processing is available also to Fast/Unload (PGM=FUNLOAD) as of version 7.7 of Model 204.

Exploiting zIIPs in Fast/Unload requires:

1. z/OS, which is where the zIIP-accessing SRBs reside.
2. Customer authorization for the Fast/Unload HPO product, a Fast/Unload option.
3. Customer authorization for the M204 HPO product.
4. Appropriate setting of zIIP and Fast/Unload Model 204 system parameters.
   • If Fast/Unload is invoked from FUSI, several Model 204 parameters are of concern.
   • Otherwise (that is, PGM=FUNLOAD), the Model 204 parameters for zIIP exploitation are automatically set.

Even if Model 204 HPO is not purchased or in use, Fast/Unload HPO offers improved performance because it locates the Fast/Unload control blocks above the bar, taking advantage of the enhanced Model 204 V7.6 64-bit addressing and ATB storage.