What is the best way to bulk import data which is approximately 10M records. Right now we are doing an "Insert Array", but we are having a bulk/log size error. We have tried increasing the log size but the performance is still sluggish. We can't lock the table and we need to have the logging on.
This topic has been locked.
Pinned topic DB2 Log Error Not Enough!
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
9RYQ_Kiran_mk 2700039RYQ78 Posts
Re: DB2 Log Error Not Enough!2013-08-07T09:57:12ZThis is the accepted answer. This is the accepted answer.
You can use import option with the COMMITCOUNT option by providing the regular commit points at every 10000 inserts which ease your log usage and you will not face any log full error.
Try and let me know.