Re: HP-UX / Informix backup

On Thu, 02 Oct 1997 16:08:14 +0100, Nicholas Penney <Nicholas.Penney@ubs.com> wrote: >I do not know informix at all and we have nobody >here at the moment that does, however we currently >run an informix application on an HP Unix server. > >As the informix database is using 'raw' partitions >the HP backup utility 'fbackup' does not back it >up. > >We really need to copy the informix data out to a >filesystem before running the backup. Can anyone >tell me the best way to do this. I have been >pointed to the sbtape utility that comes with >informix, but this only seems to write to a tape >and we do not want to have to use 2 tapes (and >have the operators swapping the tapes as >required). > >Thanks in advance.... > >-- >Nicholas Penney, HP-UX Unix Support You might try dbexport, if you have that utility available. Syntax is as follows. Usage: dbexport <database> [-X] [-c] [-q] [-d] [-ss] [{ -o <dir> | -t <tapedev> -b <blksz> -s <tapesz> [-f <sql-command-file>] }] NOTE: arguments to dbexport are order independent. This utility will export the specified database to the unix file system, including table structure and index information. Give me a call if you have any questions. Lem Beason Sr. P/A Redneck Trailer Supplies Springfield MO 417-864-5210 ext. 354