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.
> 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
> I've looked at the template file but I can't work out how to get the Work
> 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.
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!