Move Log Files to new path

jyoung · #1 (**permalink**) 08-25-08, 08:32

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.

ARWinner · #2 (**permalink**) 08-25-08, 08:57

For DB2 for LUW, you are correct. I do not know about Z/OS.

Andy

jyoung · #3 (**permalink**) 08-25-08, 09:23

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.

przytula_guy · #4 (**permalink**) 08-25-08, 09:37

just update the db cfg for this database
stop the instance - start the instance
move the remaining logs at old path to new path

jyoung · #5 (**permalink**) 08-25-08, 11:44

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.