[Info-ingres] delete_oldest_ckp

[Rich Ford]

On Thursday, 2 December 2021 at 09:44:37 UTC-8, Roy Hann wrote:
> Rich Ford wrote: 
> 
> > On Thursday, 2 December 2021 at 09:27:18 UTC-8, Roy Hann wrote: 
> >> Rich Ford wrote: 
> >> 
> >> > When running alterdb -delete_oldest_ckp how does Ingres determine the oldest available checkpoint? 
> >> It gets it from the checkpoint history recorded in the database 
> >> configuration file. That file lives in the default data area of the 
> >> database. It's called aaaaaaaa.cnf but it's a binary file that is hard 
> >> for a human user to interpret. 
> >> 
> >> Fortunately you don't have to interpret it. The infodb utility dumps the 
> >> file contents, including the checkpoint history, in a readable format. 
> >> 
> >> The history array can save about 99 checkpoints IIRC... If you 
> >> somehow manage to accumulate more checkpoints than that they become 
> >> invisible and can no longer be deleted using alterdb. 
> >
> > Can this be modified to only store 1 checkpoint? 
> > We currently are storing 2 but running low on disk space.
> alterdb -keep=1 ... 
> 
> Roy

Big help.

Thanks,
Rich