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.