APAR status
INTRAN
Error description
PTF UQ52040 has introduced new and modified fields, which were added to the Accounting report shown in the DB2 PM Batch User's Guide of Version 7. In the Class 3 Suspensions block shown on page 64 and on page 188, the field GLOBAL CONT. was renamed to GLOBAL CONTENTION. The description of this field was modified on page 191 as follows: GLOBAL CONTENTION The time spent waiting due to global lock contention in a data sharing environment, and the number of suspensions caused by global lock contention. This value is calculated only if accounting class 3 is active and DB2 is a member of a data sharing group. The Accounting Group Buffer Pool block shown on page 204 now looks as follows: GROUP BP0 AVERAGE TOTAL -------------------- -------- -------- GBP-DEPEND GETPAGES N/A N/A READ(XI)-DATA RETUR 0.00 0 READ(XI)-NO DATA RT 0.00 0 READ(NF)-DATA RETUR 0.00 0 READ(NF)-NO DATA RT 0.00 0 PREFETCH PAGES READ 0.00 0 CLEAN PAGES WRITTEN 0.00 0 CHANGED PAGES WRTN 0.00 0 UNREGISTER PAGE 0.00 0 ASYNCH GBP REQUESTS 0.00 0 EXPLICIT X-INVALID 0.00 0 WRITE TO SEC-GBP 0.00 0 ASYNCH SEC-GBP REQ 0.00 0 PG P-LOCK LOCK REQ 0.00 0 SPACE MAP PAGES 0.00 0 DATA PAGES 0.00 0 INDEX LEAF PAGES 0.00 0 PG P-LOCK UNLOCK REQ 0.00 0 PG P-LOCK LOCK SUSP 0.00 0 SPACE MAP PAGES 0.00 0 DATA PAGES 0.00 0 INDEX LEAF PAGES 0.00 The descriptions of the new fields were added on page 205, following the description of the ASYNCH SEC-GBP REQ field (note that the dot after REQ was removed): PG P-LOCK LOCK REQ The number of all page P-lock lock requests. SPACE MAP PAGES The number of page P-lock lock requests for space map pages. DATA PAGES The number of page P-lock lock requests for data pages. INDEX LEAF PAGES The number of page P-lock lock requests for index leaf pages. PG P-LOCK UNLOCK REQ The number of page P-lock unlock requests. PG P-LOCK LOCK SUSP The sum of all page P-lock lock suspensions. SPACE MAP PAGES The number of page P-lock lock suspensions for space map pages. DATA PAGES The number of page P-lock lock suspensions for data pages. INDEX LEAF PAGES The number of page P-lock lock suspensions for index leaf pages. The following two blocks are new. They were added to the accounting report on page 64 and are shown together with the appropriate field descriptions on page 191: GLOBAL CONTENTION L-LOCKS AVERAGE TIME AV.EVENT ------------------------------------ ------------ -------- L-LOCKS 0.000000 0.00 PARENT (DB,TS,TAB,PART) 0.000000 0.00 CHILD 0.000000 0.00 OTHER 0.000000 0.00 L-LOCKS The accumulated wait times due to global contention for all L-locks. The accumulated wait trace events processed for waits for global contention of all L-locks. PARENT (DB,TS,TAB,PART) The accumulated wait time due to global contention for parent L-locks. Parent L-locks are any of these L-lock types: database, tablespace, table, partition. CHILD The accumulated wait time due to global contention for child L-locks. Child L-locks are any of these L-lock types: page, row. The number of wait trace events processed for waits for global contention for child L-locks. OTHER The accumulated wait time due to global contention for other L-locks. The number of wait trace events processed for waits for global contention for other L-locks. GLOBAL CONTENTION P-LOCKS AVERAGE TIME AV.EVENT ------------------------------------ ------------ -------- P-LOCKS 0.000000 0.00 PAGESET/PARTITION 0.000000 0.00 PAGE 0.000000 0.00 OTHER 0.000000 0.00 P-LOCKS The accumulated wait times due to global contention for all P-locks. The accumulated wait trace events processed for waits for global contention of all P-locks. PAGESET/PARTITION The accumulated wait time due to global contention for pageset/partition P-locks. The number of wait trace events processed for waits for global contention for pageset/partition P-locks. PAGE The accumulated wait time due to global contention for page P-locks. The number of wait trace events processed for waits for global contention for page P-locks. OTHER The accumulated wait time due to global contention for other P-locks. The number of wait trace events processed for waits for global contention for other P-locks.
Local fix
Problem summary
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
II12807
Reported component name
PB LIB INFO ITE
Reported component ID
INFOPBLIB
Reported release
001
Status
INTRAN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2001-03-20
Closed date
Last modified date
2001-03-20
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":null,"label":null},"Product":{"code":"SG19O","label":"APARs - MVS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
20 March 2001