Re: Informix Backup
> Help! Help! Help!
> I have just been given an Informix database which is
> approximately 2+ Gig. in size. When I run a full backup, the
> data spans two tapes. I have the configuration parameter
> "TAPESIZ" set to 1500000. The actual tapes are HP DCLZ 4mm (90 m)
> with a capacity of 4-8 Gig. I am told by the resident Informix
> guru, that the TAPESIZ parm is set to its max.
Where did your guru get his/her numbers? We have the following config
for the same drives you're using. Our db is 3.5G.
# Archive Tape Device
TAPEDEV /dev/rmt/2hc # Archive tape device pathname
TAPEBLK 16 # Archive tape block size (Kbytes)
TAPESIZE 4000000 # Max amount of data to put on tape (Kbytes)
# Logical Log Backup Tape Device
LTAPEDEV /dev/rmt/1hc # Logical log tape device pathname
LTAPEBLK 16 # Logical log tape block size (Kbytes)
LTAPESIZE 4000000 # Max amount of data to put on log tape (Kbytes)
> How do I set up an unattended full backup to occur??? Can I give
> the "TAPEDEV" parm a rollover device ??? Can I get Informix to
> recognize a larger size tape??
We have the following two lines user informix's crontab file.
# Level 0 archive of On-Line Engine
00 1 * * 2-6 TBCONFIG=tbconfig.cars; INFORMIXDIR=/usr/informix; export TBCONFIG
INFORMIXDIR; echo '\\n0' | /usr/informix/bin/tbtape -s | head -100 > /tmp/archiv
e.log 2>&1 ; mailx -s "OLE Archive" daniel cdiemert < /tmp/archive.log
Rollover would be lovely.
>
> P.S. will an autochanger work???
>
Don't know. Can such be addressed as one device?
--
Dan Madvig e-mail: d-madvig@bethel.edu
Bethel College & Seminary phone: (612) 638-6414
3900 Bethel Drive fax: (612) 638-6001
St. Paul, MN 55112
If it weren't for my ignorance,
Your brilliance would be of no use.