A fix is available
APAR status
Closed as new function.
Error description
In the CA OUTPUT FORMAT VARIABLE, all the null indicators (one byte for each nullable column to tell if the column contains a NULL value or not) are located all together at the beginning of the record, before all the columns. This is something that we cannot do in the HPU syntax, simply because the only possibility is to say that the null indicator is either just before or just after the column itself. This is possible with CA compatibility syntax but not with HPU "native" syntax. RFE70048 PB46928 RTC44162
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM DB2 High Performance Unload * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: In the CA OUTPUT FORMAT VARIABLE, all * * the null indicators (one byte for each * * nullable column to tell if the column * * contains a NULL value or not) are * * located all together at the beginning * * of the record, before all the columns. * * This is something that we cannot do in * * the HPU syntax, simply because the * * only possibility is to say that the * * null indicator is either just before * * or just after the column itself. This * * is possible with CA compatibility * * syntax but not with HPU "native" * * syntax. * * pb46928 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** N/A (Enhancement)
Problem conclusion
Temporary fix
Comments
APPLY the PTF.
APAR Information
APAR number
PI90985
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
430
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-12-01
Closed date
2017-12-29
Last modified date
2018-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
PI90986 UI52952
Modules/Macros
INZ$$PRM INZTVAR INZUTILK INZUTILX
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
R430 PSY UI52952
UP18/01/06 P F801
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