IBM to unveil Stinger soon

IBM announced today the open beta of the next version of its DB2 Universal Database, code named Stinger. According to Big Blue, the new software is designed to help customers simplify and automate the maintenance of databases and developing enterprise applications.

  • E-Mail
By  Maddy Reddy Published  June 6, 2004

IBM announced today the open beta of the next version of its DB2 Universal Database, code named Stinger. According to Big Blue, the new software is designed to help customers simplify and automate many of the tasks associated with maintaining databases and developing enterprise applications. “This new software delivers 200 new features that fundamentally ease database administration, broaden support for popular application development environments and boost system performance. It will make it possible for database administrators (DBA) to complete complex jobs 6.5 times faster than if done manually,” says Bashar Kilani, manager of IBM Software Business, Middle East, Egypt and Pakistan. Key features include: deploying, configuring, maintaining and optimising DB2 on the fly; support for 3-D geospatial data that is location and time-space aware that enables customers in industries including government and transportation to build spatial applications and automatic partitioning and optimisation of large databases much faster, than existing databases. The vendor cites two recent reports from Meta Group, which state that autonomic databases can reduce the labor intensive, mundane tasks traditionally performed by DBAs, such as problem solving, monitoring and tuning, by up to 80%. IBM claims its new DB2 Design Advisor that automatically maintains, configures, deploys and optimises the database, making it possible to complete jobs 6.5 times faster than if done manually. Stinger is also the first deployment of new query optimisation technology from IBM's LEO (learning optimiser) research and development project. With LEO, DB2 can now automatically and continually update query statistics about how the database is being used, where it keeps information and how it is performing. As a result, DB2 now automatically creates and executes better plans for accessing data without prompting the DBA to take action. Additionally, IBM is introducing Autonomic Object Maintenance. This new feature automatically performs administration and maintenance functions, such as table adjustments or data back-ups. For example, a DBA specifies what time the database should do its maintenance, the database then considers its workload with the DBA's time suggestion, and automatically performs its maintenance tasks. The autonomic features are also offered in the Express edition of Stinger, targeted at the small and medium-size customers, with small IT staffs and limited technical understanding, which normally spend 65% for routine tasks says IBM. Stinger supports all major development platforms such as Java and Microsoft .NET. Also of interest to developers is support by Stinger for larger SQL statement sizes, up from 64 kilobytes to 2 megabytes, commonly demanded by third-party applications today. For mobile employees, Stinger will include DB2 Everyplace, which extends access to enterprise data to ‘occasionally-connected’ users on mobile, wireless, and handheld devices allowing users to access real-time data anytime and anywhere. DB2 Everyplace gives mobile workers the ability to query, retrieve, and modify information from DB2 and databases from competing vendors such as Oracle, Microsoft and MySQL. The new DB2 version will also support version 2.6 of the Linux kernel for running database clusters ranging from two to 1000 servers. Support for the new kernel better exploits the speed of 64-bit-ready databases, such as DB2, and enables Linux databases to take better advantage of servers that use multiple processors. DB2 now supports all four of IBM's server platforms running Linux, as well as other servers built on Intel and AMD 64-bit processors. Stinger is expected to ship in the fourth quarter of this year.

Add a Comment

Your display name This field is mandatory

Your e-mail address This field is mandatory (Your e-mail address won't be published)

Security code