Query taking long to execute

Hi all, Guys i've just finished migrating my DB from IDS 7.3 to IDS 10 on suse linux 10, my problem is the queries seems to take like forever to execute, which is not the case with my old IDS, what am i missing? Paul

I was wondering , have you updated your statistics? -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of PAUL GATHOGO Sent: Wednesday, April 11, 2007 12:04 PM To: ids@iiug.org Subject: Query taking long to execute [8816] Hi all, Guys i've just finished migrating my DB from IDS 7.3 to IDS 10 on suse linux 10, my problem is the queries seems to take like forever to execute, which is not the case with my old IDS, what am i missing? Paul ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. 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 proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com

You need to drop all of hte 7.31 data distributions and rebuild them using 10. ----- Original Message ----- From: Paul Gathogo <ids@iiug.org> At: 4/11 2:34:11 Hi all, Guys i've just finished migrating my DB from IDS 7.3 to IDS 10 on suse linux 10, my problem is the queries seems to take like forever to execute, which is not the case with my old IDS, what am i missing? Paul ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Hi Paul, As several people have mentioned. Rebuilding your distributions is a must. Any chance you can send a diff of the onconfig between version 7 and 10? And the values for the following, if they are the same: OPTCOMPINDOPTGOAL Oh and can you give some exacmple queries that are slower, and whether or not they use views. Thanks Much, Mark ----- Original Message ---- From: PAUL GATHOGO <pgathogo@gmail.com> To: ids@iiug.org Sent: Wednesday, April 11, 2007 1:33:42 AM Subject: Query taking long to execute [8816] Hi all, Guys i've just finished migrating my DB from IDS 7.3 to IDS 10 on suse linux 10, my problem is the queries seems to take like forever to execute, which is not the case with my old IDS, what am i missing? Paul ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.