A fix is available
APAR status
Closed as new function.
Error description
DB2 HPU allocates the data set containing the unloaded data (OUTDDN) of a logical unload with RECFM=VB while RECFM=FB is expected as the following set of conditions are fullfilled: - HPU APAR/PTF PI45632/UI30118 is applied - ULOPTNS (VUU030) specifies FMT_VAR_FB_IF_FIXED - the unload command specifies FORMAT VARIABLE END - the last column (i.e. the right most one) in the involved SELECT statement has a fixed length data type(which implies that the unloaded data of the unloaded record has a fixed length) PB12857
Local fix
Instead of FORMAT VARIABLE request FORMAT USER () with OPTIONS LENGTH MAX.
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 High Performance Unload. * **************************************************************** * PROBLEM DESCRIPTION: HPU allocates the data set containing * * the unloaded data (OUTDDN) of a * * logical unload with RECFM=VB while * * RECFM=FB is expected as the following * * set of conditions are fullfilled: * * - PI45632 is applied * * - ULOPTNS (VUU030) specifies * * FMT_VAR_FB_IF_FIXED * * - the unload command specifies FORMAT * * VARIABLE END * * - the last column (i.e. the right most * * one) in the involved SELECT statement * * has a fixed length data type(which * * implies that the unloaded data of the * * unloaded record has a fixed length) * * PB12857 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** The inzmain, inztoken, inzrunh and inzpabf modules were changed.
Problem conclusion
Temporary fix
Comments
APPLY the PTF.
APAR Information
APAR number
PI49040
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
430
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-09-18
Closed date
2015-10-08
Last modified date
2015-11-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI31881
Modules/Macros
INZ$$PRM INZUTILK
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
R430 PSY UI31881
UP15/10/16 P F510
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":"4.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021