Results 1 to 3 of 3

Thread: odd Log problem

  1. #1
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Unanswered: odd Log problem

    I was running an insert statment and filled up the db log files. The job stopped and I assumed that it rolled back. However the logs did not release themselves. I know that I cant just delete the logs...so how do I get the roll back to commit and clear the logs?
    Jim
    ------------
    And back to SQL Server....I always find my way home
    View my Linkedin profile

  2. #2
    Join Date
    Sep 2004
    Posts
    111
    Just issue db2stop command. DB2 will take care.

    -Tks

  3. #3
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    Is there any other way...I have a transaction that is runnig unlogged as well as the one that failed. the one that is running will take forever to run in the first place I would hate to kill it now...
    Jim
    ------------
    And back to SQL Server....I always find my way home
    View my Linkedin profile

Posting Permissions

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