A fix is available
APAR status
Closed as program error.
Error description
Incorrect data can be unloaded if the following conditions are fulfilled: - the unload is a logical unload processed in native mode - the unloaded table has contiguous not nullable fixed char columns that must be unloaded in contiguous output fields (without any separator or delimiter as requested for a delimited format) - the unload requires CCSID conversion - the content of the not nullable contiguous columns converted to the output CCSID is shorter than the source content - the Optimization of CCSID conversions is not disabled (FIX(OPTCNV) is not specified for ULOPTNS) The corruption of data affects the groups of contiguous not nullable fix char columns. The last column of such a group is either not unloaded or truncated.
Local fix
Disable the Db2 HPU optimizations: - either at the step level by specifying the OPTIM_LEVEL 0 option from the GLOBAL option block - or for any step by specifying FIX(OPTCNV) in the value for the VUU030/ULOPTNS parmlib parameter
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 High Performance Unload * * for z/OS * **************************************************************** * PROBLEM DESCRIPTION: Incorrect data can be unloaded if the * * following conditions are fulfilled: * * - the unload is a logical unload * * processed in native mode * * - the unloaded table has contiguous not * * nullable fixed char columns that must * * be unloaded in contiguous output * * fields (without any separator or * * delimiter as requested for a * * delimited format) * * - the unload requires CCSID conversion * * - the content of the not nullable * * contiguous columns converted to the * * output CCSID is shorter than the * * source content * * - the Optimization of CCSID conversions * * is not disabled (FIX(OPTCNV) is not * * specified for ULOPTNS) * * * * The corruption of data affects the * * groups of contiguous not nullable fix * * char columns. The last column of such a * * group is either not unloaded or * * truncated. * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** Missing or truncated data in native mode involving CCSID conversion
Problem conclusion
Code has been changed to fix this problem
Temporary fix
Comments
APAR Information
APAR number
PH51691
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
510
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-01-03
Closed date
2023-02-13
Last modified date
2023-03-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI90507
Modules/Macros
INZCRXSM INZCRXSQ 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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 March 2023