Command line version of DB2 to MySQL converter

To perform batch conversion or call the tool from an automation script you can use console version of DB2 to MySQL converter called B2SAGENT.EXE. Find this program in the installation folder. B2SAGENT.EXE supports the following parameters:

--charset=...		MySQL character set
--db2pswd=...		DB2 user password
--db2schema=...		DB2 schema name
--db2user=...		DB2 user name
--dest=...		MySQL database name
--dump		convert DB2 database into MySQL dump file
--engine=...		MySQL storage engine (MyISAM, MEMORY, InnoDB, BerkeleyDB, ARCHIVE, FEDERATED, etc). Please refer to MySQL documentation for the further information.
--help		display help message and exit
--logfile=...		path to the logfile where execution traces will be written
--mode=...		how to process existing MySQL database (0 - overwrite the entire database, 1 - overwrite existing tables only, 2 - skip existing tables, 3 - merge)
--mysqlh=...		MySQL server IP address or network name
--mysqlu=...		MySQL user name
--mysqlp=...		MySQL user password
--port=...		MySQL port
--profile=...		path to the file to load conversion settings from
--silent		use this option to disable program output
--skip_idx		skip converting indexes
--src=...		DB2 database name
--tab_def		convert table definitions only
--tab_file=...		file containing table names to convert (one table name per line)

In the following example the program converts all tables from tablespace "SYSTOOLS" of DB2 database "db 1" into local MySQL database "db_mysql":

B2SAGENT.EXE --src="db 1" --db2schema=SYSTOOLS --db2user=scott --db2pswd=tiger 
--dest="db_mysql" --mysqlh=mysqlhost --mysqlu=administrator --mysqlp=the_passsword

Notes:

If you specified a profile, there is no need to specify any other parameters
The default mode is 'overwrite'. You can change it using '--mode' parameter
You can omit 'mysqlh' parameter to connect local MySQL server
It is necessary to specify 'port' parameter only if it differs from the default MySQL port 3306
If you omit 'tab_file' parameter, all tables from the specified schema will be converted
Command line parameters that contain spaces should be enclosed in quotes (for example --dest="my database.mdb")

MySQL character sets

This parameter specifies correct encoding of text values in the destination MySQL database. It can have one of the following values:

value	Description	value	Description
big5	Big5 Traditional Chinese	dec8	DEC West European
cp850	DOS West European	hp8	HP West European
koi8r	KOI8-R Relcom Russian	latin1	cp1252 West European
latin2	ISO 8859-2 Central European	swe7	7bit Swedish
ascii	US ASCII	ujis	EUC-JP Japanese
sjis	Shift-JIS Japanese	hebrew	ISO 8859-8 Hebrew
tis620	TIS620 Thai	euckr	EUC-KR Korean
koi8u	KOI8-U Ukrainian	gb2312	GB2312 Simplified Chinese
greek	ISO 8859-7 Greek	cp1250	Windows Central European
gbk	GBK Simplified Chinese	latin5	ISO 8859-9 Turkish
armscii8	ARMSCII-8 Armenian	utf8	UTF-8 Unicode
ucs2	UCS-2 Unicode	cp866	DOS Russian
keybcs2	DOS Kamenicky Czech-Slovak	macce	Mac Central European
macroman	Mac West European	cp852	DOS Central European
latin7	ISO 8859-13 Baltic	cp1251	Windows Cyrillic
cp1256	Windows Arabic	cp1257	Windows Baltic
binary	Binary pseudo charset	geostd8	GEOSTD8 Georgian
cp932	SJIS for Windows Japanese	eucjpms	UJIS for Windows Japanese

Please refer to MySQL documentation to better understand the concept of character sets and collations.