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.
1 reply Latest Post - 2013-08-07T09:57:12Z by 9RYQ_Kiran_mk
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 PostsACCEPTED ANSWER
Re: DB2 Log Error Not Enough!2013-08-07T09:57:12Z in response to weejow
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.