A fix is available
APAR status
Closed as program error.
Error description
A logical unload fails with completion code 8 and issues a message such as: INZU238E UNEXPECTED UNSUPPORTED SELECT UTILITY CANNOT SWITCH TO SQL PROCESSING REASON 0Xdfffc / 0X128913e8 where a SQL statement involves a concatenation of more than 5 graphic or vargraphic expressions. HPU 3.2 and HPU 4.1 only. PB11160
Local fix
Add the FIX(OPTEXP) subparameter toV UU030/ULOPTNS. Be aware that this will decrease the performance of some unload jobs.
Problem summary
**************************************************************** * USERS AFFECTED: * * All users of HPU. * * * **************************************************************** * PROBLEM DESCRIPTION: * * HPU 3.2 and HPU 4.1 only: * * * * A logical unload fails with completion * * code 8 and issues a message such as: * * * * INZU238E UNEXPECTED UNSUPPORTED SELECT * * * * UTILITY CANNOT SWITCH TO SQL PROCESSING * * * * REASON 0Xdfffc / 0X128913e8 * * * * where a the SQL statement involves a * * concatenation of more than 4 graphic * * ou vargraphic expressions. * * * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
Apply the PTF.
Temporary fix
Comments
APAR Information
APAR number
PM37581
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
410
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-04-21
Closed date
2011-06-01
Last modified date
2011-07-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK68368 UK68369
Modules/Macros
INZUTILK
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
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