A fix is available
APAR status
Closed as program error.
Error description
An unload completes without reporting any error but does not unload whole the expected data. This occurs when all the following conditions are fulfilled: - the unload is run in native mode - the data is unloaded from a VSAM dataset (either from the tablespace or from a FlashCopy dataset) - one of the VSAM datasets involved in the unload is affected by a physical I/O error - Db2 HPU reads the VSAM datasets without exploiting the zIIP processors (i.e. either ZIIP OFF applies or FIX(APAR_PH36904 [,VERBOSE]) is specified in VUU030/ULOPTNS or if some features or conditions, such as the indexscan, object with editproc/fieldproc/encryption and some use case involving FORMAT INTERNAL prevent the zIIP processors to be exploited)
Local fix
none but, if relevant, consider to enable the zIIP use so that any physical I/O error affecting the VSAM datasets is correctly reported by Db2 HPU.
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 High Performance Unload * * for z/OS * **************************************************************** * PROBLEM DESCRIPTION: An unload completes without reporting * * any error but does not unload whole the * * expected data. * * * * This occurs when all the following * * conditions are fulfilled: * * - the unload is run in native mode * * - the data is unloaded from a VSAM * * dataset (either from the tablespace * * or from a FlashCopy dataset) * * - one of the VSAM datasets involved in * * the unload is affected by a physical * * I/O error * * - Db2 HPU reads the VSAM datasets * * without exploiting the zIIP * * processors (i.e. either ZIIP OFF * * applies or * * FIX(APAR_PH36904 [,VERBOSE]) is * * specified in VUU030/ULOPTNS or if * * some features or conditions, such as * * the indexscan, object with * * editproc/fieldproc/encryption and * * some use case involving * * FORMAT INTERNAL prevent the zIIP * * processors to be exploited) * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** Incorrout in native mode but no error reported if VSAM physical error.
Problem conclusion
Code has been changed to fix this problem
Temporary fix
Comments
APAR Information
APAR number
PH44926
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
2022-03-16
Closed date
2022-04-20
Last modified date
2022-05-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI80220
Modules/Macros
INZUTILK
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
R510 PSY UI80220
UP22/04/28 P F204
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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"}]
Document Information
Modified date:
04 May 2022