RE: Advised index not used but still advised

Elvis,

I did see a few posts in the archives about sort sequences and everything appears to have the same sequence. The queries are built on the data warehouse server using a tool called Informatica and run on the iSeries. Looking at the listener and query jobs shows a sort sequence of *HEX. The indexes also have a sort sequence of *HEX.

I is sounding like a PMR might be in order.

Rick

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Elvis Budimlic
Sent: Monday, September 14, 2009 10:06 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Advised index not used but still advised

SQE does not time out, CQE may.

Sort Sequence differences may play into this scenario.

In case it's an IBM bug, submit a PMR to IBM. They won't correct the advice engine unless they hear from the customers on this issue.

Elvis

Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and OS/400 www.centerfieldtechnology.com


Privileged and Confidential. This e-mail, and any attachments there to, is intended only for use by the addressee(s) named herein and may contain privileged or confidential information. If you have received this e-mail in error, please notify me immediately by a return e-mail and delete this e-mail. You are hereby notified that any dissemination, distribution or copying of this e-mail and/or any attachments thereto, is strictly prohibited.