Results 1 to 3 of 3

Thread: Log files

  1. #1
    Join Date
    Nov 2007

    Unanswered: Log files

    Please tell me the way how can i archive my log files ? i guess its with archive command ..but on what basis should i archive them ??how many log files will go will it effect to users connected to the database or it should taken in a offline mode
    my log files are of 100 gb now ..
    Q1.what should be the strategy to archive the log files ? ?

    Q2.also i am storing my log files on the system and data on the SAN box is it the correct way to be done !?? databases have grown to 300 gb is it possible somewhere to reduce the size ? i mean data be compressed ? ?

  2. #2
    Join Date
    Jun 2006
    you can archive to disk/tape/tsm
    why such large log files - it will take long time to copy and if a crash occured, much data can be lost
    make smaller log files - like 10M each
    archive is asynch as occures when an active log file is closed
    table compressing is possible in v9
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Nov 2007
    thanks for the reply ! !
    when i say its 100 gb means it means in total size of the log files ..not a single log file .
    but if i archive them ..will the database will be effected ? and do i need them in case i am doing a restore ?
    also please answer my question regarding log on hard disk and data on SAN box .

Posting Permissions

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