Scott, Thanks for the input on this.
However, I just checked and I have dft_degree = 1 on all the partitions. I
thought that meant no intra-partition parallelism. Right?
>From: "Scott Hayes" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: Re: DB2EUG: DB2 Connections under Websphere
>Date: Thu, 31 May 2001 09:43:18 -0400
>
>Amir,
>
>I see from your list applications command that there are multiple agents
>servicing your WebSphere pooled connections, which suggests to me that
>INTRA_PARALLEL is probably turned ON. Generally, in a transactional
>environment such as WebSphere, Siebel, Peoplesoft, Baan, Net.Data, and
>others, INTRA_PARALLEL should be OFF. Having INTRA_PARALLEL ON encumbers
>to
>much overhead of setting up subagents and coordinating result sets, when
>typical SQL returns short, sweet, simple, and small results. If your
>sense/perception/measurement is that OLTP performance is better with
>INTRA_PARALLEL ON, then you likely have SQL that is performing scans, table
>or index leaf pages. INTRA_PARALLEL ON, in this case, is only a band-aid
>fix with high CPU costs, and the application will likely have trouble
>scaling to its maximum potential on the hardware. I suggest you turn
>INTRA_PARALLEL OFF, which will also free up a shared memory segment, which
>means you could possibly make bufferpools larger. Once INTRA_PARALLEL is
>OFF, use the SQL Event instrumentation or DGI's SQL-GUY(TM) tool to rapidly
>detect any SQL having excessively high CPU costs (high CPU burn rate is
>just
>about the only way to detect index leaf page scans).
>
>Best regards,
>Scott
>
>DGI is not a Siebel Strategic Software Alliance Partner. The $50K annual
>fee to be promoted by Siebel is better spent on R&D to create tools and
>products that deliver results for IBM DB2 UDB. DGI's customers running
>Siebel are achieving dramatic Breakthrough Results for DB2 performance.
>Cut
>EIM processing time by 80% or more in an hour or less, learn more at:
>http://www.breakthroughdb2.com/siebel/
>
>----- Original Message -----
>From: Amir Sadeghi <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Friday, May 25, 2001 3:41 PM
>Subject: DB2EUG: DB2 Connections under Websphere
>
>
> > Hi,
> >
> > In a UDB AIX/Websphere environment, how do we go about tracking a
>specific
> > user or applications down. In DB2, a "list applications" shows a list
>such
> > as the one below. In the example below, I am interested in 'Auth ID
>ABCDEFG'
> > which is the application. Is there any way to tell quickly who is using
> > that connection.
> >
> > Websphere maintains its connection pool to DB2 and that means a
>connection
> > can be used by different users.
> >
> >
> >
> > Auth Id Application Appl. Application Id DB
>#
> > of
> > Name Handle Name
> > Agents
> > -------- -------------- ---------- ------------------------------
>--------
> > -----
> > DBPROD db2bp 786481 *LOCAL.DBPROD.010524005645 TESTDB
>2
> > DBPROD db2bp 786491 *LOCAL.DBPROD.010524010345 TESTDB
>3
> > L1765 db2ccs.exe 50 0A621A14.06AF.010524010523 TESTDB
>1
> > ABCDEFG java 786684 0A0C1E17.A85B.010524031003 TESTDB
>4
> > ABCDEFG java 786685 0A0C1E17.A85C.010524031004 TESTDB
>4
> >
>_________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at
>http://www.hotmail.com.
> >
> >
> > =====
> > To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> > For other info (and scripts), see
>http://people.mn.mediaone.net/scottrmcleod
> >
>
>
>=====
>To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
>For other info (and scripts), see
>http://people.mn.mediaone.net/scottrmcleod
>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
