Very Computer

Hi David,

    The cktmpl.def doesnt allow 'if' tests so you cant do it in there. What
    you can do though is get it to execute a shell script on every work cycle.
    Pass the location as a parameter to the shell script and then get it to
    issue your tape stacker commands for the location you desire.

    I make it sound so simple don't I? I'll confess I've never had a reason to
    do this, so all of the above is pure conjecture.

    Let me know how you get on, it could be usefull for the future.

    Martin Bowes

--
Random Duckman Quote #21:
Duckman - Actually it's quite a funny story,
          Once you get passed all the tragic elements and the over-riding
          sense of doom!

Ingres 6.4/05(sqs.ptx/02) on Sequent Dynix/ptx 4.2.3

Checkpoints are done online to tape and until now my largest database
(about 13Gb) with 7 locations has fitted on to a single tape in an Exabyte
stacker unit.

I need to alter the checkpoint template file so that 4 of the locations are
backed up to one tape, followed by an instruction to the tape changer,
 then the remaining 3 locations to the second tape. If there were enough
slots in the stacker unit I would use 1 tape per location but it just isn't
big
enough.

I've looked at the template file but I can't work out how to get the Work
phase
to trigger off an OS command at the 5th pass to achieve the tape change.
Can someone point me to a suitable template file/shell script?

There are also some smaller single location DBs on the same installation
which I will still need to back up during the same overnight run.

Thanks

David