A fix is available
APAR status
Closed as program error.
Error description
When the LOADDDN option is specified and the target table name cannot be determined, not fully compliant LOAD control cards are generated where the INTO TABLE clause specifies a table name to be changed before use. This situation is reported by one of the INZU211I/INZU211W/INZU211E messages. In DB2 HPU versions 4.2, the unknown table name in the INTO CLAUSE was replaced by "?????.?". From DB2 HPU version 4.3 the unknown table name is replaced by the "?.???? " substitution string which contains an extra blank. As a consequence, the required replacement to be done before using the LOAD control cards unexpectedly changes as well which can cause failures of the automated post-processing of the LOAD control cards. PB53575 PB 53575
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM Db2 High Performance Unload * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: When the LOADDDN option is specified * * and the target table name cannot be * * determined, not fully compliant LOAD * * control cards are generated where the * * INTO TABLE clause specifies a table * * name to be changed before use. This * * situation is reported by one of the * * INZU211I/INZU211W/INZU211E messages. * * In DB2 HPU versions 4.2, the unknown * * table name in the INTO CLAUSE was * * replaced by "????????.????????". From * * DB2 HPU version 4.3 the unknown table * * name is replaced by the * * "????????.???????? " substitution * * string which contains an extra blank. * * As a consequence, the required * * replacement to be done before using * * the LOAD control cards unexpectedly * * changes as well which can cause * * failures of the automated * * post-processing of the LOAD control * * cards. * * pb53575 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** The inzrload module was changed.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PH00823
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
430
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-07-23
Closed date
2018-08-10
Last modified date
2018-10-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI57807
Modules/Macros
INZUTILK
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
R430 PSY UI57807
UP18/09/05 P F809
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