A fix is available
APAR status
Closed as new function.
Error description
HPU v4.1 now supports the WITH UR clause. See HPU v4.1 Users Guide for details on the new WITH UR clause support. Unload statements specifying DB2 YES and WITH UR are processed in native mode, i.e. outside of DB2, while they used to be processed in SQL mode in previous releases. In some specific cases, this might lead to undesired changes in the existing unload steps such as: - the generated LOAD statement take the identity columns into account (field names for identity columns are different and IGNOREFIELDS option is added) - performance changes - string constants are handled as CHAR instead of VARCHAR where FORMAT USER is requested. This PTF adds support for a new value (BY_SQL_ONLY(WITH UR)) for VUU030/ULOPTNS to force SQL mode for processing of the statements with a "WITH UR" clause. PB11091
Local fix
To get the same outpout that was produced by previous releases of HPU. Replace the DB2 YES option by DB2 FORCE where the unload statement specifies the WITH UR clause.
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 High Performance Unload. * **************************************************************** * PROBLEM DESCRIPTION: From DB2 HPU 4.1 release, unload * * statements specifying DB2 YES and WITH * * UR are processed in native mode, * * i.e. outside of DB2, while they used * * to be processed in SQL mode in * * previous releases. * * In some specific cases, this might * * lead to undesired changes in the * * existing unload steps such as: * * - the generated LOAD statement take * * the identity columns into account * * (field names for identity columns * * are different and IGNOREFIELDS * * option is added) * * - performance changes * * - string constants are handled as CHAR * * instead of VARCHAR where FORMAT USER * * is requested. * * PB 11091 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** inzmain and inzhyacc modules were changed to allow the WITH UR clause to be considered as unsupported and thus processed in SQL mode.
Problem conclusion
Temporary fix
Comments
APPLY the PTF.
APAR Information
APAR number
PM34564
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
410
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-03-10
Closed date
2011-04-11
Last modified date
2011-05-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
INZUTILK
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
R410 PSY UK66639
UP11/04/19 P F104
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAUUV","label":"IBM Db2 High Performance Unload for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021