Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Posts
    78

    Question Unanswered: how to resize transaction log

    Hello,

    When I tried to import a very big file to a table, I got the error of transaction log full. I have to split the file several times in order to load the data. Does anyone know how to resize DB2 V8.1 transaction log?

    I'd appreciate your suggestion.
    Christine

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Here is a better idea:

    Use COMMITCOUNT n on the IMPORT command.

    This will perform a COMMIT after every n records are imported. I would recommend a value of 1000 for n.

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    It was written a lot of this topic. One of them I have already answered this question. Plese visit the following link.

    Please also search this forum. I have found some links.

    Hope this helps,
    Grofaty

  4. #4
    Join Date
    Jul 2003
    Posts
    78

    I changed the log file size

    Thank you guys. I managed to change the log file size, and that problem never happen again.



    Originally posted by grofaty
    Hi,

    It was written a lot of this topic. One of them I have already answered this question. Plese visit the following link.

    Please also search this forum. I have found some links.

    Hope this helps,
    Grofaty

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •