New Features

The following new product features and enhancements to existing features are now available in Version 20.0 of CA Fast Unload.
cafudb220
The following new product features and enhancements to existing features are now available in Version 20.0 of
CA Fast Unload® for DB2 for z/OS
(CA Fast Unload):
For a list of enhancements for all the
CA Database Management Solutions for DB2 for z/OS
, see New Features on the
CA Database Management Solutions for DB2 for z/OS
product documentation page. To request product enhancements, contact a product manager or post your request in the "Ideas" section of the Broadcom Mainframe Community.
Be sure to download all available maintenance to ensure availability of all features and fixes. Incremental updates cannot be installed selectively. Later increments have dependencies on earlier increments. For a list of available PTFs, access the Maintenance Grid (login required) on
Broadcom Support
Online. We recommend use of the CA SMP/E Internet Service Retrieval service to download maintenance and to keep current with all updates.
DBM 20 IR 8 is the last incremental update for Version 20.0. New features and fixes are no longer bundled in incremental PTFs. Instead, we have transitioned to a continuous delivery release model that provides individual PTFs for new product features and product fixes. For more information, see Transition to Continuous Delivery.
zIIP Unloads from LOB Columns and with ORDER BY (LU00887)
CA Fast Unload® for DB2 for z/OS
now supports the use of the IBM System z Integrated Information Processor (zIIP) when you unload data from a LOB column or with an ORDER BY clause. zIIP support is provided when you unload LOB data with INPUT-FORMAT TABLE or order by a specified column. Offloading zIIP-eligible workloads to zIIP processors can reduce the processing load on your general CPUs.
The IO-BUFFERS keyword is deprecated as part of this feature and should no longer be used. You do not need to modify your JCL to remove the IO-BUFFERS keyword. The keyword is ignored and does not generate an error.
zIIP functionality is enabled by default. Use the zIIP keyword in the SYSIN DD or in
hlq
.CDBAPARM(PFU) to control zIIP processing.
More information:
zIIP Support for Unloads from Versioned Tables (LU00216)
CA Fast Unload® for DB2 for z/OS
now supports the use of the IBM System z Integrated Information Processor (zIIP) when you unload data from versioned tables. Previously, zIIP support was not available for unloads from rows in multiple tablespace versions. Now, zIIP support is provided for versioned tables. Offloading zIIP-eligible workloads to zIIP processors can reduce the processing load on your general CPUs.
zIIP functionality is enabled by default. Use the zIIP keyword in the SYSIN DD or in
hlq
.CDBAPARM(PFU) to control zIIP processing.
More information:
zIIP Support for Unloads from Image Copies (SO16194)
CA Fast Unload® for DB2 for z/OS
now supports the use of the IBM System z Integrated Information Processor (zIIP) when you unload data from image copies. Previously, zIIP support was only available for INPUT-FORMAT TABLE. Now, zIIP support is provided for all INPUT-FORMAT values. Offloading zIIP-eligible workloads to zIIP processors can reduce the processing load on your general CPUs.
zIIP functionality is enabled by default. Use the zIIP keyword in the SYSIN DD or in
hlq
.CDBAPARM(PFU) to control zIIP processing.
An unload from an image copy can be offloaded to zIIP processors when you specify ZIIP YES and can potentially increase elapsed time. The COPY-BUFFERS keyword can help tune elapsed time performance when INPUT-FORMAT IMAGECOPY or DSN1COPY is specified.
More information:
Support for Unload from Remote Db2 (LUW) RDBMS (SO14381)
You can now unload data from a Db2 (LUW) Relational Database Management System (RDBMS) under Distributed Relational Database Architecture (DRDA). The DRDA protocol supports seamless integration of distributed relational DBMS systems.
You must configure CA Fast Unload to unload data from a remote Db2 (LUW) RDBMS by defining the remote system in the communications database (CDB) and binding the product packages using the DRDA protocol.
Support for Huffman Compression (SO14029)
CA Fast Unload® for DB2 for z/OS
supports Huffman data compression. You can now unload from tables and image copies that contain Huffman encoded objects. Huffman data compression is introduced with IBM Db2 for z/OS function level V12R1M504.
Support for TEMPLATE PATH option to Allocate Output Data Sets (SO13764)
CA Fast Unload now supports the use of the TEMPLATE control statement PATH option to dynamically allocate the SYSREC, SYSDDL, and SYSCTL data sets without static JCL DD statements. You can take advantage of a z/OS UNIX System Services (USS) pipe for improved performance by defining a USS file PATH name and associated parameters in the TEMPLATE control statement.
More information:
Support for New Db2 12 UNLOAD Privilege (SO12106)
CA Fast Unload is now compatible with the new UNLOAD privilege that is introduced in Db2 12 function level V12R1M500.
Previously, only SELECT authority (explicit or a higher-level authorization such as SYSADM) on the tables was required to process an unload. Now, you must specify AUTH_COMPATIBILITY=SELECT_FOR_UNLOAD in DSNZPARM, or grant the UNLOAD privilege (or a higher-level authorization) on the tables to unload. The UNLOAD privilege can be granted on a table, but not an auxiliary table or table view.
Customers using Db2 12 function level V12R1M500 (or higher) should specify AUTH_COMPATIBILITY=SELECT_FOR_UNLOAD in DSNZPARM, or grant users the UNLOAD privilege on the appropriate tables to maintain users ability to unload.
More information:
Support for New Format of DSVOLSER Column in SYSCOPY (SO10626)
CA Fast Unload has been enhanced to support the new format of the DSVOLSER column in the SYSIBM.SYSCOPY catalog table. IBM Db2 12 has introduced changes to the DSVOLSER column for cataloged sequential image copies. You can now unload from an image copy of a tablespace that uses the new DSVOLSER column format.
More information:
Enhanced support for Unload from Archive Tables (SO10174)
You can now unload archive tables from Db2 tablespaces and image copies when you specify SQL-ACCESS NONE or EXTENSION. Previously, you could only unload an archive table from a tablespace by specifying INPUT-FORMAT TABLE and SQL-ACCESS ONLY. Now, you can unload archive tables from Db2 tablespaces and image copies with any INPUT-FORMAT and SQL-ACCESS method.
Support for Unload from PBR RPN (PBR2) Tablespaces (SO08861)
You can now unload from a tablespace or image copy that uses partition-by-range relative page numbering (PBR RPN). IBM Db2 12 introduced PBR RPN (known as PBR2) to separate the partition number from the page number for greater flexibility in partition processing. You can now specify SQL-ACCESS NONE to use PBR RPN with CA Fast Unload.
More information:
Support for Unload from Catalog Image Copy (SO08352)
You can now unload from a full image copy of a catalog tablespace when you specify INPUT-FORMAT IMAGECOPY. Previously, processing stopped and an error message was received. Currently, processing continues and SQL-ACCESS NONE is enforced. If you select SQL-ACCESS ONLY or EXTENSION, a warning is received that SQL-ACCESS is not possible for INPUT-FORMAT IMAGECOPY.
You now have greater flexibility in unloading from a full image copy of a catalog tablespace or user tablespace.
Ability to Specify Same Value for COMMA and QUOTE (SO08112)
You can now select the same value for COMMA and QUOTE, or specify a blank for COMMA and QUOTE NONE, when using OUTPUT-FORMAT COMMA-DELIMITED. Now, if you select the same value for COMMA and QUOTE, or specify COMMA ' ' and QUOTE NONE, processing continues and the following informational message is received.
PFU0328I - COMMA and QUOTE values are the same - CSV output could produce unpredictable results if used as LOAD input.
Previously, processing stopped and an error message was received. You now have greater flexibility in specifying your output when using OUTPUT-FORMAT COMMA-DELIMITED.
Using the same value for COMMA and QUOTE (or specifying COMMA ' ' and QUOTE NONE) may unload the data in an incompatible format for a load utility.
Support for Common Table Expressions (WITH clause)
You can now use common table expressions (a WITH clause) when you specify SQL-ACCESS ONLY or EXTENSION. Common table expressions are specified by a WITH clause that precedes the SELECT statement. Common table expressions define a result table for reference in any FROM clause of the fullselect. You can use a common table expression instead of a regular view and avoid the need for Db2 to access the catalog during statement preparation.
Ability to invoke LONG-CHAR from PFU Parmlib Member
You can now invoke the LONG-CHAR keyword from the PFU parmlib member.
The LONG-CHAR keyword allows data conversion from a variable-length character (VARCHAR) column longer than 255 bytes to a fixed-length character (CHAR) output field. You can use this keyword with the CHAR keyword to specify a fixed-length character output field longer than 255 bytes. This enhancement gives you the ability to specify LONG-CHAR in the PFU parmlib member without the need to modify existing jobs.
Support for Free-Form Load Control Statements
You can now generate free-form load control statements to reload data using
CA Fast Load for DB2 for z/OS
or Db2 LOAD. Use the LOAD-CONTROL keyword to generate load control statements, and specify what format to use. You can add any load control statement that is supported by your load utility in free form. This enhancement helps simplify the process and saves time when reloading data.
Db2 Version Support
IBM Db2 12 for z/OS function levels V12R1M100, V12R1M500, and V12R1M
nnn
are now supported.
Version 20.0 of CA Fast Unload supports the IBM Db2 12 Continuous Delivery Model, which introduces new features in the maintenance stream for faster adoption. Customers who are moving to Db2 12 should upgrade to Version 20.0. In Version 19.0,
only
V12R1M100 for migration from Db2 11 and function level V12R1M500 are supported for Db2 12.
More information:
Syntax of Field Names Now Enforced in INTO Statements
Hyphens and periods in field names are not allowed in INTO statement syntax. This restriction is now enforced in CA Fast Unload job syntax, and helps ensure that the records can be unloaded without error. If you specify a field name with a hyphen or period, the job ends and you receive an error.
Field names must begin with an uppercase letter (A-Z), and contain only:
  • Alphabetic characters (A-Z, a-z)
  • National characters ($, #, @)
  • Numeric characters (0-9)
  • Underscores (_)
If an invalid character is used in the field name, the following error messages are issued:
PFU0011E - SYNTAX ERROR ON OR NEAR LOCATION nnn PFU0078E - FORMAT ERROR IN SPECIFICATION OF COLUMN DATA TYPE
We recommend that you review your existing jobs for the use of hyphens or periods in field names and update as needed.
New LONG-CHAR Keyword
The LONG-CHAR keyword converts data from a variable-length character string longer than 255 bytes to a fixed-length character string when unloading it. Use this keyword when you want to convert data in a long variable-length character string to a specified fixed-length character string that you specify.
More information:
Control the RECFM Value for SYSREC Data Sets
You can now control the RECFM value when using ONE-SYSREC to unload multiple tables into a single fixed-length, blocked (FB) data set. Typically, the record block format of the output data set is controlled by the OUTPUT-FORMAT value or ONE-SYSREC. If you specify OUTPUT-FORMAT COMMA-DELIMITED or VARIABLE, the SYSREC data set is variable-length, blocked (VB). If you specify ONE-SYSREC without a RECFM value, the SYSREC data set is always VB. The RECFM keyword (specified with ONE-SYSREC) overrides the OUTPUT-FORMAT value to control the record block format of the SYSREC data set. This enhancement lets you use the output from CA Fast Unload as the input for third-party applications that have specific block format requirements.
This functionality is enabled through the RECFM keyword.
This enhancement also introduces new processing. You can now use the LRECL-USER keyword when ONE-SYSREC is specified with multiple SELECT statements. (Previously, LRECL-USER was always ignored in this situation.) To use LRECL-USER with ONE-SYSREC, specify RECFM FB.
Enhanced SHRLEVEL CHANGE Support
You can now use CA Fast Unload and specify SHRLEVEL CHANGE without Db2 authorization to quiesce or display tablespaces. The only exception is SHRLEVEL CHANGE, BP-LOOKUP which requires additional authorizations to invoke Db2 buffer pool LOOKUP. Previously, SHRLEVEL CHANGE required Db2 authorization to display tablespaces. Typically, the SYSADM ID has Db2 authorization to quiesce and display tablespaces. This enhancement gives you greater flexibility in selecting the users who can run jobs based on your need for data integrity. For example, you can now use CA Fast Unload to specify SHRLEVEL CHANGE with a group or surrogate ID that does not have authorization to display tablespaces.
New NULL-FILL Keyword
A new NULL-FILL keyword is now provided. This keyword specifies the EBCDIC character or hexadecimal value that is used to fill in null fields in the output record. The character or value that you specify here overrides the default character or value that is used by OUTPUT-FORMAT VARIABLE and OUTPUT-FORMAT DSNTIAUL.
New QUOTE-EMBED-SINGLE Keyword
A new QUOTE-EMBED-SINGLE keyword is now provided. This keyword specifies whether to suppress the duplication of the QUOTE value when unloading character-type data in a comma-delimited format. The QUOTE keyword specifies the character to use as the field delimiter in the output file. This character is used to enclose character-type output fields such as CHAR and VARCHAR. If the same character is encountered within the column data, it is also enclosed in quotes to distinguish it from the quotes that enclose the output field. This duplication of the QUOTE value is the default behavior because load utilities can distinguish between the enclosing quotes and the embedded quotes. However, some third-party applications cannot process the embedded QUOTE value. In this case, the new keyword lets you suppress the duplication of the embedded quote value.
Use SYSREC01 and SYSCTL01 with ONE-SYSREC
You can now include a suffix of "01" in your SYSREC and SYSCTL ddnames when ONE-SYSREC is specified. Previously, you were required to name these data sets SYSREC and SYSCTL with no suffix. This enhancement gives you greater flexibility when enforcing site standards; for example, when a common PROC applies SYSREC
xx
or SYSCTL
xx
to all your unload jobs.
  • This enhancement also applies to any alternate SYSREC ddname that you specify through the UNLDDN keyword. For example, you could write the output to a data set named MYREC or MYREC01. Similarly, this enhancement also applies to any alternate SYSCTL ddname that you specify through the CTLDDN keyword.
  • Suffixes must still be omitted from the SYSLOD, and SYSDDL DD statements when ONE-SYSREC is used.