A fix is available
APAR status
Closed as new function.
Error description
Add support to also provide longest waiter/suspension activity (QLLL information) when accounting rollup (ACCUMACC >1 ) is active for DDF and RRS threads.
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * Db2z 13 for z/OS users of IFCID 3. * **************************************************************** * PROBLEM DESCRIPTION: * * When using IFCID 3 section 14 QLLL, * * rollup records will only return the * * longest wait time for the current * * thread. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** In order to properly record the longest wait times in a rollup interval, it is necessary to compare the wait times for each accumulating interval within the accumac count or the multiple threads that are being rolled up during query parallelism and autonomous transactions.
Problem conclusion
Db2 has been modified to include the rollup intervals for DDF/RRSAF, Query Parallelism, and Autonomous Transactions in IFCID 3 section 14 (QLLL).
Temporary fix
Comments
APAR Information
APAR number
PH46372
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
D10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-05-12
Closed date
2022-08-22
Last modified date
2022-09-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI82060
Modules/Macros
DSNXTAD DSNB1TAD DSNWVCSP DSNWVAPR DSNWVZCK DSNTXSTB DSNWAAPI DSNWVZIT DSNWVCST DSNWAFRR DSNWACDF DSNWVZSA DSNX8SMF DSNWZDG2 DSNTLRAC DSNWARDS DSNDQLLL DSNWVSR1 DSNTXACT DSNWVSMT DSNWVZSS DSNWAACT DSNWVZPS
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RD10 PSY UI82060
UP22/08/26 P F208
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":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 September 2022