In terms of new functionality for developers, DB2
11 offers global variables (for passing data from program to program), improved SQLPL functionality, Alias support for sequence objects, improvements to Declared Global Temporary Tables (DGTTs), views on temporal data, XML improvements (including XQuery support), and a SQL Compatibility feature which can be used to minimize the impact of new version changes on existing applications.
Performance Information on SQL Coming to DB2
through DDF -- Compuware Strobe DB2
DDF support identifies dynamic and static SQL statements executing within the DDF address space so that users can see what SQL ran on behalf of a particular location.
IBM is excited that DB2
and WebSphere solutions have been chosen to help OSDN elevate the quality of service received by SourceForge.
Uptake for DB2
LUW has surged in recent years, and many DBAs find themselves charged with managing disparate DB2
platforms for the first time," said Billy Bosworth, vice president and general manager, Enterprise Database business unit, Quest Software.
The complete results of Edison Group's "Comparative Management Cost Study: Oracle Database 10g and IBM UDB DB2
The new product offerings for DB2
Universal Database for Linux will be generally available on December 15, 2000.
The xfy Enterprise Solution for IBM DB2
gives us the ability to reuse data at the client side, and it is easy to customize.
2 of Archive for DB2
includes new offline delete options and enhanced Large Object (LOB) handling that improves performance by more than 25 percent.
Connects to IBM DB2
and all major relational databases
Additionally, the Arkeia DB2
plug-in includes a "userexit" feature that utilizes push technology to automatically initiate client-side archive log backup.
IBM's rigorous certification process ensures xfy's seamless integration with the DB2
data server environment, making it painless and cost effective for organizations to put the full power of XML technology at their fingertips," said Hideki Hiura, chief scientist and CTO, JustSystems.
With DETAIL and DB2
Information Integrator, a business can drive more value from existing information assets with real-time information integration, lowering the total cost of ownership and increasing return on investment," said Lauren Flaherty, vice president of marketing, IBM Data Management Solutions.
IntelliVIEW Designer and Report Analyzer for DB2
Express-C have been specifically designed to support IBM's DB2
community initiative and operate seamlessly with DB2
With this announcement, BMC Software delivers complete integrated SmartDBA Performance, Administration, and Recovery management solutions for DB2
"Developer in a Box" freeware offering also includes the IBM DB2