I'm trying to migrate a DB from mysql 5.0.95 to DB2 10.1 LUW on Suse Linux 11.
I ran the IDMT tool script unload.sh earlier today with just GENDDL=true and that generated the DDL and shell scripts just fine. I was then able to run db2ddl.sh and create all the DDL objects in the target DB2 instance with no issues.
Then I ran unload.sh with GENDDL=false and UNLOAD=true, and that unloaded all the data and generated the load scripts BUT the db2load.sh script is empty. So also these files are all 0 bytes: db2tabcount.sql, db2tabstatus.sql, db2loadterminate.sql, db2excepttaount.sql, db2dropobjects.sh, dbcheckremoval.sh and db2checkpending.sql.
These other files seem to have gotten generated fine: db2tables.sql, db2exceptiontables.sql, db2runstats.sql.
Can anyone provide clues as to why the main load shell script - db2load.sh - would be empty? And any workarounds?