Re: Problems with tempdbs with IDS 9.30 UC1 and RedHat 7.1

Andreas wrote: > Hallo Keith, > > we have only this version because the support contract was cancled. So > we had to use IDS 9.30 UC1. > > We have the same software on an older system with 1 GB memory running. > Perfect! In 14 days there are only 420.000 pages written to the > tempdbs. With the new server this is the amount of 1 action. Onconfig > was copied from the old machine, so the IDS configuration should be > identically. > > Any other suggestions? Yes, Keith's most important suggestion to which you have not responded is still open. Have you run UPDATE STATISTICS on the database at least at the level recommended in the Performance Guide since loading the data into this new server? If not that is likely the problem. Without these data distributions the optimizer will think you tables are empty and that a nice fast table scan is just the method needed to fulfill your query! Run the recommended suite of commands, or get my dostats utility which implements that protocol. Dostats is included in the package utils2_ak and available for free download from the IIUG Software Repository. Art S. Kagel > Simmons, Keith schrieb: > > >>Andreas >> >>Upgrade to 10.00 (or 9.4 at a pinch) >>UPDATE STATISTICS>> >>Keith >> >>-> -----Original Message----- >>-> From: Andreas [mailto:a.weidner@knauer-verpackung.de] >>-> Sent: Tuesday, July 25, 2006 10:34 AM >>-> To: informix-list@iiug.org >>-> Subject: Problems with tempdbs with IDS 9.30 UC1 and RedHat 7.1 >>-> >>-> >>-> Hallo, >>-> >>-> we have problems with a new installed IDS 9.30 UC1 on a RedHat 7.1 >>-> system. >>-> >>-> If we do a query on our databases, we get more than 400.000 pages >>-> written and near the same number of pages readed from the tempdbs >>-> partition. All other page written on partitions with rootdbs and >>-> datadbs seem to be normal. >>-> >>-> We are using a HP DL 380 G4 with 2 CPUs and 3.6 GB of memory. The >>-> RedHat runs on a virtual machine (VMware 2.5.3). A HP MSA1000 is used >>-> as disk. >>-> >>-> What could we do? >>-> >>-> Best regards >>-> Andreas