A fix is available
APAR status
Closed as program error.
Error description
The HPU for z/OS unload stops with completion code 8 and issues INZI174E after installing DB2 APAR PM23243. DB2 APAR PM23243 changed the behavior of the setting of the MODE in the DB2 command, DISPLAY GROUP, which HPU uses. The change was result of PE of v10 compatability. - Prior to DB2 APAR PM23243, the DISPLAY GROUP would return MODE(N) if the DB2's were in new function mode. - After PM23243, if there is any subsystem in the group that is in a different version or mode, DISPLAY GROUP returns MODE(X). The "DISPLAY GROUP (DB2)" information center topic online at: http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp ?topic=/com.ibm.db29.doc.comref/db2z_cmd_displaygroup.htm - X indicates coexistence mode. In this case, at least one other member in the data sharing group has a different release or performed fallback from a higher DB2 release. To determine whether this fix is applicable, issue the DB2 DISPLAY GROUP command from the INZTVAR specified user with VUM028/DISPLUSR. * If there is a problem, correct the problem. * If the report comes out and MODE is X, as in the following sample, you will need this fix. -DISPLAY GROUP DSN7100I -DSB1 DSN7GCMD *** BEGIN DISPLAY OF GROUP(BJPEDB2G) CATALOG LEVEL(101) MODE(X ) PROTOCOL LEVEL(2) GROUP ATTACH NAME(DSB0) PB11088
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 High Performance Unload. * **************************************************************** * PROBLEM DESCRIPTION: The unload stops with completion code * * 8 and issues INZI174E due to DB2 APAR * * PM23243. This occurs when a the unload * * is run against a DB2 data sharing * * group in a MODE(X) configuration. * * PB 11088 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** odb2cmd module was changed to take the MODE(X) status into account.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PM34446
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
310
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-03-09
Closed date
2011-04-29
Last modified date
2011-08-23
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
R310 PSY UK67264
UP11/05/06 P F105
R320 PSY UK67265
UP11/05/06 P F105
R410 PSY UK67266
UP11/05/06 P F105
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":"310","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021