On a 64 bit linux, db2 9.1 system, I am trying to change logging to
"circular" via:
-----
UPDATE DB CFG FOR MYDB7 USING logarchmeth1 OFF logarchmeth2 OFF
logprimary 16 logsecond -1 logfilsiz 10240;
-----
I get back an error:
------
SQL5153N The update cannot be completed because the following
relationship would be violated:
"logsecond can only be set to -1 if log archiving is enabled".
------
However, logsecond IS set to -1, besides the fact that the above query
is setting it as well.
Also, the following sql did go thru ok:
UPDATE DB CFG FOR MYDB7 USING logsecond -1;
But, I still get the error mentioned when I try running the first
aforementioned script.
Please advise; Thanks.
nat
"circular" via:
-----
UPDATE DB CFG FOR MYDB7 USING logarchmeth1 OFF logarchmeth2 OFF
logprimary 16 logsecond -1 logfilsiz 10240;
-----
I get back an error:
------
SQL5153N The update cannot be completed because the following
relationship would be violated:
"logsecond can only be set to -1 if log archiving is enabled".
------
However, logsecond IS set to -1, besides the fact that the above query
is setting it as well.
Also, the following sql did go thru ok:
UPDATE DB CFG FOR MYDB7 USING logsecond -1;
But, I still get the error mentioned when I try running the first
aforementioned script.
Please advise; Thanks.
nat
Comment