5 1 0:Informix Backup

From SEPsesam

Welcome to the latest SEP sesam documentation version 5.1.0 Apollon. For previous documentation version(s), check documentation archive.


This article describes Informix integration key features and backup configuration. For detailed information on prerequisites and installation requirements, see Informix Configuration.

SEP sesam online backup for Informix (SIB) provides the Backup Services API (XBSA) between Informix and SEP sesam for saving Informix data to the SEP sesam Server. XBSA specifies the access from Informix ON-Bar utility to a backup application. During backups and restores, ON-Bar uses XBSA to exchange the data from specified storage spaces (dbspaces) or logical-log files. SEP sesam manages all storage media, while ON -Bar decides which data to back up or restore. For details on Informix concepts and utilities, see the IBM Informix documentation.

Creating a backup task

During a backup (or restore), the ON-Bar utility controls the data streams. This utility must be integrated with a SEP sesam Server to access the storage devices.

Create a new backup task for the Informix server.

  1. From Main Selection -> Tasks -> By Clients, select Informix client and click New Backup Task. The New Backup Task window opens.
  2. Enter the Task name and from the Task type drop-down list, select Informix.
  3. Specify the Informix instance as the backup Source, e.g., ol_ids_1110_1. The instance should map to the instance which is used during onbar backup command.
  4. Click OK to create the task.

Configuring Informix

To give ON-Bar the necessary information to connect to SEP sesam, set the following environment variables:

Mandatory parameters

Set by Informix installation.
SESAM_SERVER=<SEP sesam Server name>
SESAM_JOB=<Informix backup task name>
Name of an already configured backup task on the SEP sesam Server which you had to create earlier.
SESAM_POOL=<Media pool name>
Name of an already configured media pool on the SEP sesam Server.

Optional parameters

XBSA_TRACE=<Trace level> (0|1|2)
If set with +10000000, then process logs to STDERR, e.g., 'set XBSA_TRACE=10000002'.
<Name of trace file>
Although XBSA_TRACE and XBSA_LOGFILE are not mandatory, they should be set to get information in case of problems during backup or restore. For restore only SESAM_SERVER and SESAM_JOB are mandatory.

Configuring ON-Bar backup

During backup, the Informix ON-Bar utility provides the interface to the databases and performs the extraction and insertion of the data. You must run the onbar command to start a database or logical logs backup as the Informix or root user.

You have to check the onbar return code, because onbar does not write error messages to STDERR (standard error output). For details on the return codes, see ON-Bar messages and return codes.

The following examples show how to start backups on the Informix server.

  • Backup of the tablespace dbspace01:
informix@linux:/opt/informix/> export SESAM_SERVER=backupsrv
informix@linux:/opt/informix/> export SESAM_JOB=informix_ts
informix@linux:/opt/informix/> export SESAM_POOL=DISK
informix@linux:/opt/informix/> onbar -b -L 0 dbspace01
informix@linux:/opt/informix/> echo $?
  • The commands shown in the following example:

Perform a backup level 0 of the dbspace01 on an OnLine Dynamic Server instance named venus. Back up all logical-log files associated with dbspace01, close the session and then back up the current logical log.

setenv SESAM_SERVER jupiter 
setenv INFORMIXDIR /usr/informix 
setenv ONCONFIG onconfig.std
onbar -b -L 0 dbspace01 
onbar -b -l -c
  • The SEP sesam extension for Informix (Windows, ZIP archive) contains the sbc_onbar.cmd command, which is suitable to back up Informix instances from the SEP sesam command events by adapting INFORMIX_... and SESAM_... values. The arguments are transfered to the onbar command and typical calls are sbc_onbar.cmd -b -L 0, or sbc_onbar.cmd -v.

ON-Bar commands

You have to use a relevant onbar -b command to back up storage spaces (dbspaces) or logical logs.

  • Complete backup of the database (if necessary, start the database with the oninit -v command)
onbar -b -w  [-L n]
n - Backup level (0, 1, 2), default is 0.
  • Backup of a single dbspace
onbar -b [-L n] 
n - Backup level (0, 1, 2), default is 0.
dbspace_name - Name of the Informix dbspace instance
  • Logical-log files backup
onbar -b -l     - Backup of all full logical-log files
onbar -b -l -c  - Backup of the actual logical-log files and switch to the next logical-log file.
onbar -b -l -s  - Backup of all logical logs, which reside on the hard disk after a crash of the 

Known issues

If you have problems with Informix, check the Troubleshooting Guide.

See also

Informix RestoreInformix Configuration

External references

Copyright © SEP AG 1999-2024. All rights reserved.
Any form of reproduction of the contents or parts of this manual is allowed only with the express written permission from SEP AG. When compiling and designing user documentation SEP AG uses great diligence and attempts to deliver accurate and correct information. However, SEP AG cannot issue a guarantee for the contents of this manual.