DB2 archive frequency ?

vilius · #1 (**permalink**) 04-30-09, 04:34

Hi,

Looks like db2 archives logs as they become inactive. Any way to change this - for example archive logs once per 12 hours ?

thanks
Vilius

przytula_guy · #2 (**permalink**) 04-30-09, 05:20

schedule the command : archive log

dr_te_z · #3 (**permalink**) 04-30-09, 10:13

Quote:

Originally Posted by przytula_guy

schedule the command : archive log

Yes, but that might not be enough.
I think you must configure your primary log files (size & quantity) large enough to hold 12 hours of mutations. Maybe you can suppress the auto archive that way.

Internet Services

Web Development

Digital Marketing

Consumer Tech