DB2 for i is a member of IBM’s family of DB2 databases. What makes DB2 for i unique is its integration with the platform, the IBM i operating system and Power Systems. This unique integration means you do less managing of your database, and more building of applications for analytics, mobile, cloud, or day to day operational purposes. DB2 for i’s open standards support allows you to leverage the world of development tools while protecting your investment in legacy applications. Self managing is what DB2 for i is all about !

Built In Efficiencies

DB2 for i is built into the operating system, and whereas most other database products require costly add-ons for features, with DB2 for i it’s all there! As an extension of the OS, administration is easy – you don’t even have to install it – its ready to go! Open standard support including ANSI standard SQL, XML, JSON, node.js and more provide a multitude of development environments for application development. Analyze and manage database performance through the provided tools that ship with the system!

Data that is secure

DB2 for i is considered one of the most secure database systems in the industry. From the beginning, security was designed as an integral part of the system. DB2 for i contains a rich set of security features and services that pertain to the goals of authentication, authorization, integrity, confidentiality, and auditing. Secure row and column level access through the built in Row and Column Access Control features. Several options exist for encrypting data, such as column level field procedures. Audit facilities and compliance reporting solutions allow you to monitor and report on database activity.


Companies today are demanding information gleaned from their operational databases. DB2 for i has for years provided many enhancements to support analytical applications. The world class SQL Query Optimizer provides the foundation for processing the large, complex queries found in these applications, which leverages a natural “in-memory” architecture known as Single Level Storage. DB2 Web Query for i provides a suite of analytics capabilities that can be used to modernize existing queries to building large scale data warehouses.

Modernize Your Database

Flexibility. Performance. Development Productivity. Data Integrity and Security. Shops with legacy RPG code can get out of “legacy jail” and modernize into the new world through a database modernization process that is minimal cost and avoids disruption. Move from older DDS database objects and record level access coding methods to SQL using the DB2 for i Center Lab Services team’s phased approach.

Contact an IBM Sales Specialist

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.

As an open innovation platform, Power Systems is optimized for big data and analytics performance and to deliver scale-out economics and security for the cloud. IBM and IBM Business Partner solutions exploit key capabilities in IBM Power Systems.

Over the last five years thousands of clients have migrated to IBM Power Systems for choice and flexibility. Learn how Power Systems has helped them revolutionise the way IT is developed and delivered, optimise for big data and analytics, and support private, public and hybrid offerings for scale-out or scale-up implementations all while improving business performance, reducing risk, and establishing a platform for growth.

DB2 Web Query

Web based query and reporting

Additional information