Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This morning I was greeted by Ingres 10.0.0 with the following:

[ingres@denux ~]$ alterdb dejandb -keep=60
Mon May 28 08:54:17 2012 ALTERDB: No checkpoints available to delete.

[ingres@denux ~]$ ls -la /opt/Ingres/IngresII/ingres/ckp/default/dejandb | wc -l

Checkpoints are obviously there. And Ingres nicely makes new checkpoints, but I can't delete them with alterdb <dbname> -keep=<NN>

Any ideas?

Note: This post should be tagged "ingres" but I have insufficient rank to create it. Need help here.

share|improve this question

Looks like all I needed was a strong coffee to wake me up!

Apparently alterdb <database name> -keep=<NN> will naturally work ONLY when there are NN checkpoints or more! :) I wanted to -keep=60 but I had less than 60 because two weeks ago i did a cleanup, and left only 30...

So everything worked when I lowered the NN number...

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.