Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    24

    Unanswered: Clear Database Log

    I want to Removes the inactive part of the log without making a backup copy of it and truncates the log to free spaces. That's like the statement "BACKUP LOG db-name WITH TRUNCATE_ONLY " in SQLServer. Is there any statements/method to do that? Thanks in advance!
    Last edited by carmenlei; 08-02-04 at 23:18.

  2. #2
    Join Date
    Sep 2002
    Posts
    456
    I think it will help if you can explain clearly what that command does exactly in SQL server...otherwise you are limiting yourself to only those individuals who knows both SQL and DB2!!! Please read "must read before posting"

    dollar

  3. #3
    Join Date
    Jun 2004
    Posts
    24
    sorry, coz I didn't know about what should I do clearly. But I've try my best to explain now~

  4. #4
    Join Date
    Aug 2004
    Posts
    15

    truncating active log

    can use command:

    archive log for database db-alias

Posting Permissions

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