DB2 for i

IBM DB2 for i is an integrated relational database management system optimized for the IBM i platform. Unlike other DB2 editions, this version is fully integrated with the IBM I operating system, providing a cohesive environment for IBM I users.

DB2 for I has a range of security features that are in sync with the IBM I security model, such as object-level security and auditing capabilities. The SQL Query Engine (SQE) enhances the performance of SQL operations, optimizing access to DB2 data. Additionally, DB2 for i has capabilities for in-database analytics, allowing complex analytics operations to be performed directly in the database.

Organizations use DB2 for I for applications running on the IBM I platform, including ERP systems and custom-built applications. The platform is utilized in sectors such as finance, manufacturing, and retail.

In summary, IBM DB2 for I, as a part of the IBM I platform, offers a tailored database solution, harmonizing performance, security, and management for businesses that use the IBM I ecosystem.

DB2 for i

data types we support

Integral:
bigint
integer
smallint
decimal:
decimal (dec, numeric, fixed)
double (float, double precision)
real (decfloat)
text:
char (character)
clob (long varchar, character large object)
nchar (national character)
nclob (dbclob, national character large object)
nvarchar (national character varying)
varchar (longvar, vargraphic, vargraph, varg, longvarg, character varying)
Binary:
binary (graphic)
varbinary (varbin, binary varying)
Date/Time:
date
time
timestamp (timestmp)
timestz
Large objects:
blob (binary large object)
clob (long varchar, character large object)
nclob (dbclob, national character large object)
xml
Other:
boolean
uniqueidentifier