Room: Ballroom A+B
This talk will present a proof of concept project that is migrating an important database from DB2 UDB on a z/OS mainframe to PostgreSQL on Linux servers. The schema are migrated using SQLWorkbench/J and the data is migrated using both SQLWorkbench/J (for data export) and pgloader (for import into PostgreSQL). To ease application migration, an extension similar in spirit to orafce (named db2fce) was created providing popular DB2 functions.
Along the road, several obstacles and issues were encountered, including incompatible export/import formats, grumpy mainframe database admins, unimplemented objects for schema dumps and the notorious "invalid byte sequence for encoding 'UTF8': 0x00" error. All those problems and their solution will be discussed.