SV: [DB2-L] DB2 internal class latch

Olle Brostrom

SV: [DB2-L] DB2 internal class latch
Hi Renzo,
I have not found any good documentation on Latch classes, but I have got the following information from IBM:

LC
10 SSSC Allied Agnt Queue
14 Bufferpool LRU & hash chain
23 Buffer Manager Exclusive-2
24 EDM pool LRU chain
31 Storage Manager Pool Vector Table
32 Storage Manager Pool Header Block



Med vänliga hälsningar/Best regards

Olle Broström



________________________________

Från: DB2 Data Base Discussion List [mailto:[login to unmask email] För Renzo razzetti
Skickat: den 24 januari 2009 03:55
Till: [login to unmask email]
Ämne: [DB2-L] DB2 internal class latch


Hi all

Could anyone direct me to good documentation for the DB2 internal class latch ?

I will appreciate very much !

RR


________________________________


IDUG 2009 - Australasia * 18-20 March * Melbourne, Australia < http://idug.org/lsAU >

IDUG.org <http://www.idug.org> was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register here. < http://www.idug.org/component/juser/register.html >


______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Roger Miller

Re: DB2 internal class latch
(in response to Olle Brostrom)
Good documentation on DB2 internals is pretty close to an oxymoron, as most
information is partial, at best. Most of the information is in a performance
note or presentation, but it's scattered. Latches are used in thousands of
places over the decades, and not all of the use is consistent. Watch for
APAR PK77514 (still open) to describe the latch classes.

IMPORTANT NOTE: All latch class descriptions denote the predominant latch
usage. The description does NOT cover all usage of a given latch class.

latch
class primary use
03 DDF disconnect
04 SYSSTRING cache or OBD allocation
05 IRLM data sharing exits or RLF
06 Data sharing index split
07 Index lotch
08 Query parallelism
09 Utilities or stored procedure URIDs
10 Allied agent chain or sequence descriptors
11 DGTT allocation
12 Global transaction ID table
13 Pageset operations
14 Bufferpool LRU
15 ARCHIVE LOG MODE(QUIESCE)
16 UR chain
17 RURE chain
18 DDF resynch list
19 Log write
20 System checkpoint
21 Accounting rollup
22 Internal checkpoint
23 Buffer manager
24 EDM pool or prefetch
25 Workfile allocation
26 Dynamic statement cache
27 Stored procedures or authorization cache
28 Stored procedures or authorization cache
29 Field procs
30 DDF transaction manager and agent services
31 Storage manager
32 Storage manager

Roger Miller, DB2 for z/OS

On Sat, 24 Jan 2009 10:55:04 +0800, Renzo razzetti
<[login to unmask email]> wrote:

>Hi all
>
>Could anyone direct me to good documentation for the DB2 internal class
>latch ?
>
>I will appreciate very much !
>
>RR
>
>

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html