This is an old revision of the document!

IBM DB2 to MariaDB Migration

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

We also help convert embedded SQL statements in C/C++ (ODBC, ESQL/C), C#, Java, PowerBuilder, VB/VB.NET, ASP/ASP.NET, Perl, PHP, Python, Linux shell and other applications. SQLines can also assist you to convert COBOL stored procedures and programs to MariaDB procedural language or Java.

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 Tools

SQLines tools to help you migrate from IBM DB2 to MariaDB:

SQLines Data - Data Transfer, Schema Migration and Validation Tool
SQLines SQL Converter - SQL Scripts Conversion Tool
Online SQL Conversion Tool

DB2 to MariaDB Migration Reference

Data Types

Data Types

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

SQLines SQL Converter

SQLines Data

Migration to MariaDB

Migration to Oracle

Migration to SQL Server

Migration to MySQL

Migration to PostgreSQL

Migration to SingleStore

Migration to IBM DB2

Migration to Redshift

Migration to Snowflake

Migration to Apache Hive

Migration to Spark

Migration to Presto/Trino

Migration to Netezza

Migration to Greenplum

Migration to EsgynDB

Application Conversion

Database Reference

IBM DB2 to MariaDB Migration

DB2 to MariaDB Migration Tools

DB2 to MariaDB Migration Reference

Data Types