Systems

Essay by EssaySwap ContributorUniversity, Master's February 2008

download word file, 1 pages 0.0

Downloaded 460 times

WHAT IS DB2 UDB and HOW WIDELY USED DB2 UDB is a popular and widely used relational database developed by IBM. It is IBM¡¯s relational database server solution for the UNIX, OS/2 and Windows NT/2000 operating environments. DB2 UDB builds upon the stability and performance of DB2 on the mainframe and provides the features required in a distributed database product.

The DB2 family has grown immensely in the last few years with its foundation well established in being the most scalable and reliable database in the industry. There are many versions of this product in the marketplace, but the newest is the DB2 UDB version 7, which has been designed from the ground up for Dot Coms. DB2 UDB has more than 16,000 vendor applications available (such as Siebel, SAP, and PeopleSoft) and has become the database of choice for database solutions. As the IBM web-site states, ¡°More than 70% of the world¡¯s major companies rely on DB2 UDB to manage their mission-critical business applications¡± (IBM web-site, DB2 Universal Database).

WHAT TYPE OF DATABASE/DATA WAREHOUSE DB2 UDB BELONGS and WHAT PLATFORM or ENVIRONMENT IT RUNS ON DB2 UDB is an Object-Oriented/Relational Data Warehouse database that supports multimedia extensions. The DB2 Product family runs on a multitude of platforms. It runs on non-IBM machines such as Sun and Hewlett-Packard as well as IBM hardware, and operating systems such as Windows (Microsoft), Linux, UNIX, and Sun¡¯s Solaris Operating Environment. It works across the HP-UX, NUMA-Q, AIX, OS/2 platforms as well as handheld device operating systems such as Windows CE* and the Palm Computing* platform (IBM web-site, DB2 Product Family). Additionally, DB2 UDB runs on the Satellite Edition, AS/400, and OS/390 platforms and has many versions including Versions 2, 5, 6, and 7.