A fix is available
APAR status
Closed as program error.
Error description
The QUIESCE utility launched by Db2 HPU terminates n error with REASON=X'0913' when the following conditions are fulfilled : - the user switch method is RACF (i.e. the VUU030/ULOPTNS parmlib parameter contains USER_SWITCH_METHOD(RACF)) - the VUM031/QUITSUSR parmlib parameter is set to a specific user - the processing of the UNLOAD statement requires at least two QUIESCE utility invocations - an ORDER clause is specified and its processing triggers the INDEXSCAN feature
Local fix
Disable the INDEXSCAN feature by adding the INDEXSCAN NO option to the UNLOAD statement or remove the USER_SWITCH_METHOD(RACF) from the value for VUU030/ULOPTNS and optionally add USER_SWITCH_METHOD(AS) to this value.
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 High Performance Unload * * for z/OS * **************************************************************** * PROBLEM DESCRIPTION: The QUIESCE utility launched by Db2 HPU * * terminates in error with REASON=X'0913' * * when the following conditions are * * fulfilled : * * - the user switch method is RACF (i.e. * * the VUU030/ULOPTNS parmlib parameter * * contains USER_SWITCH_METHOD(RACF)) * * - the VUM031/QUITSUSR parmlib parameter * * is set to a specific user * * - the processing of the UNLOAD * * statement requires at least two QUIESCE * * utility invocations * * - an ORDER clause is specified and its * * processing triggers the INDEXSCAN * * feature * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** QUIESCE fails with REASON=X'0913'
Problem conclusion
Code has been changed to fix this problem
Temporary fix
Comments
APAR Information
APAR number
PH23963
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
510
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-04-01
Closed date
2020-04-15
Last modified date
2020-05-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
INZ$$PRM INZCHECK INZSGEN INZTDSC INZTPMEM INZTVAR INZUTILK
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
R510 PSY UI69029
UP20/04/22 P F004
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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021