Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2003
    Posts
    78

    Question Unanswered: can i clean these files??

    hello,
    our aix db2 server is having full disk space problems.
    I have recognised that the below files are so large in size
    Can i clean them with simply doing "rm"? Will the database and instance work properly without them?
    ıf simply removing the files won't work, how can i clean it??
    tnks all


    -rw------- 1 db2dvlp2 db2iadm1 16785408 25 Feb 15:05 /home/db2inst1/NODE0000/SQL00010/SQLOGDIR/S0000000.LOG

    -rw------- 1 db2dvlp2 db2iadm1 16785408 25 Feb 15:05 /home/db2inst1/NODE0000/SQL00010/SQLOGDIR/S0000001.LOG

    -rw------- 1 db2dvlp2 db2iadm1 16785408 25 Feb 15:05 /home/db2inst1/NODE0000/SQL00010/SQLOGDIR/S0000002.LOG

    -rw------- 1 db2dvlp2 db2iadm1 16785408 25 Feb 15:05 /home/db2inst1/NODE0000/SQL00010/SQLOGDIR/S0000003.LOG

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    These are database log files ... Please do not remove them ...
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by sathyaram_s
    These are database log files ... Please do not remove them ...
    I wish they hadn't used the extention .LOG - it's very confusing for sysadmins not familiar with databases, they assume it's just a traditional informational log file. I've seen more than one occasion where the database was failing to start, then you look in the transaction log directory and see:
    S0000001.LOG.gz

    Argh! :P

    S0000001.DO.NOT.TOUCH would be preferable.
    --
    Jonathan Petruk
    DB2 Database Consultant

  4. #4
    Join Date
    Dec 2003
    Posts
    78

    you're right
    so what cleans up transaction log file in db2?? will an offline backup of the database clean the log files, as it works for sybase and sqlserver??

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    AFAIK, the offline backup will not delete these log files ... They will be on the disk ... When you restart the db, these files will be formatted ...

    You may delete these files after an offline backup ...

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  6. #6
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96
    stop instance , rm all *.LOG files from NEWLOGPATH , re-start the instance

    That is OK, if it is development instance


    Lekharaju Ennam

  7. #7
    Join Date
    Dec 2003
    Posts
    78
    thanks guys

Posting Permissions

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