A fix is available
APAR status
Closed as program error.
Error description
Unload generates error message INZI006E NO CONVERSION WAS AVAILABLE BETWEEN CCSID xxx AND CCSID yyy on HPU V410 only. Miscellaneous error may occur if the DB2 release is prior to V10 NFM including: - unexpected CSSID conversion is requested. In some cases, one of the CCSID is even invalid, thus leading the process to terminate with completion code 8 with message INZI006E NO CONVERSION WAS AVAILABLE BETWEEN CCSID xxx AND CCSID yyy. - attempt to read an non-existing LDS. - end with completion code 8 without any explaning message or S0C4 ABEND where the INTERNAL format is requested. PB11074
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 High Performance Unload. * **************************************************************** * PROBLEM DESCRIPTION: HPU 4.1 only: Miscellaneous errors * * might occur if the DB2 release is * * prior to V10 NFM. * * The known symptoms are: * * - unexpected CSSID conversion is * * requested. In some cases, one of the * * CCSID is even invalid, thus leading * * the process to terminate with * * completion code 8 with message * * INZI006E NO CONVERSION WAS AVAILABLE * * BETWEEN CCSID xxx AND CCSID yyy. * * - attempt to read a non-existing LDS. * * - end with completion code 8 without * * any explanation message or S0C4 ABEND * * where the INTERNAL format is requested. * * PB 11074 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** odb2x2 module was changed so to crrectly set values of the catlog tables numerical tables added from DB2 V910 on.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PM33244
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
410
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-02-21
Closed date
2011-04-11
Last modified date
2011-05-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
INZUTISK
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
R410 PSY UK66639
UP11/04/19 P F104
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":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021