Performance SQL

Venu

Performance SQL
Can someone give me some tips on what to look for on tuning this
monster? I ran modifies, runstats, and rebinds over the weekend but of
no use.

What should I be looking for?

DECLARE CUISFB_3A_CURSOR CURSOR FOR
SELECT ORTHED. ORDER_BR ,
ORTHED. ORDER_ID,
ORTHED. ENTRY_DT,
ORTLNE. DIST_ID,
ORTLNE. SHIP_ID,
LINE_NBR,
'O'
FROM ORTHED,
ORTLNE
WHERE ORTHED. COMPANY_ID = : H
AND CUST_ID = : H
AND ORTHED. ENTRY_DT BETWEEN : H
AND : H
AND ORTLNE. COMPANY_ID = ORTHED. COMPANY_ID
AND ORTLNE. ORDER_BR = ORTHED. ORDER_BR
AND ORTLNE. ORDER_ID = ORTHED. ORDER_ID
AND ORTLNE. PART_ID = : H
AND ORTLNE. STATUS NOT
IN
( 'T', 'V')
UNION ALL
SELECT OHTSHP. ORDER_BR,
OHTSHP. ORDER_ID,
OHTSHP. ENTRY_DT,
OHTSHP. DIST_ID,
OHTSHP. SHIP_ID,
LINE_NBR,
'H'
FROM OHTSHP,
OHTLNE
WHERE OHTSHP. COMPANY_ID = : H
AND CUST_ID = : H
AND OHTSHP. ENTRY_DT BETWEEN : H
AND : H
AND OHTLNE. COMPANY_ID = OHTSHP.COMPANY_ID
AND OHTLNE. ORDER_BR = OHTSHP.ORDER_BR
AND OHTLNE. ORDER_ID = OHTSHP.ORDER_ID
AND OHTLNE. DIST_ID = OHTSHP DIST_ID
AND OHTLNE. SHIP_ID = OHTSHP.SHIP_ID
AND PART_ID = : H
AND OHTLNE STATUS NOT IN
('T', 'V')
ORDER BY 3


Thanks & Regards,
Venu.


Confidentiality Notice

The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [login to unmask email] immediately
and destroy all copies of this message and any attachments.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NOMAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

James Campbell

Re: Performance SQL
(in response to Venu)
You didn't mention looking at explain/plan_table output. That's
normally the first place to start looking, followed by looking at the
actual statistics and asking the question "is DB2 doing what I expect
it to do, if not why not?". If, however, you have no idea how DB2
should be handling the query, then DB2 is doing what you expect it to
do!

Scan the archives for suggestions made in the past.

James Campbell


On 8 Jan 2004 at 9:52, venugopal wrote:

> Can someone give me some tips on what to look for on tuning this
> monster? I ran modifies, runstats, and rebinds over the weekend but of
> no use.
>
> What should I be looking for?
>
<actual query snipped>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NOMAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Dave Nance

Re: Performance SQL
(in response to James Campbell)
Venu,
As James mentioned in his reply you don't say anything about having done explains on the query and what type of access you are getting. Also, since we do not know you're index structures don't really know if you are making the best use of them or if they really support what you are trying to do. Please remember this is all just guess work on my part, since I do not know your business nor how you typically access this data, another unkownis the cardinality of the columns in the table. I am presuming that the CUST_ID column resides in the ORTHED and OHTSHP tables? If this is true, your best index scheme for those two tables and this query would be on the columns COMPANY_ID, CUST_ID and ENTRY_DT. The indexes for the other two tables look like they should be COMPANY_ID, ORDER_BR, ORDER_ID, PART_ID and STATUS. Another question would be why do you have the identical structures? I'm guessing one is historical data, did it really need to be separated as has been done, is there too much data in the historical tables and that's what is slowing you down? There are way too many questions for us on the limited info you provided to be of any real help.

Dave Nance
First Health Services, Corp.
(804)527-6841


>>> [login to unmask email] 1/7/04 11:22:35 PM >>>
Can someone give me some tips on what to look for on tuning this
monster? I ran modifies, runstats, and rebinds over the weekend but of
no use.

What should I be looking for?
DECLARE CUISFB_3A_CURSOR CURSOR FOR
SELECT ORTHED. ORDER_BR ,
ORTHED. ORDER_ID,
ORTHED. ENTRY_DT,
ORTLNE. DIST_ID,
ORTLNE. SHIP_ID,
LINE_NBR,
'O'
FROM ORTHED,
ORTLNE
WHERE ORTHED. COMPANY_ID = : H
AND CUST_ID = : H
AND ORTHED. ENTRY_DT BETWEEN : H
AND : H
AND ORTLNE. COMPANY_ID = ORTHED. COMPANY_ID
AND ORTLNE. ORDER_BR = ORTHED. ORDER_BR
AND ORTLNE. ORDER_ID = ORTHED. ORDER_ID
AND ORTLNE. PART_ID = : H
AND ORTLNE. STATUS NOT
IN
( 'T', 'V')
UNION ALL
SELECT OHTSHP. ORDER_BR,
OHTSHP. ORDER_ID,
OHTSHP. ENTRY_DT,
OHTSHP. DIST_ID,
OHTSHP. SHIP_ID,
LINE_NBR,
'H'
FROM OHTSHP,
OHTLNE
WHERE OHTSHP. COMPANY_ID = : H
AND CUST_ID = : H
AND OHTSHP. ENTRY_DT BETWEEN : H
AND : H
AND OHTLNE. COMPANY_ID = OHTSHP.COMPANY_ID
AND OHTLNE. ORDER_BR = OHTSHP.ORDER_BR
AND OHTLNE. ORDER_ID = OHTSHP.ORDER_ID
AND OHTLNE. DIST_ID = OHTSHP DIST_ID
AND OHTLNE. SHIP_ID = OHTSHP.SHIP_ID
AND PART_ID = : H
AND OHTLNE STATUS NOT IN
('T', 'V')
ORDER BY 3


Thanks & Regards,
Venu.


Confidentiality Notice

The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [login to unmask email] immediately
and destroy all copies of this message and any attachments.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NOMAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

This message, including any attachments, is intended solely for the use
of the named recipient(s) and may contain confidential and/or
privileged information. Any unauthorized review, use, disclosure or
distribution of this communication(s) is expressly prohibited.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy any and all copies of the original message.
Thank you.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NOMAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Venkat Srinivasan

Re: Performance SQL
(in response to Dave Nance)
Why would you think, Modify help in your case!!!.

This should be relatively simple, I guess.

You should most likely shoot for ORTHED, OHTSEP as the first table in JOIN.
I assumed that CUSTID is avlbl in these tables and will filter most.
Generally you wd want to determine which table should be the outer table
and what join method is optimal.

What is the current access path?.

Since you have a cusrsor based fetch, if you are reading one by one from a
flat file make sure the records are ordered.

If you are reading from a table, you may be able to eliminate this cursor
with a JOIN to that table where you get the predicate qualifiers.

Venkat...

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NOMAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Philip Sevetson

Re: Performance SQL
(in response to Venkat Srinivasan)
Venugopal,
If you have indexes on the columns used in the local predicates, which
contain these local predicates as the high-order columns, this should
optimize your performance in this query.

That is, there should be an index which i'll call ORTHEDX1 which contains
these columns, preferably in this order, as its first three columns:
[ORTHED.?] CUST_ID
ORTHED. COMPANY_ID
ORTHED. ENTRY_DT

One ORTLNEX1 which contains this as its first column:
ORTLNE. PART_ID
with, possibly, a second column depending on its cardinality:
ORTLNE. STATUS

In addition to this, you will also want to create ORTLNEX2 which would
only be used if ORTLNE was the first table accessed in that query block:
ORTLNE. PART_ID
[maybe ORTLNE. STATUS]
ORTLNE. COMPANY_ID
ORTLNE. ORDER_BR
ORTLNE. ORDER_ID
Expect only one of these two indexes to be used (ORTLNEX1 and ORTLNEX2);
drop the other.
Do the same type of thing with OHTLNE.


--Phil Sevetson
Database Administration
Wakefern Food Corporation CISD
mailto:[login to unmask email]






venugopal <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/07/2004 11:22 PM
Please respond to DB2 Database Discussion list at IDUG


To: [login to unmask email]
cc:
Subject: [DB2-L] Performance SQL


Can someone give me some tips on what to look for on tuning this
monster? I ran modifies, runstats, and rebinds over the weekend but of
no use.

What should I be looking for?

DECLARE CUISFB_3A_CURSOR CURSOR FOR
SELECT ORTHED. ORDER_BR ,
ORTHED. ORDER_ID,
ORTHED. ENTRY_DT,
ORTLNE. DIST_ID,
ORTLNE. SHIP_ID,
LINE_NBR,
'O'
FROM ORTHED,
ORTLNE
WHERE ORTHED. COMPANY_ID = : H
AND CUST_ID = : H
AND ORTHED. ENTRY_DT BETWEEN : H
AND : H
AND ORTLNE. COMPANY_ID = ORTHED. COMPANY_ID
AND ORTLNE. ORDER_BR = ORTHED. ORDER_BR
AND ORTLNE. ORDER_ID = ORTHED. ORDER_ID
AND ORTLNE. PART_ID = : H
AND ORTLNE. STATUS NOT
IN
( 'T', 'V')
UNION ALL
SELECT OHTSHP. ORDER_BR,
OHTSHP. ORDER_ID,
OHTSHP. ENTRY_DT,
OHTSHP. DIST_ID,
OHTSHP. SHIP_ID,
LINE_NBR,
'H'
FROM OHTSHP,
OHTLNE
WHERE OHTSHP. COMPANY_ID = : H
AND CUST_ID = : H
AND OHTSHP. ENTRY_DT BETWEEN : H
AND : H
AND OHTLNE. COMPANY_ID = OHTSHP.COMPANY_ID
AND OHTLNE. ORDER_BR = OHTSHP.ORDER_BR
AND OHTLNE. ORDER_ID = OHTSHP.ORDER_ID
AND OHTLNE. DIST_ID = OHTSHP DIST_ID
AND OHTLNE. SHIP_ID = OHTSHP.SHIP_ID
AND PART_ID = : H
AND OHTLNE STATUS NOT IN
('T', 'V')
ORDER BY 3


Thanks & Regards,
Venu.


Confidentiality Notice

The information contained in this electronic message and any attachments
to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or
[login to unmask email] immediately
and destroy all copies of this message and any attachments.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of
the office, send the SET DB2-L NOMAIL command to
[login to unmask email] The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NOMAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Venu

Re: Performance SQL
(in response to Philip Sevetson)
Sorry for not giving the explain/plan output. Pls find the explain
output as well as the indexes on the tables. Hope this helps the
experts to give some suggestions.

QUERYBLK PLANNO METHOD TNAME ACCESSTYPE MATCHCOLS
ACCESSNAME INDEXONLY
---------+---------+---------+---------+---------+---------+------+-----
------+----------
1 1 0 ORTHED I 1
ORTHED02 Y
1 3 3 0
N
1 2 1 ORTLNE I 3
ORTLNE06 N
2 2 1 OHTSHP I 1
OHTSHP07 Y
2 1 0 OHTLNE I 1
OHTLNE02 N

TABLE - ORTHED ( Indexes ) Total no. of records are 20983 & Active
Pages are 3420

ORTHED01 ORTHED02 ORTHED03 ORTHED04
ORTHED05
------------------------------------------------------------------------
---------
ORDER_ID CUST_ID ORIG_ORDER_ID OS_SLSM_ID
IS_SLSM_ID
ORDER_BR CUST_ORDER_ID ORDER_ID CUST_ID
CUST_ID
COMPANY_ID ENTRY_DT ORDER_BR ORDER_BR
ORDER_BR
ORDER_BR COMPANY_ID ORDER_ID
ORDER_ID
ORDER_ID COMPANY_ID
COMPANY_ID
COMPANY_ID

TABLE - ORTLNE(Indexes) Total no. of records are 114314 & Active Pages
are 35640

ORTLNE01 ORTLNE02 ORTLNE03 ORTLNE05 ORTLNE06
ORTLNE07
------------------------------------------------------------------------
---------------
ORDER_ID PART_ID ORIG_ORDER_ID SHIP_FROM_BR COMPANY_ID
COMPANY_ID
DIST_ID SHIP_FROM_BR ORDER_BR INVC_IND_CD ORDER_BR
ORDER_BR
SHIP_ID ALLOC_CD ORIG_LINE_NBR VEND_ID ORDER_ID
PART_ID
LINE_NBR PRIORITY_CD ORDER_ID CREATE_STAMP DIST_ID
ORDER_BR ENTRY_DT DIST_ID COMPANY_ID SHIP_ID
COMPANY_ID REQUIRED_DT SHIP_ID LINE_NBR
COMPANY_ID COMPANY_ID TR_TO_BR
INVC_IND_CD COMMODITY_CD
LINE_TYPE

TABLE -OHTSHP( Indexes ) Total no. or records are 3001517 & Active
Pages are 746216

OHTSHP01 OHTSHP02 OHTSHP03 OHTSHP04 OHTSHP05
OHTSHP06 OHTSHP07
------------------------------------------------------------------------
-------------------ORDER_BR ORDER_TYPE STATUS ORDER_BR
INVOICE_STAMP SHIP_FROM_BR CUST_ID
ORDER_ID ORDER_BR COMPANY_ID ORIG_ORDER_BR ORDER_BR
BOL_ID CUST_ORDER_ID
COMPANY_ID ORDER_ID INVOICE_STAMP COMPANY_ID ORDER_ID
COMPANY_ID ORDER_BR
ENTRY_DT COMPANY_ID ORDER_BR ENTRY_DT COMPANY_ID
ORDER_ID
DIST_ID DIST_ID SHIP_FROM_BR ENTRY_DT
DIST_ID
SHIP_ID SHIP_ID DIST_ID
SHIP_ID
ENTRY_DT SHIP_ID
ENTRY_DT

COMPANY_ID

TABLE - OHTLNE(Indexes) Total no. of records are 11963907 & Active
pages are 653889

OHTLNE01 OHTLNE02 OHTLNE03
--------------------------------------------------
ORDER_ID PART_ID ORIG_ORDER_ID
ORDER_BR ORDER_ID ORDER_BR
ENTRY_DT ORDER_BR ORIG_LINE_NBR
COMPANY_ID COMPANY_ID ORDER_ID
DIST_ID DIST_ID
SHIP_ID SHIP_ID
LINE_NBR ENTRY_DT
COMPANY_ID


Thanks in Advance,
Venu.


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of James Campbell
Sent: Thursday, January 08, 2004 4:11 PM
To: [login to unmask email]
Subject: Re: Performance SQL


You didn't mention looking at explain/plan_table output. That's
normally the first place to start looking, followed by looking at the
actual statistics and asking the question "is DB2 doing what I expect it
to do, if not why not?". If, however, you have no idea how DB2 should
be handling the query, then DB2 is doing what you expect it to do!

Scan the archives for suggestions made in the past.

James Campbell


On 8 Jan 2004 at 9:52, venugopal wrote:

> Can someone give me some tips on what to look for on tuning this
> monster? I ran modifies, runstats, and rebinds over the weekend but
> of no use.
>
> What should I be looking for?
>
<actual query snipped>

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". If you will be out of the office,
send the SET DB2-L NOMAIL command to [login to unmask email] The
IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm


Confidentiality Notice

The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [login to unmask email] immediately
and destroy all copies of this message and any attachments.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NOMAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

James Campbell

Re: Performance SQL
(in response to Venu)
I suspect that it's the second half of the query that's causing you
grief. An index on OHTSHP(COMPANY_ID, CUST_ID, ENTRY_DT) would do a
lot to help.

James Campbell


On 9 Jan 2004 at 11:44, venugopal wrote:

> Sorry for not giving the explain/plan output. Pls find the explain
> output as well as the indexes on the tables. Hope this helps the
> experts to give some suggestions.
>
> QUERYBLK PLANNO METHOD TNAME ACCESSTYPE MATCHCOLS
> ACCESSNAME INDEXONLY
> ---------+---------+---------+---------+---------+---------+------+-----
> ------+----------
> 1 1 0 ORTHED I 1
> ORTHED02 Y
> 1 3 3 0
> N
> 1 2 1 ORTLNE I 3
> ORTLNE06 N
> 2 2 1 OHTSHP I 1
> OHTSHP07 Y
> 2 1 0 OHTLNE I 1
> OHTLNE02 N
>
> TABLE - ORTHED ( Indexes ) Total no. of records are 20983 & Active
> Pages are 3420
>
> ORTHED01 ORTHED02 ORTHED03 ORTHED04
> ORTHED05
> ------------------------------------------------------------------------
> ---------
> ORDER_ID CUST_ID ORIG_ORDER_ID OS_SLSM_ID
> IS_SLSM_ID
> ORDER_BR CUST_ORDER_ID ORDER_ID CUST_ID
> CUST_ID
> COMPANY_ID ENTRY_DT ORDER_BR ORDER_BR
> ORDER_BR
> ORDER_BR COMPANY_ID ORDER_ID
> ORDER_ID
> ORDER_ID COMPANY_ID
> COMPANY_ID
> COMPANY_ID
>
> TABLE - ORTLNE(Indexes) Total no. of records are 114314 & Active Pages
> are 35640
>
> ORTLNE01 ORTLNE02 ORTLNE03 ORTLNE05 ORTLNE06
> ORTLNE07
> ------------------------------------------------------------------------
> ---------------
> ORDER_ID PART_ID ORIG_ORDER_ID SHIP_FROM_BR COMPANY_ID
> COMPANY_ID
> DIST_ID SHIP_FROM_BR ORDER_BR INVC_IND_CD ORDER_BR
> ORDER_BR
> SHIP_ID ALLOC_CD ORIG_LINE_NBR VEND_ID ORDER_ID
> PART_ID
> LINE_NBR PRIORITY_CD ORDER_ID CREATE_STAMP DIST_ID
> ORDER_BR ENTRY_DT DIST_ID COMPANY_ID SHIP_ID
> COMPANY_ID REQUIRED_DT SHIP_ID LINE_NBR
> COMPANY_ID COMPANY_ID TR_TO_BR
> INVC_IND_CD COMMODITY_CD
> LINE_TYPE
>
> TABLE -OHTSHP( Indexes ) Total no. or records are 3001517 & Active
> Pages are 746216
>
> OHTSHP01 OHTSHP02 OHTSHP03 OHTSHP04 OHTSHP05
> OHTSHP06 OHTSHP07
> ------------------------------------------------------------------------
> -------------------ORDER_BR ORDER_TYPE STATUS ORDER_BR
> INVOICE_STAMP SHIP_FROM_BR CUST_ID
> ORDER_ID ORDER_BR COMPANY_ID ORIG_ORDER_BR ORDER_BR
> BOL_ID CUST_ORDER_ID
> COMPANY_ID ORDER_ID INVOICE_STAMP COMPANY_ID ORDER_ID
> COMPANY_ID ORDER_BR
> ENTRY_DT COMPANY_ID ORDER_BR ENTRY_DT COMPANY_ID
> ORDER_ID
> DIST_ID DIST_ID SHIP_FROM_BR ENTRY_DT
> DIST_ID
> SHIP_ID SHIP_ID DIST_ID
> SHIP_ID
> ENTRY_DT SHIP_ID
> ENTRY_DT
>
> COMPANY_ID
>
> TABLE - OHTLNE(Indexes) Total no. of records are 11963907 & Active
> pages are 653889
>
> OHTLNE01 OHTLNE02 OHTLNE03
> --------------------------------------------------
> ORDER_ID PART_ID ORIG_ORDER_ID
> ORDER_BR ORDER_ID ORDER_BR
> ENTRY_DT ORDER_BR ORIG_LINE_NBR
> COMPANY_ID COMPANY_ID ORDER_ID
> DIST_ID DIST_ID
> SHIP_ID SHIP_ID
> LINE_NBR ENTRY_DT
> COMPANY_ID
>
>
> Thanks in Advance,
> Venu.
>
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
> Behalf Of James Campbell
> Sent: Thursday, January 08, 2004 4:11 PM
> To: [login to unmask email]
> Subject: Re: Performance SQL
>
>
> You didn't mention looking at explain/plan_table output. That's
> normally the first place to start looking, followed by looking at the
> actual statistics and asking the question "is DB2 doing what I expect it
> to do, if not why not?". If, however, you have no idea how DB2 should
> be handling the query, then DB2 is doing what you expect it to do!
>
> Scan the archives for suggestions made in the past.
>
> James Campbell
>
>
> On 8 Jan 2004 at 9:52, venugopal wrote:
>
> > Can someone give me some tips on what to look for on tuning this
> > monster? I ran modifies, runstats, and rebinds over the weekend but
> > of no use.
> >
> > What should I be looking for?
> >
> <actual query snipped>
>
> ------------------------------------------------------------------------
> ---------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
> home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
> page select "Join or Leave the list". If you will be out of the office,
> send the SET DB2-L NOMAIL command to [login to unmask email] The
> IDUG List Admins can be reached at [login to unmask email] Find
> out the latest on IDUG conferences at
> http://conferences.idug.org/index.cfm
>
>
> Confidentiality Notice
>
> The information contained in this electronic message and any attachments to this message are intended
> for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
> you are not the intended recipient, please notify the sender at Wipro or [login to unmask email] immediately
> and destroy all copies of this message and any attachments.
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NOMAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm