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.
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
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.