A fix is available
APAR status
Closed as program error.
Error description
An irrelevant encoding specification (UNICODE instead of EBCDIC) is specified in the LOAD statement generated (LOADDDN option) if the following conditions are fulfilled: - the unload is run in SQL mode - the DB2 subsystem is a non mixed one - the table to be unloaded belongs to : - a database UNICODE non SBCS (i.e. DBCS or MIXED) CCSID specified - a tablespace defined with EBCDIC encoding scheme the output encoding scheme ASIS is requested (either by specifying in the UNLOAD command or by default through the "Default scheme for UNLOAD TABLESPACE" (VUU023/UNLSCHEM) set to ASIS). PB47480
Local fix
Request an EBCDIC output encoding scheme.
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM DB2 High Performance Unload * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: An irrelevant encoding specification * * (UNICODE instead of EBCDIC) is * * specified in the LOAD statement * * generated (LOADDDN option) if the * * following conditions are fulfilled: * * - the unload is run in SQL mode * * - the DB2 subsystem is a non mixed one * * - the table to be unloaded belongs to : * * - a database UNICODE non SBCS * * (i.e. DBCS or MIXED) CCSID * * specified * * - a tablespace defined with EBCDIC * * encoding scheme the output * * encoding scheme ASIS is requested * * (either by specifying in the * * UNLOAD command or by default * * through the "Default scheme for * * UNLOAD TABLESPACE" * * (VUU023/UNLSCHEM) set to ASIS). * * pb 47480 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** The inzqryv8 and infotel modules were changed.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PI73468
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
2016-12-08
Closed date
2017-01-10
Last modified date
2017-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
INZTPMEM
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":"4.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021