TYPE 2 INDEX WITH CONCURRENT PROCESSING

Roger (MTO) Ghose

TYPE 2 INDEX WITH CONCURRENT PROCESSING
Hi List,
This is my second time posting this message. I would appreciate it
very much if somebody could direct me to some manual or document which has
some explaination on Type 2 Index how it handles page processing during
INSERT in a concurrent environment.

Are there any kind of locking/latching going on which might have a negative
impact on preformance specially when the key is BUSINESS_DATE.

Thanking you all in advance!

Roger



Isaac Yassin

Re: TYPE 2 INDEX WITH CONCURRENT PROCESSING
(in response to Roger (MTO) Ghose)
Hi,

DB2 DIAGNOSIS GUIDE & REFERENCE is the book you want.

Isaac Yassin
DBMS & IT Consultant
IBM Certified Solution Expert
DB2 V7.1 Database Administration for OS/390


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of Roger Ghose
Sent: Thursday, January 16, 2003 7:05 PM
To: [login to unmask email]
Subject: TYPE 2 INDEX WITH CONCURRENT PROCESSING

Hi List,
This is my second time posting this message. I would appreciate
it
very much if somebody could direct me to some manual or document which
has
some explaination on Type 2 Index how it handles page processing during
INSERT in a concurrent environment.

Are there any kind of locking/latching going on which might have a
negative
impact on preformance specially when the key is BUSINESS_DATE.

Thanking you all in advance!

Roger



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can