There are some issues that we are facing here due to the large amount of data that is seeded into the DB2 (WINNT) database. To update/insert around 5 million records it used to take 40 mins. Now its taking around 5 to 6 hours.
I am using the DB2 Load Utility for this. The file that is used is not in the sorted order. Has any one encountered the same problem earlier or has any idea regarding this can reply.