[Info-ingres] delete_oldest_ckp

[Roy Hann]

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.

Roy