What is the best way to validate that data has been successfully unloaded from the source database? I have run into an issue where it appears the flat file being generated does not contain all the rows the source Oracle database has.
Also, how can you capture any load errors when running the db2load.sql script? The output from that script shows some records rejected, but there is nothing showing in the IBMDataMovementTool.log or IBMDataMovementToolError.log.
bluey01 110000ENQX6 Posts
Re: errors on load to DB22011-09-22T02:01:13ZThis is the accepted answer. This is the accepted answer.You need to investigate why a table is failing. Check the table defintion of the orignal database to the DB2 table, then look at the rows that failed. The tool won't solve all your problems - just most of them!
I have just been thru this and generally it relates to CLOBs or Varchars. Once you get the table definitions correct, then it will work. I have had to extrac and load some tables manually that had BLOB and CLOB colums