RE: Upgrading IDS from 7.31 to 9.xx

We've been running on IDS 7.x for many years on the HP product line; we upgraded to 9.30.FC1 on 64-bit HPUX 11i on N4000 (and HP K boxes) about 8 months ago very successfully. Multiple engines, multiple machines. Been pretty stable since conversion, but there were some quirks running replication between 7 and 9 during our conversion phase. We went to 64-bit IDS 9 from 32-bit IDS 7 - the main reason was increased memory capacity of IDS 9 and wanted to move to a 64-bit platform. With several hundred users attaching to an instance, on IDS 7 we were pushing the edge of maximum memory per machine and per instance - with IDS 9, we're now using about 3 GB on our largest engine and 3.5 GB on that machine. Secondary reasons were the increased functionality in the IDS 9 product, for example; improvements in ER; the ability to embed JAVA or C (which we have not explored as yet); user-defined datatypes; future product enhancements; etc. Some of our favorite features include the dynamic locks, the dynamic log allocation, and the ability to block database creation. I'm not sure when the 'block database creation' is officially supported, but it works in the 9.30 product. I block database creation in my production engines, but not in the development engines. Not sure about the pricing... -----Original Message----- From: John Lynch (IS) [mailto:John.Lynch@davy.ie] Sent: Wednesday, May 21, 2003 5:32 AM To: 'informix-list@iiug.org' Cc: Fergal Flanagan; Ciaran MacGabhann Subject: Upgrading IDS from 7.31 to 9.xx Informix Dynamic Server Version 7.31.FD6 Hi , We are looking at the viability of upgrading our IDS 7.31 to version 9.xx . O.S. is HP-UX Ver 11.0 running on a HP N class server. Several NT, SUN based applications lookup the database (via ODBC) along with a traditional Informix r4gl application running on the HP N Class server. It is fair to say this would be considered the mission critical application amongst all the apps that reference the database. Most operations are via this App. Most others just use the DB for lookup purposes. (There is a small amount of updating from some of these apps) Q1) What are the benefits of upgrading to Version 9. ( Dont afraid to be too technical) Q2) We received a quotation of close to a million Euro for such an upgrade. We currently have a 128 user licence agreement with IBM/Informix. Is this consistent with your own experiences ? Rgds, John. The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised.if you are not the intended recipient, any disclosure, copying, distribution, or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. Please note that any views, opinions or advice contained in this email are those of the sending individual and not necessarily those of the firm. It is possible for data transmitted by e-mail to be deliberately or accidentally corrupted or intercepted. For this reason, where the communication is by e-mail, J&E Davy does not accept any responsibility for any breach of confidence which may arise from the use of this medium. If you have received this e-mail in error please notify us immediately at mailto:helpdesk@davy.ie and delete this e-mail from your system. ********************************************************************** Privileged/Confidential information may be contained in this message. If you are not an addressee indicated in this message (or responsible for delivery of the message to such person[s]), you may not copy or deliver this message to anyone. If you have received this message in error, you should destroy and delete it from your computer and notify the sender by reply email. Opinions, conclusions and other information in this message that do not relate to the official business of Diversified Collection Services shall be understood as neither given nor endorsed by the company. Accordingly, Diversified Collection Services disclaims all responsibility and accepts no responsibility for the consequences of any person(s) acting, or refraining from acting, on such information prior to the receipt by that person(s) of subsequent written confirmation. **********************************************************************