Re: Standard Engine
On Sep 6, 3:37 am, "Neil Truby" <neil.tr...@ardenta.com> wrote: > "Neil Truby" <neil.tr...@ardenta.com> wrote in message > > news:5jtt59F17lkhU1@mid.individual.net... > > >I urgently need the media for recent SE on Linux. Can anyone help? > > Thanks to Goradz, and to Cats for pointing out where the media is freely > available for download. > > I've visited the customer who has an elderly green-screen > 4GL-on-Standard-Engine system. Strategically they are moving away from > Informix. What benefits, other than the ability to take online backups, can > I offer them to move to IDS? Online archiving HDR Replication ER Data Distribution and Gathering RSS and SDS servers for load balancing Virtually unlimited server capacity (4PB) Parallel query processing for complex queries Additional data types Business logic in the database engine through UDRs User defined types to better map business objects XML integration for improved WEB product publishing SQL-92+ syntax extensions Horizontal table partitioning (fragmentation) to improve performance for large tables Simplified/faster history cleanup (detach fragment) Integration with all IBM development tools for faster response to requirements Art S. Kagel
"Art S. Kagel" <art.kagel@gmail.com> wrote in message news:1189089164.024422.134840@19g2000hsx.googlegroups.com... > On Sep 6, 3:37 am, "Neil Truby" <neil.tr...@ardenta.com> wrote: >> "Neil Truby" <neil.tr...@ardenta.com> wrote in message >> >> news:5jtt59F17lkhU1@mid.individual.net... >> >> >I urgently need the media for recent SE on Linux. Can anyone help? >> >> Thanks to Goradz, and to Cats for pointing out where the media is freely >> available for download. >> >> I've visited the customer who has an elderly green-screen >> 4GL-on-Standard-Engine system. Strategically they are moving away from >> Informix. What benefits, other than the ability to take online backups, >> can >> I offer them to move to IDS? > > Online archiving > HDR Replication > ER Data Distribution and Gathering > RSS and SDS servers for load balancing > Virtually unlimited server capacity (4PB) > Parallel query processing for complex queries > Additional data types > Business logic in the database engine through UDRs > User defined types to better map business objects > XML integration for improved WEB product publishing > SQL-92+ syntax extensions > Horizontal table partitioning (fragmentation) to improve performance > for large tables > Simplified/faster history cleanup (detach fragment) > Integration with all IBM development tools for faster response to > requirements I should have made it clearer that this is a small shop who are happy enough with their SE system until they can move away from IBM. Of the above I guess Online Archiving is the only one really likely to appeal. A useful list for other, bigger, more committed-to-IBM sites though, so thanks for that.
On 6 Sep, 15:56, "Neil Truby" <neil.tr...@ardenta.com> wrote: > "Art S. Kagel" <art.ka...@gmail.com> wrote in messagenews:1189089164.024422.134840@19g2000hsx.googlegroups.com... > > > > > > > On Sep 6, 3:37 am, "Neil Truby" <neil.tr...@ardenta.com> wrote: > >> "Neil Truby" <neil.tr...@ardenta.com> wrote in message > > >>news:5jtt59F17lkhU1@mid.individual.net... > > >> >I urgently need the media for recent SE on Linux. Can anyone help? > > >> Thanks to Goradz, and to Cats for pointing out where the media is freely > >> available for download. > > >> I've visited the customer who has an elderly green-screen > >> 4GL-on-Standard-Engine system. Strategically they are moving away from > >> Informix. What benefits, other than the ability to take online backups, > >> can > >> I offer them to move to IDS? > > > Online archiving > > HDR Replication > > ER Data Distribution and Gathering > > RSS and SDS servers for load balancing > > Virtually unlimited server capacity (4PB) > > Parallel query processing for complex queries > > Additional data types > > Business logic in the database engine through UDRs > > User defined types to better map business objects > > XML integration for improved WEB product publishing > > SQL-92+ syntax extensions > > Horizontal table partitioning (fragmentation) to improve performance > > for large tables > > Simplified/faster history cleanup (detach fragment) > > Integration with all IBM development tools for faster response to > > requirements > > I should have made it clearer that this is a small shop who are happy enough > with their SE system until they can move away from IBM. Of the above I > guess Online Archiving is the only one really likely to appeal. A useful > list for other, bigger, more committed-to-IBM sites though, so thanks for > that.- Hide quoted text - > > - Show quoted text - When a host crashes SE does not do any type of recovery afterwards. Great for getting corrupt indexes that do not match the data, also a great way to get duplicate values in a unique index. Online does Fast Recovery when it starts and so recovers from a machine crash gracefully. Online checks page timestamps to ensure what is read is consistent and has not been corrupted.