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
