home‎ > ‎backup‎ > ‎

backup dbs

Backup storage spaces, optionally set database logging modes.

usage

infx backup type=dbs [ level=0|1|2 tapedev ansi buff unbuff nolog ]
     backup storage spaces
       optional:
         level - the backup level
         tapedev - name of directory to store backup
         ansi - list of databases to set to ansi mode logging
         buff - list of databases to set to buffered logging
         unbuff - list of databases to set to unbuffered logging
         nolog - list of databases turn off logging

NOTE: Separate multiple database names with commas,e.g. nolog=db1,db2,db3

pre command

The default infx config file specifies a rm command to be executed before each backup. This removes old ontape backup files, leaving the most recent file in place.

rm -f ${tapedev}/${host}_${servernum}_[0-9]*_L${level}

post command

No default post command defined.

examples

 full backup

demo1@bobii:/home/informix>infx backup type=dbs

Using the backup and restore filter gzip -c.
Using the backup and restore filter gzip -c.
100 percent done.
File created: /infx/inst/demo1/backup/db/bobii_5_L0

Please label this tape as number 1 in the arc tape sequence.
This tape contains the following logical logs:

 38

Program over.
post-backup tapedev=/infx/inst/demo1/backup/db level=0 vers=11070004
cleaning all storage pool entries
0 files cleaned from /infx/inst/demo1/chks

incremental backup

demo1@bobii:/home/informix>infx backup type=dbs level=1

Using the backup and restore filter gzip -c.
Using the backup and restore filter gzip -c.
100 percent done.
File created: /infx/inst/demo1/backup/db/bobii_5_L1

Please label this tape as number 1 in the arc tape sequence.
This tape contains the following logical logs:

 38

Program over.
post-backup tapedev=/infx/inst/demo1/backup/db level=1 vers=11070004

alias

The following command line aliases have been defined

 alias
 command
 example
 LO  infx backup type=dbs level=0  infx L0
 L1   infx backup type=dbs level=1  infx L1
 L2  infx backup type=dbs level=2  infx L2

notes

  • backup directory is defined by onconfig TAPEDEV parameter
  • see 6. backup for more information on performing backups
  • see 8. BAR manager for information on setting up backup commands, including ontape & onbar
  • see sub-infx-ontape.ini for information on changing ontape commands, including pre & post commands
  • see sub-infx-onbar.ini for information on changing onbar commands, including pre & post commands