Delete After Journal

Database
Enthusiast

Delete After Journal

Hi,

I'm testing the backup cicle, but the Journal table grew a lot...,

I can't run DELETE JOURNAL from SQLA

As I can truncate the After Journal ?

Thanks.
1 REPLY
Junior Contributor

Re: Delete After Journal

You have to run it from arcmain:
checkpont (xxxx), with save
followed by
delete saved journal (xxxx)

Btw, the maintenance of the journals should be part of your backup process :-)

Dieter