cancel
Showing results for 
Search instead for 
Did you mean: 

Change path db2 log_dir

anderson_cardozo
Participant
0 Kudos

Hi Gurus,

I´m trying to change newlogpath parameter in db2 database with command db2 UPDATE DB CFG FOR SEQ USING NEWLOGPATH /db2/<SID>/log_dir/;

but the early path still appear, do you know how to erase early path?

Accepted Solutions (1)

Accepted Solutions (1)

former_member182505
Contributor
0 Kudos

Hello Anderson

Use the command below

db2 update db cfg for SID using NEWLOGPATH /db2/SID/log_dir

Do not use < ; >

then

> db2stop

>db2start

and let us know the result

Thanks

Sadiq

Former Member
0 Kudos

Hi Anderson,

Please execute the command as Sadiq suggested.

You can execute the command as too ending with immediate keyword to see if it comes in effect, else you 'll need a DB restart.

db2 update db cfg for SID using NEWLOGPATH /db2/SID/log_dir immediate

Also.

The new setting does not become the value of logpath until both of the following occur: 

  • The database is in a consistent state, as indicated by the database_consistent parameter.
  • All applications are disconnected from the database

If you're changing the parameter on HADR

IBM Changing the NEWLOGPATH db cfg parameter on a STANDBY server in a HADR environment - United Stat...

Regards,

Prithviraj.

Answers (1)

Answers (1)

anderson_cardozo
Participant
0 Kudos

Thank you everyone, this is the right answer.