Sumeet,

This BUG / issue is reported in APAR list

see this link
http://www-306.ibm.com/software/data/db2/udb/support/downloadv8.html
V810 FixPak 7a for AIX 5 32-bit & 64-bit -> select APAR list


other bug report link for fixpack 7a :
It turns out that this is a APAR, which has been fixed recently. APAR
IY66171
Ref:
http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&dc=DB520&dc=D600&dc=DB530&dc=D700&dc=DB500&dc=DB540&dc=DB510&dc=DB550&q1=IY66171&uid=swg21195837&loc=en_US&cs=utf-8&lang=en


Thanks
Thirumaran

----- Original Message -----
From: "sumeet" <db2udbdba-ezmlmshield-x20898676.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, January 28, 2005 3:24 AM
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
>
>



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