Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2017
    Posts
    1

    Unanswered: Turn off Transaction Logging for a bulk update statement

    Hi,

    I have read you can turn off transaction logging by using the alter command.

    Eg.

    ALTER TABLE TAB1 NOT LOGGED INTIALLY;
    Update tab1 set flag = 'Y';
    Commit;

    I am on DB2 version 9.7.9 and when I run the alter and the update I still get transaction log full error.

    Am I missing a step ??

    Thanks in advance,
    Brandon

  2. #2
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    294
    Provided Answers: 45
    Hi,

    Had you turned off the autocommit for your session before the ALTER TABLE statement?
    Regards,
    Mark.

Posting Permissions

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