db2 v8 log

bic · #1 (**permalink**) 05-26-10, 09:17

We're burning through our 8 meg logs every minute. So, if I change the log arch method, will this require an immediate offline full backup?

Presently at

UPDATE DB CFG FOR ourdb USING logarchmeth1 "DISK:E:\log_archive" logprimary 3 logsecond 2 logfilsiz 2000;

n_i · #2 (**permalink**) 05-26-10, 09:36

Quote:

Originally Posted by bic

if I change the log arch method, will this require an immediate offline full backup?

That certainly depends on what you change it to.

Marcus_A · #3 (**permalink**) 05-26-10, 09:38

The following parms are way too low:

logprimary 3
logsecond 2
logfilsiz 2000

I don't believe that changes to logprimary and logfilsiz take effect until the database is deactivated.

Internet Services

Web Development

Digital Marketing

Consumer Tech