Hello all!

Does someone knows how I can change MIRRORLOGPATH db cfg parameter form something to nothing?

This is what I have.

$db2 get db cfg for mydb
Path to log files = /home/db2inst1/NODE0000/SQL00001/SQLOGDIR/
Overflow log path (OVERFLOWLOGPATH) =
Mirror log path (MIRRORLOGPATH) = /mydb_copy_logs/MYDB/NODE0000/
First active log file = S0001339.LOG

I want to set this parameter to "nothing" but when I do this I receive error:

$ db2 update db cfg using mirrorlogpath
SQL0104N An unexpected token "END-OF-STATEMENT" was found following
"MIRRORLOGPATH". Expected tokens may include: "<identifier>".
SQLSTATE=42601

I have to put some identifier, but which one?

DB2 v.8 , AIX

Thank you in advance...

Hi,

Have you tried to write:
db2 update db cfg using mirrorlogpath =

Hope this helps,
Grofaty

Unfortunetly - still the same error...

I would try =NO or =NULL

update db cfg using MIRRORLOGPATH '' (two single quotes)

should do the trick (I hope :-))

BOW

Thank you ... This works!!

NNicole

Below is the right way of doing it .

DB2 update db cfg using MIRRORLOGPATH DEFAULT

Regards
Sam