DB2 for i (formerly known as DB2 for i5/OS) is an advanced, 64-bit Relational Database Management System (RDBMS) that leverages the high performance, virtualization, and energy efficiency features of IBM's Power Systems. A member of IBM’s leading edge family of DB2 products, DB2 for i supports a broad range of applications and development environments at a low cost of ownership due to its unique autonomic computing (self-managing) features.
Smarter Computing: DB2 is built into IBM i
No need to purchase a separate database product. With DB2 for i, it’s already there as the core element of the IBM i operating system. The tight integration of DB2 and IBM i provide unique benefits that allow you to concentrate on running your business while maintaining the mainframe-like reliability and security that mid-market companies demand as well. Features such as the Single Level Storage architecture and the sophisticated cost base query optimizer built into DB2 for i are just some of the attributes of the self managing, self tuning aspects that account for automation of many of the common database administrator tasks required by other database management systems.
DB2 for i leverages the virtualization and large scaling capabilities of the IBM Power System platform, including Dynamic Logical Partitioning, Capacity Upgrade on Demand, and PowerVM virtualization to simply and quickly respond to changing workloads to ensure business continuity in a dynamic environment. DB2’s sophisticated cost-based query optimizer, unique single level storage architecture, SMP parallelism and IBM patented Encoded Vector Indexing allow the database to scale near linearly within a single server configuration. DB2 for i also leverages the large memory configurations of Power Systems with in-memory database technologies to speed up SQL processing. The unique Single Level Storage architecture and DB2 media preference functions allow for an easy and efficient implementation of solid state drive (SSD) hierarchical storage devices.
DB2 for i is unique in its ability to preserve investments in legacy applications, while supporting the latest in SQL-based application and integration technologies. Combine the XML integration functions and Omnifind text search engine to open up data in DB2 to new levels of integration and access. Feel comfortable that you can protect sensitive data with the ability to transparently encrypt data at the database column or disk level. Build new applications in Java, .NET, PHP or RPG with the knowledge that your data is safe and secure!