Re: 6.0 INFORMATION (fwd)

} } In article <1tb27vINNqeg@emory.mathcs.emory.edu> you write: } >Are there RELEASE NOTES available yet for the common folk? } > } Mike: we spoke yesterday, and I am mailing you the "Info Sheet" } of which I spoke. Some highlights: } } Informix-OnLine 6.0 Dynamic Server Features: } } * Multithreaded Architecture - improves throughput on symmetric } multiprocessing (SMP) systems by processing requests } concurrently using a pool of database server processes } to distribute tasks among multiple CPU's. This pool is } dynamically configrable by a DBA. } } * Parallel Index Build - CREATE INDEX statements will run much } faster due to algorithmic improvements and parallel } processing. Data is partitioned into subtasks which are } processes in parallel. } } * Table/Database Archive and Restore - DBA's using OnLine can } specify which dbspaces they want to archive and which } ones to restore. A dbspace can be composed of single/. } multiple tables/databases. } } * Archive and Tape Management - OnLine DBA's can schedule unattended } archives and transaction log backups via a munu-driven } interface. OnLine will automatically perform all archives } without the need for an administrator to be present. } } * Data Replication - DBA's can implement the high level of disaster } recovery that is critical fo OLTP applications. } } * System Monitoring Interface - allows on OnLine site to manage } multiple, distributed OnLine sites and provides valuable } information to the DBA. } } * Cascading Deletes - enforce the relational database rule that when } a parent record is deleted, all children records (if any) are } also deleted. } } * Removal of limits - # of users (threads), logical logs, chunks and } dbspaces have been increased to 32,767 (subject to OS limits, } of course). # of buffers have increased from 40,000 to 512,000. } } * Secure Auditin - provides traceability and accountability for any } database object manipulated; DBA's can account for any action } taken on an OnLine system at the user level. } OnLine and SE 6.0: } } * Improved Query Optimization - the cost-based optimizer will now } be provided with more detailed information regarding the } distribution of index keys within the tables; this allows } filter selections to be more accurately calculated, thereby } improving the optimizer's choice of an execution path for } } * Built-In Client/Server and Distributed Database Capabilities - } I-Net and I-Star are now built into the SE and OnLine } architectures to allow for maximum client/server and } } OnLine, SE and C-ISAM 6.0: } } * X/Open Native Language Support } } There's more, but hopefully this will get you started. } } Bill Tucker } Informix Software, Inc. } Lenexa, KS Thanx Bill regards, Mikea