Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2002
    Posts
    10

    Unanswered: when delete all rows, how to avoid log full?

    I tried to delete all rows in a table in udb on AIX 4.3, db2 generate an log full error message. there are total about 40000 rows in that table, my question is how to turn off the log when I delete a big data?

    SQL0964C The transaction log for the database is full. SQLSTATE=57011


    Thanks there.
    regards,
    BBG

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: when delete all rows, how to avoid log full?

    IMPORT FROM /dev/null of del replace into <table-name>

    HTH

    Cheers

    Sathyaram
    Originally posted by bbg
    I tried to delete all rows in a table in udb on AIX 4.3, db2 generate an log full error message. there are total about 40000 rows in that table, my question is how to turn off the log when I delete a big data?

    SQL0964C The transaction log for the database is full. SQLSTATE=57011


    Thanks there.

  3. #3
    Join Date
    Oct 2002
    Posts
    18

    Re: when delete all rows, how to avoid log full?

    Hi there,

    you can use the following command directly on your db2 command prompt:

    import from e:\work\xyz.txt of del replace into tablename

    File xyz.txt should be an empty file.




    Originally posted by bbg
    I tried to delete all rows in a table in udb on AIX 4.3, db2 generate an log full error message. there are total about 40000 rows in that table, my question is how to turn off the log when I delete a big data?

    SQL0964C The transaction log for the database is full. SQLSTATE=57011


    Thanks there.

  4. #4
    Join Date
    Nov 2002
    Posts
    10

    Re: when delete all rows, how to avoid log full?

    Thanks all, it works perfectly!
    regards,
    BBG

Posting Permissions

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