X-Nico

12 unusual facts about IBM DB2


Advanced Query Tool

Data Base Management Systems of which AQT is aware of the catalog structure include IBM DB2, Oracle, Microsoft SQL Server, Postgres, MySQL, Sybase, and Informix.

Crystal Analysis

The initial rewrite only supported Microsoft Analysis Services, but support for other vendors soon followed, with Holos cubes in version 8.5, Essbase, IBM DB2 and SAP BW following in later releases.

DB2

IBM DB2, in computing, a relational database management system, more recently called a "data server" by IBM

Dclgen

A declarations generator or DCLGEN (pronounced dekel-jin) is a table schema used by COBOL programs that work against a database, often IBM DB2 on a mainframe.

Electronic discovery

The most common are Relational Database Management Systems (RDBMS) that are capable of handling large volumes of data such as Oracle, IBM DB2, Microsoft SQL Server, Sybase, and Teradata.

Forte 4GL

Being an enterprise application development system, Forté 4GL supported close linkage to a number of different relational database systems, including Oracle, Sybase, Microsoft SQL Server, Informix, and DB2.

HLP-SMILE

Customers have also reported running the software on DB2 or Microsoft SQL.

IBM DB2 Commonstore

Part of the IBM Information Management portfolio which builds upon the DB2 database platform.

IBM Scalable Architecture for Financial Reporting

SAFR can access multiple types of mainframe-based data, including DB2.

InfiniBand

In 2009, IBM announced a December 2009 release date for their DB2 pureScale offering, a shared-disk clustering scheme (inspired by parallel sysplex for DB2 z/OS) that uses a cluster of IBM System p servers (POWER6/7) communicating with each other over an InfiniBand interconnect.

Million service units

“You will need 8 more DB2 MSUs for your z900 to handle this year’s Christmas sales rush. Since your current z900 configuration doesn’t have enough capacity to add 8 DB2 MSUs, you need to add another engine. It might be less expensive to upgrade to a z9 because of the double technology dividend.”

Z/Journal

Its publisher, Thomas Communications, Inc., also publishes the Xephon Update series of mainframe-based newsletters on DB2, CICS, z/OS (formerly MVS), WebSphere (formerly MQ), TCP/SNA, RACF, and AIX.


IBM Advanced Program-to-Program Communication

Major IBM software products have included support for APPC, including CICS, DB2, CIM, WebSphere MQ, VM, and MVS.

Infodata

A full decade before Oracle, Access, Alpha Five, dBASE, DB2, and other DBMS programs were available, Infodata had a working database solution.

NetVault Backup

An enterprise solution, it supports many server, application platforms and protocols such as UNIX, Linux, Mac OS X, Microsoft Windows, VMware, Microsoft Hyper-V, Oracle, Sybase, Microsoft SQL Server, NDMP, Oracle ACSLS, IBM DAS/ACI, Microsoft Exchange Server, DB2, Informix, MySQL, Lotus Domino, and Teradata.

PhpCodeGenie

It can communicate with multiple databases such as: MySQL, PostgreSQL, ODBC, SQLite, Oracle, DB2, MS SQL Server, MaxDB, Visual FoxPro, FrontBase, InterBase, Firebird, Informix, LDAP, Netezza, SAP DB, Sybase, and generate code from them.