A fix is available
APAR status
Closed as program error.
Error description
Thread Hung in Db2, Loop in CQCOXGC5 +CA4,+CC4 at PH13178
Local fix
OBJECTS(N) in the CQMPARMS file.
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM Db2 Query Monitor for z/OS * **************************************************************** * PROBLEM DESCRIPTION: Loop in CQCOXGC5+X'CA4', X'CB0'. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Loop in module CQCOXGC5 when a statement referenced numerous objects and a specific combination of DBID/OBID values were referenced.
Problem conclusion
Storage areas were increased to handle the large number of objects.
Temporary fix
Comments
APAR Information
APAR number
PH23489
Reported component name
COMMON COLLECTO
Reported component ID
5639OLC00
Reported release
110
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-03-20
Closed date
2020-04-21
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:
UI69131
Modules/Macros
CQCOXGBX CQCOXGC5
Fix information
Fixed component name
COMMON COLLECTO
Fixed component ID
5639OLC00
Applicable component levels
R110 PSY UI69131
UP20/04/23 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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
04 May 2020