Giovanni,
From your messages it appears your running OpenVMS and Ingres 6.xxx. If
you were to look at the II_SYSTEM:[INGRES.FILES]CKTMPL.DEF file you
will see the option WST which is the (WORK,SAVE,TAPE) option. It
normally will point to the command file
II_SYSTEM:[INGRES.FILES.CHECKPOINT]CKP_TO_TAPE.COM.
This command file by default contains the following commands :-
$ alloc 'p3'
$ backup/verify/ignore=label_processing/exclude=
(pppp*.t*,*.m*,*.d*,*.sm*)-
'p2'*.* 'p3''p4'
$ dismount/nounload 'p3'
You will want to change this command file, add the /MEDIA_FORMAT switch
to use compaction. If your using a tape loader then I'm sure that the
loader wants to know the labels, VMS can supply these through the
BACKUP command using the /LABEL=(tape1,tape2,tape...) switch. See the
VMS help on BACKUP for more info.
If you want to generate the labels and pass into the ckpdb program
ensure you do something like this...
tapes_to_use=="tape1,tape2,tape3"
ckpdb -mtape: db ...
inside the command file CKP_TO_TAPE you can then use the global symbol
tapes_to_use because ckpdb spawns a subprocess which kicks off the
actual backup command.
Hope this is what you were looking for...
Gary Hansford
> Hi Colin, Hi all,
> about O.S,. it is a OpenVMS (one of last version...)
> Ingres is in 6.3 release (I don't know patch version)
> HW: It's a cluster of 3 machine; 1 Compaq GS140 and 2 AS 4100.
> Requirements I had were to have a "non compress" backup on tape. At
now, one
> tape is not enough.
> Which are the parameters in $II_INGRES/files/cktmpl.def file to set
for a
> multiple tape backup??
> Thanks in advance.
> Regards.
> -----Messaggio originale-----
> Inviato: luned 5 giugno 2000 15.05
> A: 'Giovanni Franzese'
> Oggetto: RE: checkpoint in multiple tapes
> Giovanni,
> the newsgroup can advise you better if we know:
> Ingres version & patch
> Operating system & version
> Hardware
> Can you afford the time overhead to compress the checkpoint before
spooling
> to tape?
> HTH Colin.
> -----Original Message-----
> Sent: 01 June 2000 11:07
> Subject: checkpoint in multiple tapes
> Hi all,
> I have a problem with checkpoint command.
> I usually run ingres backup by "checkpoint" on a Compaq library
(TZ887).
> This library contains 7 tapes of 20/40 (native/compress) GByte.
> One tape is no more enough .....it is necessary more then one tape (60
> GB is the attual size of my backup on disk). The library can switch to
> an other tape but the checkpoint command doesn't wait for, so the
> operation doesn't work well.
> Is it possibile to anable (with some parameters or option) the
> checkpoint command for waiting for tape switching??
> How can I handle a checkpoint on multiple tape?
> Thank you.
> Best Regards
Sent via Deja.com http://www.deja.com/
Before you buy.
by