IBM 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 includes a range of security features aligned 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 supports in-database analytics, enabling complex analytical operations to be performed directly within the database environment. This capability helps organizations process and analyze data more efficiently without relying heavily on external tools.

Organizations commonly use DB2 for i for applications running on the IBM i platform, including ERP systems and custom-built business applications. The platform is widely used across industries such as finance, manufacturing, and retail.

In summary, IBM DB2 for i, as part of the IBM i ecosystem, provides a database solution designed specifically for the platform. It combines performance, security, and integrated management features for businesses operating within the IBM i environment.

IBM DB2 for i data types we support

INTEGRAL:

bigintintegersmallint

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:

datetimetimestamp (timestmp)timestz

LARGE OBJECTS:

blob (binary large object)clob (long varchar, character large object)nclob (dbclob, national character large object)xml

OTHER:

booleanuniqueidentifier