A fix is available
APAR status
Closed as program error.
Error description
Incorrect output is generated involving a table having a column defined with a field procedure (FIELDPROC clause). This occurs whenever the field procedure returns an error. For the rows in error, the content of column associated to the field procedure is evaluated as binary zeroes leading to incorrect field in the output data. For a physical unload (UNLDDN), the output field for the column with FIELDPROC contains binary zeroes. For a logical unload (SELECT and OUTDDN), the output field content for the expression involving the column with FIELDPROC is wrong (it contains either binary zeroes if the expression is the column itself of the result of the expression evaluated as if the content of the column was binary zeroes). PB11927
Local fix
run the unload in SQL mode by using the HPU DB2 FORCE option.
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 High Performance Unload. * **************************************************************** * PROBLEM DESCRIPTION: Unlike UNLOAD PLUS, for an unload * * command specifying the INLINE * * Incorrect output is generated * * involving a table having a column * * defined with a field procedure * * (FIELDPROC clause). This occurs * * whenever the field procedure returns * * an error. For the rows in error, * * the content of column associated to * * the field procedure is evaluated as * * binary zeroes leading to incorrect * * field in the output data. * * For a physical unload (UNLDDN), the * * output field for the column with * * FIELDPROC contains binary zeroes. * * For a logical unload (SELECT and * * OUTDDN), the output field content for * * the expression involving the column * * with FIELDPROC is wrong (it contains * * either binary zeroes if the expression * * is the column itself of the result of * * the expression evaluated as if the * * content of the column was binary * * zeroes). * * PB 11927 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** The udbspmfl module was fixed.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PM88423
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
2013-05-03
Closed date
2013-07-19
Last modified date
2013-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
INZ$$PRM INZRSAVE
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