Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004
    Posts
    268

    Unanswered: Transaction log is full

    I am importing data into database and I imported all the files except 2 because I am getting "The transaction log for the database is full" error. I realize that the table I am trying to load has already 2100830 rows.

    I tried to delete the data from this table but I got the same "The transaction log for the database is full" error.

    How do I shrink or remove the transaction log ?

    AIX 5.2 DB2 8.1.5

    Thanks.

  2. #2
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    can you post a script? Are you using db2move? If you are using a db2move you have only two options. 1. DO NOT use db2move it does not commit data. 2. rewrite to use load with a commit.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  3. #3
    Join Date
    Nov 2004
    Posts
    374

    log full

    if table is empty you could alter the table not logged initially and load/import the data.
    with import always specify commitcount xxx and with load specify savecount xxx and if file is still available also : nonrecoverable
    there is no shrink command (this is for MS SQL..)
    see command reference for detailed syntax..
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  4. #4
    Join Date
    Oct 2004
    Posts
    268
    Thanks for the replies.......These 2 tables we really did not need because they were some perf monitoring tables that came from the client but I should include the 'Commit' in the files/scripts and also increase the transaction log size from default to a bigger value.

    Thanks again..........

Posting Permissions

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