Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2005
    Posts
    31

    Unanswered: Move Log Files to new path

    I need to move the location of the log files due to the file system filling up. Just want some verification that I am doing this correctly.

    1. An Offline backup is taken nightly.

    2. After backup insure that the application is shutdown.

    3. Issue command to change the log path:
    db2 update db cfg for database_name using NEWLOGPATH directory_of_new_disk

    4. Start up application.

    My question is should I do another backup after I change the log path or is that not needed? Can I assume that when the application starts up and connects to the db it will create the log files in the new path? Thank you.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    For DB2 for LUW, you are correct. I do not know about Z/OS.

    Andy

  3. #3
    Join Date
    Jul 2005
    Posts
    31
    Sorry, I should have given more information. My OS is AIX 5.2 ML 10. My DB Version is 8.1.1.56. Thank you.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    just update the db cfg for this database
    stop the instance - start the instance
    move the remaining logs at old path to new path
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Jul 2005
    Posts
    31
    Guy,
    Since I am doing an off-line backup is it necessary to move the logs to the new path as long as the application is shut down and no activity has taken place? I would be doing this right after the backup has taken place and the application has not restarted. Thank you.

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Jyoung, Given your circumstances, I wouldn't think it is critcal to move the log files to the new path

    HTH

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

  7. #7
    Join Date
    Jul 2005
    Posts
    31
    Thank you everyone for the information.

Posting Permissions

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