Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
62

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

1 Answer 1

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

 
discard

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.