[permalink] [id link]
The DB2 LUW product runs on multiple Linux and UNIX distributions, such as Red Hat Linux, SUSE Linux, AIX, HP / UX, and Solaris, and most Windows systems.
from
Wikipedia
Some Related Sentences
DB2 and LUW
There are three DB2 products that are very similar, but not identical: DB2 for LUW ( Linux, Unix, and Windows ), DB2 for z / OS ( mainframe ), and DB2 for iSeries ( formerly OS / 400 ).
DB2 also powers the IBM InfoSphere Warehouse edition, which is basically DB2 LUW with DPF ( Database Partitioning Feature ), a massive parallel share-nothing data warehousing architecture.
An earlier version of the code that would become DB2 LUW ( Linux, Unix, Windows ) was part of an Extended Edition component of OS / 2 called Database Manager.
This DB2 edition was eventually ported to all Linux, UNIX, and Windows ( LUW ) platforms and was renamed to DB2 Extended Enterprise Edition ( EEE ).
In June 2009, IBM announced " Cobra " ( the codename for DB2 9. 7 for LUW ).
DB2 and product
2001 – Quest entered the Microsoft management market by acquiring Fastlane Technologies, and broadened its database offerings beyond Oracle with a new product for the IBM DB2 database.
Informix is often compared to IBM's other major database product, DB2, which is offered on the mainframe Z series platform as well as on Unix and Linux.
In 2001, IBM bought Informix Software and in the following years incorporated Informix technology into the DB2 product suite.
IBM lawyers stopped this handy naming convention from being used and decided that all products needed to be called " product FOR platform " ( for example, DB2 for OS / 390 ).
IBM now refers to this product as the Database Partitioning Feature ( DPF ) and sells it as an add-on to their flagship DB2 Enterprise product.
DB2 for z / OS ( the mainframe ) is available in its traditional product packaging, or in the Value Unit Edition, which allows customers to instead pay a one-time charge.
In 2006 IBM stepped up its competition in the emerging data warehouse appliance market by releasing a product line of pre-configured hardware / software systems combining DB2 Data Warehouse Edition with either IBM system p ( AIX ) or IBM system x ( Linux ) servers.
Both companies were struggling against IBM and its DB2 product offering.
The DataFlex product supports many database environments: Oracle, MS-SQL, IBM DB2, MySQL and Pervasive SQL as well as any ODBC database.
Until late 2005 IBM also marketed the product — as DB2 OLAP Server.
8. 00 expanded support for direct use of spatial DBMS beyond Oracle to include IBM DB2 with Spatial Extender, PostgreSQL / PostGIS and pre-releases of Microsoft's SQL Server 2008 spatial product available in 2007.
DB2-As a major internally developed product, DB2 contains its own direct connection into the TSM API.
DB2 and runs
DB2 Express-C runs on 32 and 64bit Windows, Linux on x86, x64 and POWER processors, Solaris on x64 CPU and Intel machines running Mac OS X.
DB2 and on
The name DB2 was first given to the Database Management System or DBMS in 1983 when IBM released DB2 on its MVS mainframe platform.
For some years DB2, as a full-function DBMS, was exclusively available on IBM mainframes.
Later IBM brought DB2 to other platforms, including OS / 2, UNIX and MS Windows servers, then Linux ( including Linux on zSeries ) and PDAs.
The new version of Database Manager, called DB2 like its mainframe parent, ran on the OS / 2 and RS / 6000 platforms, was called DB2 / 2 and DB2 / 6000 respectively.
Over the years DB2 has both exploited and driven numerous hardware enhancements, particularly on IBM System z with such features as Parallel Sysplex data sharing.
In fact, DB2 UDB Version 8 for z / OS now requires a 64-bit system and cannot run on earlier processors, and DB2 for z / OS maintains certain unique software differences in order to serve its sophisticated customers.
In the mid-1990s, IBM released a clustered DB2 implementation called DB2 Parallel Edition, which initially ran on AIX.
In mid 2006, IBM announced " Viper ," which is the codename for DB2 9 on both distributed platforms and z / OS.
In October 2007, IBM announced " Viper 2 ," which is the codename for DB2 9. 5 on the distributed platforms.
IBM based the design of DB2 pureScale on the Parallel Sysplex implementation of DB2 data sharing on the mainframe.
This allows users on the System i platform to natively access the DB2 under the IBM i operating system ( formerly called OS / 400 ), and for users on other platforms to access these files through the MySQL interface.
* When compared to running on DB2 9, depending on the workload, customers may experience reduced CPU utilization
DB2 and multiple
Features include a RDBMS ( DB2 / 400 ), a menu-driven interface, support for multiple users, dumb terminal support ( IBM 5250 ), and printers.
This edition allowed scalability by providing a shared nothing architecture, in which a single large database is partitioned across multiple DB2 servers that communicate over a high-speed interconnect.
DB2 DPF lets you partition your database across multiple servers or within a large SMP server, which is ideal for Online Analytical Processing ( OLAP ) workloads.
DB2 and Linux
DB2 for Linux, Unix and Windows has three separate editions: IBM DB2 Express-C, Workgroup Server Edition, and Enterprise Server Edition.
DB2 Express-C, however, is based on the same code as other DB2 for Linux, Unix and Windows editions and is not open source.
Oracle is attracting customers to its Linux on System z products, although apparently not at the expense of DB2.
* DB2 for Linux, UNIX, and Windows documentation
Despite heavy competition from other server platforms, IBM's zSeries has enjoyed a resurgence due to the widespread adoption of Linux and the escalating transaction volumes ( in CICS, IMS, DB2, and other mainframe subsystems ) brought about by e-business growth.
Server platform technology supported in current releases includes Linux, Microsoft Windows, Solaris, AIX, HP-UX and OpenVMS plus Oracle, DB2, SQL Server, PostgreSQL, Pervasive SQL, RMS, VSAM and C-ISAM.
Users can get up to speed quickly on the most critical technologies affecting their profession, like open, industry-standard technologies such as Java, Linux, SOA and web services, web development, Ajax, PHP, and XML, as well as learn about IBM's software products ( WebSphere, Rational, Lotus, Tivoli and DB2 ).
K42 currently supports the Linux PPC64 and PPC32 ABIs, so most PowerPC Linux binaries can run on K42 without modification, including the DB2 relational database.
0.196 seconds.