• 1 reply
  • Latest Post - ‏2013-08-07T09:57:12Z by 9RYQ_Kiran_mk
1 Post

Pinned topic DB2 Log Error Not Enough!

‏2013-07-31T21:50:56Z | db2 dbdsupport errors hivalue log

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.

  • 9RYQ_Kiran_mk
    78 Posts

    Re: DB2 Log Error Not Enough!


    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.