Re: Running Informix on 2 different Servers in parrallel
Neil, other than the holiday, how about all the following which are available in 9.40 .... Improved Performance 8-15%better in internal benchmarks;Fuzzy Checkpoints;Shared Statement Cache;New Buffer Management System;B-Tree Scanner;Improved Replication Perf; Increased Scalability;Data capacity of a single instance 128 PB;Support for more CPUs;Improved support for large objects;Higher Availability/Reliability;Restartable Fast Recovery;Improved Rollback Performance;Dynamic Log Creation;Improved Enterprise Replication (ER);ER / HDR InteroperabilityEnhanced Security ;Secure over-the-wire encryption using OpenSSL encryption libraries;Configurable user authentication mechanisms using Pluggable Authentication Modules (PAMs);More permission check upon start-up;Simplified Administration ;Redirected Restore;Full use of Tapes;Rename Chunks;New Unix Bundle Installer;No libraries in /usr/lib;Order of install;Add Chunks when first chunk is full;Onstat enhancements;Explain enhancements;Log Management;Dynamic Lock Allocation;Easier Application development ;SQL language enhancements;Expanded Unicode support;Improved Extensibility;Enhanced API ;Native .Net Provider; LRU_MIN_DIRTY & LRU_MAX_DIRTY; Dynamic Adding of Logical Log; SmartBlob Spooling Queue; Spooling Threads; Utilities all compiled to handle large files;Redirected Restore; Rename Chunks During Restore; Add Chunks When First Chunk of Root DBSpace is Full;Enhanced Diagnostics; OnStat Enhancements; Explain Can be turned on Dynamically; Support for Long Identifiers;Updated Unicode Support;Sequences;Triggers on Select and Views;Order by not in select list;ANSI SQL-99 Joins;Describe input;Unions in Sub-queries;Names for Return Values;Multiple OUT parameters;Improved support for long character strings;Multi-nationalization; Collections;Table Functions;Virtual Table interface;User Definded Data Types;High-Performance Programming Support;Built-in functions for handling complex data;Datablade Support;Enhanced APIs; JDBC;OLE DB;ODBC ESQL/C;Even More Platform Support;Quality Neil Truby wrote: > "Art S. Kagel" <kagel@bloomberg.net> wrote in message > news:41BF66EE.1090103@bloomberg.net... > > > Don't go windows, you already know UNIX, go with Linux. There are many > > excellent releases of Linux and IDS runs very well on them. You will not > > be able to get IDS 7.20 (which BTW is very old, out of support, and not > > even Y2K compliant). But you could build the new server, port everything > > there, and make that the new main box while building a new backup box, > > also running Linux. I'd recommend going to IDS 9.40UC5 or later. > > As a matter of interest, now that IBM has extended the end-of-support to v7, > why would you recommend a user on a very old version of v7, by all accounts > not very innovative, move to v9? Not saying your wrong but one of my users > asked me the same question today: "Why should I move to v9 if I'm happy on > v7?". "To help pay for my holiday in The Maldives" is the actual answer, > but didn't seem politic, so I said I'd think about it. Thing is, I'd like > to sure I'm not missing anything before replying. For a user who is > comfortable with v7, does not want to use user-defined datatypes or > datablades (in my experince, 90%++ of them), and whose database is modest > enough in size that the 2G chunk limit is not a major inconvenience, what > other imperatives are there? > > cheers > Neil
wcottishpoet wrote: > Neil, > > other than the holiday, how about all the following which are available > in 9.40 .... > > > Improved Performance 8-15%better in internal benchmarks;Fuzzy > Checkpoints;Shared Statement Cache;New Buffer Management System;B-Tree > Scanner;Improved Replication Perf; Increased Scalability;Data capacity > of a single instance 128 PB;Support for more CPUs;Improved support for > large objects;Higher Availability/Reliability;Restartable Fast > Recovery;Improved Rollback Performance;Dynamic Log Creation;Improved > Enterprise Replication (ER);ER / HDR InteroperabilityEnhanced Security > ;Secure over-the-wire encryption using OpenSSL encryption > libraries;Configurable user authentication mechanisms using Pluggable > Authentication Modules (PAMs);More permission check upon > start-up;Simplified Administration ;Redirected Restore;Full use of > Tapes;Rename Chunks;New Unix Bundle Installer;No libraries in > /usr/lib;Order of install;Add Chunks when first chunk is full;Onstat > enhancements;Explain enhancements;Log Management;Dynamic Lock > Allocation;Easier Application development ;SQL language > enhancements;Expanded Unicode support;Improved Extensibility;Enhanced > API ;Native .Net Provider; LRU_MIN_DIRTY & LRU_MAX_DIRTY; Dynamic > Adding of Logical Log; SmartBlob Spooling Queue; Spooling Threads; > Utilities all compiled to handle large files;Redirected Restore; Rename > Chunks During Restore; Add Chunks When First Chunk of Root DBSpace is > Full;Enhanced Diagnostics; OnStat Enhancements; Explain Can be turned > on Dynamically; Support for Long Identifiers;Updated Unicode > Support;Sequences;Triggers on Select and Views;Order by not in select > list;ANSI SQL-99 Joins;Describe input;Unions in Sub-queries;Names for > Return Values;Multiple OUT parameters;Improved support for long > character strings;Multi-nationalization; Collections;Table > Functions;Virtual Table interface;User Definded Data > Types;High-Performance Programming Support;Built-in functions for > handling complex data;Datablade Support;Enhanced APIs; JDBC;OLE DB;ODBC > ESQL/C;Even More Platform Support;Quality Cribbed from a powerpoint slide, complete with typo. "Definded" indeed! Let alone one or two odd bits of grammar (even for a bullet list), and odd spacing, and ... The slide puts each phrase onto the screen, slowly, highlight the current phrase and then fading a bit. Quite pretty, annoyingly slow. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/
neil asked the question "why move to 9 if you don't want your own datatypes" This list contains a host of reasons. OK its from a powerpoint presentation and it has few grammer problems. I wasn't going to post the 6Mb worth of powerpoint presentation that more of the detail behind this. if anyone wants to come to Bedfont I'd be happy to present it to them. maybe the UK User gorup could have this at their next meeting? Jonathan Leffler wrote: > wcottishpoet wrote: > > Neil, > > > > other than the holiday, how about all the following which are available > > in 9.40 .... > > > > > > Improved Performance 8-15%better in internal benchmarks;Fuzzy > > Checkpoints;Shared Statement Cache;New Buffer Management System;B-Tree > > Scanner;Improved Replication Perf; Increased Scalability;Data capacity > > of a single instance 128 PB;Support for more CPUs;Improved support for > > large objects;Higher Availability/Reliability;Restartable Fast > > Recovery;Improved Rollback Performance;Dynamic Log Creation;Improved > > Enterprise Replication (ER);ER / HDR InteroperabilityEnhanced Security > > ;Secure over-the-wire encryption using OpenSSL encryption > > libraries;Configurable user authentication mechanisms using Pluggable > > Authentication Modules (PAMs);More permission check upon > > start-up;Simplified Administration ;Redirected Restore;Full use of > > Tapes;Rename Chunks;New Unix Bundle Installer;No libraries in > > /usr/lib;Order of install;Add Chunks when first chunk is full;Onstat > > enhancements;Explain enhancements;Log Management;Dynamic Lock > > Allocation;Easier Application development ;SQL language > > enhancements;Expanded Unicode support;Improved Extensibility;Enhanced > > API ;Native .Net Provider; LRU_MIN_DIRTY & LRU_MAX_DIRTY; Dynamic > > Adding of Logical Log; SmartBlob Spooling Queue; Spooling Threads; > > Utilities all compiled to handle large files;Redirected Restore; Rename > > Chunks During Restore; Add Chunks When First Chunk of Root DBSpace is > > Full;Enhanced Diagnostics; OnStat Enhancements; Explain Can be turned > > on Dynamically; Support for Long Identifiers;Updated Unicode > > Support;Sequences;Triggers on Select and Views;Order by not in select > > list;ANSI SQL-99 Joins;Describe input;Unions in Sub-queries;Names for > > Return Values;Multiple OUT parameters;Improved support for long > > character strings;Multi-nationalization; Collections;Table > > Functions;Virtual Table interface;User Definded Data > > Types;High-Performance Programming Support;Built-in functions for > > handling complex data;Datablade Support;Enhanced APIs; JDBC;OLE DB;ODBC > > ESQL/C;Even More Platform Support;Quality > > > Cribbed from a powerpoint slide, complete with typo. "Definded" > indeed! Let alone one or two odd bits of grammar (even for a bullet > list), and odd spacing, and ... > > The slide puts each phrase onto the screen, slowly, highlight the > current phrase and then fading a bit. Quite pretty, annoyingly slow. > > -- > Jonathan Leffler #include <disclaimer.h> > Email: jleffler@earthlink.net, jleffler@us.ibm.com > Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/