This is the limitation for trial version which imports only 20% of all records. With a registered version all the records are processed.
EMS Data Import for DB2 is a powerful tool to import your data quickly from MS Excel 97-2007, MS Access, DBF, XML, TXT, CSV, MS Word 2007, RTF, ODF and HTML files. It provides adjustable import parameters, including source data formats for all the fields and destination data formats for the selected fields, commit options, number of records to skip, etc. Data Import for DB2 includes a wizard, which allows you to set all the import options for different files visually, and a command-line utility to execute import in one-touch.