DB2 Load spend same time for small and big table
Posted on 2006-06-20
We are using db2 load to import data to a new database. We follow IBM Db2 Load guide and create all tables and indexes and start db2 load.
After 2h30 it imports just 15Gb (original database = 60Gb).
Looking the db2diag.log we can see how much time db2 load spend for each table.
For a small table (just 1 row) it spends 3 seconds. For a big table it spends 1 minute to import 1 million rows.
Anyone could help us with this thing???
Thanks in advance.