Ingres VectorWise checkpoint and Rollforward

[bolke01]

There have been several questions

Over the last few days I have taken a look at the requirements and have built an addon that will enable Vectorwise folder structures to be backed up alongside the Ingres database files.

The rollforward of the checkpoint will replace the IVW data file and associated lock file

Note:
1. No users should eb connected to the database when a checkpoint is taken.
2. It is upto the DBA to ensure that there is sufficient space to take an Ingres VectorWise backup
3. All Ingres VectorWise datafiles are backedp up to the primary checkpoint location (II_CHECKPOINT)

4. When rolling forward a database, the Ingres VectorWise file will only be restored from teh checkpoint if the VectorWise engine is stopped before the rollforward is started.

The addon makes use of a modified chtmpl_wrap script to manage the Ingreds ectorWise backup and recovery steps AFTER successful processing of the Ingres Database.

[marcin]

Hi,

What is that 'addon'? Is it available, or is it some internal Ingres project? We're very interested

Marcin

[makni01]

It's a project that will be made public soon, that Keith is working on. It basically runs a script and once it's installed it allows you to backup your VW db by issuing the Ingres ckpdb command. It of course also allows rollforwarding (restoring) by issuing the Ingres rollforwarddb command.

[bolke01a]

The first cut of a checkpoint program has been uploaded.

I have had feedback from a focus group and I am in the process of simplifying the setup process.

I have been informed that if the necessary steps are taken to ensure all is OK to take a checkpoint, that a successful ckpdb and rollforward cn be performed.

Note: Feedback comments include ensuring that an offline checkpoint is taken. This version does not do that, and in fact requires that an on-line checkpoint is taken, as it requires SQL access to Terminate the VectorWize engine.