Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2012-11-16T14:25:22Z by JSSK_Chumma_Dede
JSSK_Chumma_Dede
JSSK_Chumma_Dede
4 Posts
ACCEPTED ANSWER

Pinned topic db2load.sh is empty

‏2012-11-16T00:34:59Z |
Hi,

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?

Thanks,
JGP
Updated on 2012-11-16T14:25:22Z at 2012-11-16T14:25:22Z by JSSK_Chumma_Dede