You might need to update statistics. Especially if you rebuilt your indexes
to type-2 as part of the migration. Here's a snippet of documentation on
your error.

SQL0437W Performance of this complex query may be sub-optimal. Reason code:
6. Reissue RUNSTATS for both the tables involved in the query and their
corresponding indexes, that is, use the AND INDEXES ALL clause so that table
and index statistics are consistent (Reason code 6)

Good luck,
Blair

-----Original Message-----
From: sumeet
[mailto:db2udbdba-ezmlmshield-x20898676.[Email address protected]
Sent: Thursday, January 27, 2005 1:54 PM
To: LazyDBA Discussion
Subject: RE: SQL SUBOPTIMAL help please...



Hey Folks,

Since we have upgraded from Db7.2 to DB2 8.2 to DB2 8.2 fix pack 7a we
are getting the This SQL Error. We run DB2 on AIX 5.1 Unix Server.

insert into PS_HBC_CUSTR_LKUP_wk select * from PS_HBC_CUSTR_LKUP a where
substr(a.FI_INSTRUMENT_ID,1,3) IN ('XIM','XAM','XST','XCL') and
a.fi_instrument_id = ( select b.HBC_INSTRUMENT_FR from PS_HBC_INSTRUMENT b
WHERE b.HBC_INSTRUMENT_FR = a.fi_instrument_id)
SQL0437W Performance of this complex query may be sub-optimal. Reason
code:
"6". SQLSTATE=01602

Other than this message We also out ETL Processes which load data into
Tables from Flat Files have been running 4 to 5itmes faster.

Can someone please help us in this issue?

Thank You,

Sumeet Agarwal
Technology & Solutions
Ph: 312-293-4976
sumeet.[Email address protected]
Fax: 312-461-7333





---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


"Attention: This message is intended only for the individual to whom it is
addressed and may contain information that is confidential or privileged. If
you are not the intended recipient, or the employee or person responsible for
delivering it to the intended recipient, you are hereby notified that any
dissemination, distribution, copying or use is strictly prohibited. If you
have received this communication in error, please notify the sender and
destroy or delete this communication immediately."
==============================================================================

DB2 & UDB email list listserv db2-l LazyDBA home page