A fix is available
APAR status
Closed as new function.
Error description
Add a new field QLLLID the QLLL macro to make it easier to identity the suspension type that it being traced as the 'longest waiter' .
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * Db2 13 for z/OS users of IFCID03. * **************************************************************** * PROBLEM DESCRIPTION: * * When using IFCID 3 section 14 QLLL, * * QLLLR or Part 1 contains overloaded * * data. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** In order to interpret the overloaded data in QLLLR, a new ID field or QLLLTYP is added which contains different types of longest wait times: QLLLAWLG CONSTANT(1); LOG WRITE I/O QLLLAWTI CONSTANT(2); Db2 - I/O QLLLAWTD CONSTANT(3); SYNCH DB READS WITH DASD CACHE HIT QLLLAWTG CONSTANT(4); SENDING OF IRLM NOTIFY MSG **************** GLOBAL CONTENTION FOR: ******************** QLLLAWTN CONSTANT(5); PAGESET/PARTITION P-LOCKS QLLLAWTO CONSTANT(6); PAGE P-LOCKS QLLLAWTQ CONSTANT(7); OTHER P-LOCKS QLLLAWTJ CONSTANT(8); PARENT L-LOCKS QLLLAWTK CONSTANT(9); CHILD L-LOCKS QLLLAWTM CONSTANT(10); OTHER L-LOCKS **************** END OF GLOBAL CONTENTIONS ***************** QLLLAWTL CONSTANT(11); DB2 - LOCK QLLLAWLH CONSTANT(12); DB2 - LATCH QLLLAWTR CONSTANT(13); DB2-READ I/O UNDER THREAD OTHER THAN THIS ONE QLLLAWTW CONSTANT(14); DB2-WRITE I/O UNDER THREAD OTHER THAN THIS ONE QLLLAWDR CONSTANT(15); DRAIN LOCK
Problem conclusion
Db2 has been modified to include QLLLTYP so that QLLLR can be accurately interpreted when retrieving IFCID0003 accounting trace records.
Temporary fix
Comments
APAR Information
APAR number
PH46371
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-01
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:
UI81752
Modules/Macros
DSNDQLLL DSNWVSR1
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RD10 PSY UI81752
UP22/08/10 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