DB2 8.1 on Solaris
I have an application which inserts rows to a non-indexed table, which is initially empty. It writes c. 11 million rows and I can monitor the insert speed as it runs. It starts at about 3500 rows per second and appears to decline linearly down to c. 1000 rows per second at the end of the job. I am puzzled as to what could be causing the performance degredation. Without any indexes on the table, I would expect the performance to be fairly constant. Can anyone suggest a cause ?
I have an application which inserts rows to a non-indexed table, which is initially empty. It writes c. 11 million rows and I can monitor the insert speed as it runs. It starts at about 3500 rows per second and appears to decline linearly down to c. 1000 rows per second at the end of the job. I am puzzled as to what could be causing the performance degredation. Without any indexes on the table, I would expect the performance to be fairly constant. Can anyone suggest a cause ?