IBM DB2 to MariaDB Migration

SQLines provides services and tools to help you transfer data, convert database schema (DDL), views, stored procedures (SPL and COBOL), functions, triggers, queries and SQL scripts from IBM DB2 to MariaDB.

  • SQLines Data - Data transfer, schema migration and validation tool
  • SQLines SQL Converter - SQL scripts assessment and conversion tool

Databases:

  • IBM DB2 for LUW, z/OS and OS/400 11.x, 10.x, 9.x, 8.x and 7.x
  • MariaDB 10.x

DB2 to MariaDB Migration Reference

Data Types

Character data types:

DB2 MariaDB
1 VARCHAR(n OCTETS) Variable-length string in bytes, 1 <= n <= 32672 VARCHAR(n) n <= 65535 in characters
2 VARGRAPHIC(n) Variable-length UTF-16 string, <= n <= 16336 VARCHAR(n)

Binary data types:

DB2 MariaDB
1 VARCHAR(n) FOR BIT DATA Variable-length binary string, 1 ⇐ n ⇐ 32672 VARBINARY(n) n ⇐ 65535

Numeric data types:

DB2 MariaDB
1 DECFLOAT(16 | 34) IEEE decimal floating-point number DOUBLE

Data and time data types:

DB2 MariaDB
1 TIMESTAMP(p) Date and time with fraction, 0 ⇐ p ⇐ 12 , default 6 DATETIME(p) p ⇐ 6

Large objects data types:

DB2 MariaDB
1 BLOB(n) Binary large object, 1 ⇐ n ⇐ 2G LONGBLOB