A fix is available
APAR status
Closed as program error.
Error description
A useless attempt to QUIESCE the table space to be unloaded is done where the following conditions are fullfilled: - the table space to be unload is not partitioned; - the QUIESCE of the table space has been requested; - the logical unload involves an unsupported SQL statement (i.e. the INZU063I message is issued); - the DB2 YES option is specified. If the QUIESCE cannot be performed, the unload fails with completion code 8 and issues the INZI164E message regardless of the value for VUU028/ULQSCEBH. PB11085
Local fix
Replace the DB2 YES by DB2 FORCE. Beware that, by doing so, further enhancement that would make the SQL statement supported will not be taken into account since DB2 FORCE forces the statement to be processed in SQL mode.
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 High Performance Unload. * **************************************************************** * PROBLEM DESCRIPTION: A useless attempt to QUIESCE the table * * space to be unloaded is done where the * * following conditions are fullfilled: * * - the table space to be unload is not * * partitioned; * * - the QUIESCE of the table space has * * been requested; * * - the logical unload involves an * * unsupported SQL statement (i.e. the * * INZU063I message is issued); * * - the DB2 YES option is specified. * * If the QUIESCE cannot be performed, * * the unload fails with completion code * * 8 and issues the INZI164E message * * regardless of the value for * * VUU028/ULQSCEBH. Local fix : replace * * the DB2 YES by DB2 FORCE. Be aware * * that, by doing so, further enhancement * * that would make the SQL statement * * supported will not be taken into * * account since DB2 FORCE forces the * * statement to be processed in SQL mode. * * PB 11085 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** The inzctrlh module was changed so that no QUIESCE is performed against the table space whenever the unload is processed in SQL mode.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PM34381
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
320
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-03-08
Closed date
2011-10-25
Last modified date
2011-12-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK73227 UK73228
Modules/Macros
INZADBSK INZUTILK
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":"320","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021