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.

Scalability

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.

Investment protection

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!

Recent updates

Contact IBM

Browse Power Systems

Next generation applications for big data and analytics and cognitive computing are providing unprecedented insights into opportunities, threats and efficiencies. IBM Power Systems is at the forefront of delivering solutions to gain faster insights from analyzing both structured information and unstructured big data. With the secure, flexible and open platform of IBM Power Systems plus solutions and software, organizations can outpace their competitors by delivering faster services, providing differentiated offerings and turning operational cost into investment opportunity.

To draw insights and make better decisions, businesses rely on the secure, flexible and open platform of IBM Power Systems. Built with the first processor designed for big data workloads, the design of Power Systems combines the computing power, memory bandwidth and I/O in ways that are easier to consume and manage, building on strong resiliency, availability and security.

IBM Power Systems deliver flexibility and choice of operating systems to enable your business to support the next generation applications for big data and analytics and cognitive computing that are transforming how organizations work today. Whether running 1, 2, or all 3 - coupled with PowerVM, they maximize the benefit of Power Systems in your business.

Transform your business with Systems Software that enables virtualization, high availability, flexibility, security and compliance on Power Systems™. IBM’s integrated approach to developing Systems and Systems Software together delivers optimized results with Power Systems.

IBM and IBM Business Partner solutions exploit key benefits in IBM Power Systems’ unique design combined with systems software to provide support for next generation applications for big data and analytics and cognitive computing to providing unprecedented insights into opportunities, threats and efficiencies to your organization.

Over the last five years thousands of clients have migrated to IBM Power Systems. Learn how Power Systems has helped them support next generation applications for big data and analytics and cognitive computing on an open platform for choice while improving business performance, reducing risk, and establishing a platform for growth.

DB2 Web Query

Web based query and reporting

IBM i for BI solution

IBM i for Business Intelligence is a packaged solution that is easy to order and easy to implement, and easy to maintain. Everything you need for an out of box analytical solution based on IBM i and DB2 Web Query.

Additional information