DB2


Also found in: Dictionary, Thesaurus, Medical, Acronyms, Wikipedia.

DB2

(database)
A relational database from IBM.

When running under IBM's MVS (Multiple Virtual Storage) operating system, DB2 is implemented on top of VSAM and uses its underlying data structures.

DB2, later called "DB2 Universal DataBase", also runs under windows NT, AIX, Solaris and, most recently, Linux.

DB2

(DATABASE 2) A relational DBMS from IBM that was originally developed for its mainframes. Introduced in 1983, DB2 is a full-featured SQL-based DBMS that became IBM's major database product. Known for its industrial strength reliability, IBM subsequently made DB/2 available for all of its own platforms as well as Linux, Unix (Solaris, HP-UX) and Windows.

DB2 UDB (Universal Database)
In 1996, IBM introduced an enhanced DB2 version that combined relational and object database technology as well as various query optimization techniques for parallel processing. It was also the first DB2 version optimized for the Web. The terms "DB2" and "DB2 UDB" are used synonymously.
References in periodicals archive ?
There is also the new APREUSE(WARN) BIND option, which causes DB2 to try to reuse previous access paths for SQL statements, but does not prevent the bind (or rebind) when access paths cannot be reused.
Customers with distributed applications and third-party products, such as PeopleSoft and SAP, are using the mainframe DB2 database as their data repository.
A trial version of Quest Management Suite for DB2 LUW can be downloaded at http://www.
IBM, DB2, pureXML and the IBM e-business logo are trademarks or registered trademarks of International Business Machines Corporation.
As an essential component of ILM, Archive for DB2 provides on-demand access and capabilities for storing archived data to the most cost-effective and appropriate medium: online in an archive database, near-line on a file server, offline to tape, disk-based WORM device or long-term permanent storage, such as EMC Centera(tm) and NetApp NearStore(tm) with SnapLock(tm).
With deep integration of its database-enabled tools with DB2 9 already in development, Altova recommends the purchase of the Support and Maintenance Package (SMP) with all software purchases.
Our team has developed a plug-in that integrates smoothly into the DB2 processes," said Arkeia CEO Phil Roussel.
The "Ready for IBM DB2 Data Server Software" program is a process designed for independent software vendors (ISVs) and solution integrators to validate and certify their products for compatibility for IBM DB2.
Combining DETAIL with IBM DB2 Information Integrator enables organizations of all kinds to give their critical applications transparent access to diverse, distributed, and real-time data.
As a commitment to our long-standing relationship with IBM and in support of the IBM DB2 Express-C initiative, we are happy to announce a Community Edition of the IntelliVIEW Report Designer and Report Analyzer for DB2 Express-C users," said Madan Kumar, CEO of Synaptris.
BMC's extension of its Oracle data management offerings to the DB2 UDB platform provides a better means for us to manage these disparate systems.
Toad for DB2 brings additional value to IBM DB2 customers who have previous experience with Oracle and other data servers, expanding the value of their existing skill sets," said Bernie Spang, director, IBM Data Servers.