DB2 UDB LUW
DB2 was the name given to IBM's first DBMS (Database management System) in 1983 when IBM released DB2 on MVS mainframe platform. It ranks 6 in the overall DB rankings and rank 5 in Relational DB Rankings. DB2 provide most of the features as other RDBMS and is cheaper in cost compared to other competitors in market with its Standard edition costing $7500 and Enterprise edition $25000.
The latest version of IBM DB2 available in market is DB2 V.10.5 Pure Scale. IBM DB2 is available to download in LUW (LINUX, UNIX and WINDOWS), Z/OS and I/OS environments. DB2 is available when you buy a I-Series server sold by IBM and It claims to be cheap alternative to install DB2.
IBM DB2 and oracle are very compatitive. Oracle directly supports java application server where you can install java servlets where as DB2 needs java translators like TOMCAT. Oracle has more third party support and features compared to DB2 but most of those short comings can be overcome by installing some third party software. DB2 very high end scalability and very good in warehousing environments.
The SQL of IBM DB2 supports simple block and dimension block indexes but partial indexes are not supported. IBM DB2 SQL Supports upto 65535 lines of statement query and upto 28 recursive sub queries. It supports upto 16 columns in an index key and longest index key being 1024.The Maximum row length of table is 32677.
