Source:Informix Configuration: Difference between revisions

From SEPsesam
No edit summary
(In progress.)
Line 1: Line 1:
{{Copyright SEP AG‎|en}}
<div class="noprint">{{Copyright SEP AG‎|en}}


{{Navigation_latest|release=4.4.3|link=[[Special:MyLanguage/Informix|Informix archive]]}}
{{Navigation_latest|release=[[SEP_sesam_Release_Versions|4.4.3/4.4.3 ''Grolar'']]|link=[[Special:MyLanguage/Informix|Informix archive]]}}</div><br />


==Overview==
==Overview==
Line 26: Line 26:
| style="padding:0px 40px 0px 10px; color: grey; font-size: 90%; text-align:left;" | If you are using an older SEP sesam version, refer to [[Special:MyLanguage/Informix|Informix archive]].
| style="padding:0px 40px 0px 10px; color: grey; font-size: 90%; text-align:left;" | If you are using an older SEP sesam version, refer to [[Special:MyLanguage/Informix|Informix archive]].
|}</div>
|}</div>
SEP sesam online backup for Informix (SIB) provides the Backup Services API (XBSA) between Informix and SEP sesam for saving data of Informix databases 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 data from specified storage spaces or logical-log files. SEP sesam manages the whole backup media, whereas ON-Bar decides which data has to be saved or recovered.  
<span style="font-size:92%; line-height: 1.3em; color:grey;">This article describes prerequisites and configuration requirements of SEP sesam integration with Informix. Note that the procedures introduced in this article are only the required pre-configuration steps. For details on Informix integration key features and backup configuration, see [[Special:MyLanguage/4_4_3:Informix_Backup|Informix Backup]].</span><br />
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 the whole storage media, whereas ON-Bar decides which data has to be saved or recovered. For details on Informix concepts and utilities, see [https://www.ibm.com/support/knowledgecenter/en/SSGU8G/welcomeIfxServers.html IBM Informix documentation].


This article describes prerequisites and configuration requirements for SEP sesam integration with Informix. Note that the procedures introduced in this article are only the required pre-configuration steps. For details on backup and restore configuration, see [[Special:MyLanguage/4_4_3:Informix_Backup|Informix Backup]] and [[Special:MyLanguage/4_4_3:Informix_Restore|Informix Restore]].
===Requirements===
 
*To ensure error-free operation of SEP sesam and improve performance, make sure that the following conditions are met:
==={{anchor|prerequisites}}Prerequisites===
*Check the [[SEP_sesam_OS_and_Database_Support_Matrix#Informix|SEP sesam OS and Database Support Matrix]] for the list of supported Informix versions.
* [http://download.sep.de/extensions/databases/informix/ SEP sesam Extension for Informix], check the [[SEP_sesam_OS_and_Database_Support_Matrix#Informix|SEP sesam OS and Database Support Matrix]] for the list of supported Informix versions.
* SEP sesam Server v. 4.4.3 or higher. Check [[Special:MyLanguage/Hardware_requirements|Hardware requirements]] for [[Special:MyLanguage/SEP_sesam_Glossary#SEP_sesam_Server|SEP sesam Server]].
* SEP sesam Server; check [[Special:MyLanguage/Hardware requirements|Hardware requirements]] for [[Special:MyLanguage/SEP_sesam_Glossary#SEP_sesam_Server|SEP sesam Server]] or [[Special:MyLanguage/SEP_sesam_Glossary#RDS|RDS]].
* Download SEP sesam Extension for Informix from [http://download.sep.de/extensions/databases/informix/ SEP Download Center].  
* The standard SEP sesam Client is installed. Note that file system backup should work with this SEP sesam Client.  
* The standard SEP sesam Client is installed. Note that a regular file system backup should work with this SEP sesam Client.
*A user account with sufficient privileges to perform backup and restore operations.
*SEP sesam Informix backup module requires a license. For details, see [[Special:MyLanguage/List_of_Licenses#database|List of Licenses]].


== {{anchor|installation}}Installing Informix==
== {{anchor|installation}}Installing Informix==


=== {{anchor|installation_linux}}Installation on Linux or Unix===
=== {{anchor|linux}}Installation on Linux/Unix===


The SIB packet includes only one shared library which Informix server loads dynamically during the backup or restore. The library has to be copied to Informix server and the full path to it has to be specified under <tt>BAR_BSALIB_PATH</tt> in the ON-Bar configuration file.
The SIB package includes only one shared library which Informix server loads dynamically during the backup or the restore. The library has to be copied to Informix server and the full path to the library has to be specified under <tt>BAR_BSALIB_PATH</tt> in the ON-Bar configuration file.


For installation the following environment is assumed, however, adjust the paths and variables according to your needs.
We assume the following environment for the installation, however, you can adjust the paths and variables according to your needs.
*<tt>INFORMIXDIR</tt>={{path|/opt/informix}}
*<tt>ONCONFIG</tt>={{path|/opt/informix/etc/onconfig}}


INFORMIXDIR=/opt/informix
'''Steps'''
 
ONCONFIG=/opt/informix/etc/onconfig


Once you have downloaded the [http://download.sep.de/extensions/databases/informix/ SEP sesam Extension for Informix], proceed as follows:
Once you have downloaded the [http://download.sep.de/extensions/databases/informix/ SEP sesam Extension for Informix], proceed as follows:
<ol><li>Verify that the SEP sesam Client is installed. File system backup should work with this SEP sesam Client-</li>
<ol><li>Verify that the SEP sesam Client is already installed. Note that a regular file system backup should work with this SEP sesam Client-</li>
<li>Login as ''Informix'' user.</li>
<li>Log in as ''Informix'' user.</li>
<li>Create a new directory <tt>sib in \$INFORMIXDIR</tt> and unpack the file <tt><OS>_ssib_x.x.x.x.tgz</tt>.</li>
<li>Create a new directory <tt>sib<tt> in <tt>\$INFORMIXDIR</tt>.</li>
<li>Unpack the file <tt><OS>_ssib_x.x.x.x.tgz</tt>.</li>
<li>Create a symbolic link in <tt>\$INFORMIXDIR/lib</tt> to the unpacked library file <tt>ibsad001.so</tt>. If the file already exists, rename it first.</li>
<li>Create a symbolic link in <tt>\$INFORMIXDIR/lib</tt> to the unpacked library file <tt>ibsad001.so</tt>. If the file already exists, rename it first.</li>
  informix@linux:~> cd $INFORMIXDIR
  informix@linux:~> cd $INFORMIXDIR
Line 58: Line 62:
  informix@linux:/opt/informix> cd ../lib
  informix@linux:/opt/informix> cd ../lib
  informix@linux:/opt/informix/lib> ln -s ../sib/ibsad001.so
  informix@linux:/opt/informix/lib> ln -s ../sib/ibsad001.so
<li>PATH environment variable should include <tt>\$INFORMIXDIR/bin</</tt>.</li>
<li>''Path'' environment variable should include <tt>\$INFORMIXDIR/bin</tt>.</li>
<li>Check the backup/restore specific entries in the <tt>ONCONFIG</tt> file: Path to the installed SEP sesam library (<tt>BAR_BSALIB_PATH</tt>).</li></ol>
<li>Check the backup/restore specific entries in the <tt>ONCONFIG</tt> file (<tt>BAR_BSALIB_PATH</tt> path to the installed SEP sesam library):</li></ol>


Example:
'''Example:'''
  ...
  ...
  # Backup/Restore variables
  # Backup/Restore variables
Line 76: Line 80:
  ....
  ....


=== {{anchor|installation_windows}}Installation on Windows===
=== {{anchor|windows}}Installation on Windows===


'''Steps''':
'''Steps'''
<ol><li>Verify that the Windows SEP sesam Client (x64 or x86) is installed. File system backup should work with this SEP sesam Client.</li>
<ol><li>Verify that the Windows SEP sesam Client (x64 or x86) is installed. Note that a regular file system backup should work with this SEP sesam Client.</li>
<li>Login as ''Informix'' user.</li>
<li>Log in as ''Informix'' user.</li>
<li>Extract the appropriate <tt>libbsa.dll</tt> from the SEP download ([http://download.sep.de/extensions/databases/informix/windows/ SEP sesam Extension for Informix - Windows], ZIP archive) – either x64 or x86 and copy it into SEP sesam <tt>gv_ro_bin:bin\sesam</tt> directory.</li>
<li>Extract the appropriate <tt>libbsa.dll</tt> (either x64 or x86) from the SEP Download Center ([http://download.sep.de/extensions/databases/informix/windows/ SEP sesam Extension for Informix - Windows], ZIP archive), and copy it to SEP sesam <tt>gv_ro_bin:bin\sesam</tt> directory.</li>
<li>Edit the instance specific <tt>ONCONFIG</tt> file and set the <tt>BAR_BSALIB_PATH</tt> to the <tt>libbsa.dll</tt>.</li>
<li>Edit the instance specific <tt>ONCONFIG</tt> file and set the <tt>BAR_BSALIB_PATH</tt> to the <tt>libbsa.dll</tt>.</li>
{{Note|The path to <tt>libbsa.dll</tt> must use the short notation if SEP sesam is installed in a path with blanks, e.g., <tt>'C:\Program Files\SEPsesam\bin\sesam'</tt>. <tt>'''dir /X C:'''</tt> may be used to get the short name notation.}}</ol>
{{Note|If SEP sesam is installed in a path with blanks, e.g., <tt>C:\Program Files\SEPsesam\bin\sesam</tt>, you have to use the short notation for the path to <tt>libbsa.dll</tt>. You may use <tt>'''dir /X C:'''</tt> for the short name notation.}}
</ol>


Example:
'''Example:'''
* <tt>INFORMIXDIR</tt> (<tt>C:\PROGRA~1\IBM\Informix\11.70</tt>)
*<tt>INFORMIXDIR</tt>={{path|C:\PROGRA~1\IBM\Informix\11.70}}
* <tt>ONCONFIG</tt> (<tt>%INFORMIXDIR%\etc\ONCONFIG.ol_myinst</tt>)
*<tt>ONCONFIG</tt>={{Path|%INFORMIXDIR%\etc\ONCONFIG.ol_myinst}}


   ...
   ...
Line 113: Line 118:
=== {{anchor|installation_windows}}Common installation steps===
=== {{anchor|installation_windows}}Common installation steps===


<ul><li>In the instance specific ''<tt>ONCONFIG</tt>'' file the ''<tt>BAR_MAX_BACKUP</tt>'' gives the number of parallel backup sessions. ''<tt>BAR_MAX_BACKUP</tt>'' must be set at least to '''2'''. Otherwise the restores will not work.</li>
In the instance specific <tt>ONCONFIG</tt> file the <tt>BAR_MAX_BACKUP</tt> gives the number of parallel backup sessions. Note that <tt>BAR_MAX_BACKUP</tt> must be set at least to '''2''', otherwise, the restores will not work.
<li>To set the version of XBSA specification which SEP sesam supports, insert the following entry in the table '''<tt>bar_version</tt>''' on '''<tt>sysutils</tt>''' database:</li>
<ul><li>To set the XBSA specification version which SEP sesam supports, insert the following entry in the table '''<tt>bar_version</tt>''' on '''<tt>sysutils</tt>''' database:</li>


{| border="2" cellpadding="4" cellspacing="0" style="width100%; margin: 1em 1em 1em 0; background: #fcfcfc; border: 1px #aaa solid; border-collapse: collapse;"
{| border="2" cellpadding="4" cellspacing="0" style="width100%; margin: 1em 1em 1em 0; background: #fcfcfc; border: 1px #aaa solid; border-collapse: collapse;"
Line 127: Line 132:
  |}
  |}


<li>Instead of inserting this entry into database you can also adopt the ''Informix template file'':</li></ul>
<li>Instead of inserting this entry into a database, you can also adopt the ''Informix template file'':</li>
<ol><li>Copy template file '''<tt>\$INFORMIDIR/etc/sm_versions.std</tt>''' to '''<tt>\$INFORMIXDIR/etc/sm_versions</tt>'''.</li>
<ol><li>Copy the template file <tt>\$INFORMIDIR/etc/sm_versions.std</tt> to <tt>\$INFORMIXDIR/etc/sm_versions</tt>.</li>
<li>Add the following line <tt>'''1|1.0.1|sesam|1|'''</tt>.</li>
<li>Add the following line <tt>'''1|1.0.1|sesam|1|'''</tt>, as shown in the example below:</li>
  informix@linux:/opt/informix/> cd $INFORMIDIR/etc>
  informix@linux:/opt/informix/> cd $INFORMIDIR/etc>
  informix@linux:/opt/informix/etc> cp sm_versions.std sm_versions
  informix@linux:/opt/informix/etc> cp sm_versions.std sm_versions
Line 135: Line 140:
  informix@linux:/opt/informix/etc> cat sm_versions
  informix@linux:/opt/informix/etc> cat sm_versions
  #1|1.0.1|ism|1|
  #1|1.0.1|ism|1|
  1|1.0.1|sesam|1|
  '''1|1.0.1|sesam|1|'''
  informix@linux:/opt/informix/etc>
  informix@linux:/opt/informix/etc>
 
</ol></ul>
{{Note|For the usage of SEP sesam [[SEP_sesam_Glossary#command_task|command events]], the login scripts of the Informix users should not expect any inputs.}}</ol>
{{Note|For the usage of SEP sesam [[Special:MyLanguage/SEP_sesam_Glossary#command_task|command events]], the login scripts of the Informix users should not expect any inputs.}}<!--Ne znam preformulirati, ne razumem natančno, kaj želijo povedati.-->
 
== {{anchor|client_configuration}}Configuring Informix as a SEP sesam Client ==
 
The Informix must be added as a SEP sesam Client. For details, see [[Special:MyLanguage/Configuring_Clients|Configuring Clients]].


==Known issues==
==Known issues==
Line 150: Line 151:
[[Special:MyLanguage/4_4_3:Informix_Backup|Informix Backup]] – [[Special:MyLanguage/4_4_3:Informix_Restore|Informix Restore]]
[[Special:MyLanguage/4_4_3:Informix_Backup|Informix Backup]] – [[Special:MyLanguage/4_4_3:Informix_Restore|Informix Restore]]


==External reference==
==External references==
[https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.50.0/com.ibm.bar.doc/ids_bar_169.htm ON-Bar backup and restore system]
*[https://www.ibm.com/support/knowledgecenter/en/SSGU8G/welcomeIfxServers.html IBM Informix documentation]
*[https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.50.0/com.ibm.bar.doc/ids_bar_169.htm ON-Bar backup and restore system]

Revision as of 11:56, 18 October 2018

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.

Docs latest icon.png Welcome to the latest SEP sesam documentation version 4.4.3/4.4.3 Grolar. For previous documentation version(s), check Informix archive.


Overview

This article describes prerequisites and configuration requirements of SEP sesam integration with Informix. Note that the procedures introduced in this article are only the required pre-configuration steps. For details on Informix integration key features and backup configuration, see Informix Backup.
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 the whole storage media, whereas ON-Bar decides which data has to be saved or recovered. For details on Informix concepts and utilities, see IBM Informix documentation.

Requirements

  • To ensure error-free operation of SEP sesam and improve performance, make sure that the following conditions are met:
  • Check the SEP sesam OS and Database Support Matrix for the list of supported Informix versions.
  • SEP sesam Server v. 4.4.3 or higher. Check Hardware requirements for SEP sesam Server.
  • Download SEP sesam Extension for Informix from SEP Download Center.
  • The standard SEP sesam Client is installed. Note that a regular file system backup should work with this SEP sesam Client.
  • A user account with sufficient privileges to perform backup and restore operations.
  • SEP sesam Informix backup module requires a license. For details, see List of Licenses.

Installing Informix

Installation on Linux/Unix

The SIB package includes only one shared library which Informix server loads dynamically during the backup or the restore. The library has to be copied to Informix server and the full path to the library has to be specified under BAR_BSALIB_PATH in the ON-Bar configuration file.

We assume the following environment for the installation, however, you can adjust the paths and variables according to your needs.

  • INFORMIXDIR=/opt/informix
  • ONCONFIG=/opt/informix/etc/onconfig

Steps

Once you have downloaded the SEP sesam Extension for Informix, proceed as follows:

  1. Verify that the SEP sesam Client is already installed. Note that a regular file system backup should work with this SEP sesam Client-
  2. Log in as Informix user.
  3. Create a new directory sib in \$INFORMIXDIR.
  4. Unpack the file <OS>_ssib_x.x.x.x.tgz.
  5. Create a symbolic link in \$INFORMIXDIR/lib to the unpacked library file ibsad001.so. If the file already exists, rename it first.
  6. informix@linux:~> cd $INFORMIXDIR informix@linux:/opt/informix> mkdir sib informix@linux:/opt/informix> cd sib informix@linux:/opt/informix/sib> tar xzf /tmp/linux_sib.2.3.1.1.tgz informix@linux:/opt/informix> cd ../lib informix@linux:/opt/informix/lib> ln -s ../sib/ibsad001.so
  7. Path environment variable should include \$INFORMIXDIR/bin.
  8. Check the backup/restore specific entries in the ONCONFIG file (BAR_BSALIB_PATH path to the installed SEP sesam library):

Example:

...
# Backup/Restore variables
BAR_ACT_LOG             /opt/informix/log/bar_act.log
#BAR_MAX_BACKUP         0
BAR_MAX_BACKUP          4
#BAR_RETRY              3
BAR_RETRY               2
BAR_NB_XPORT_COUNT      10
BAR_XFER_BUF_SIZE       31
BAR_BSALIB_PATH /opt/informix/lib/ibsad001.so
BAR_DEBUG       3
BAR_DEBUG_LOG   /opt/informix/log/xbsa.log
....

Installation on Windows

Steps

  1. Verify that the Windows SEP sesam Client (x64 or x86) is installed. Note that a regular file system backup should work with this SEP sesam Client.
  2. Log in as Informix user.
  3. Extract the appropriate libbsa.dll (either x64 or x86) from the SEP Download Center (SEP sesam Extension for Informix - Windows, ZIP archive), and copy it to SEP sesam gv_ro_bin:bin\sesam directory.
  4. Edit the instance specific ONCONFIG file and set the BAR_BSALIB_PATH to the libbsa.dll.
  5. Information sign.png Note
    If SEP sesam is installed in a path with blanks, e.g., C:\Program Files\SEPsesam\bin\sesam, you have to use the short notation for the path to libbsa.dll. You may use dir /X C: for the short name notation.

Example:

  • INFORMIXDIR=C:\PROGRA~1\IBM\Informix\11.70
  • ONCONFIG=%INFORMIXDIR%\etc\ONCONFIG.ol_myinst
 ...
 # Backup/Restore variables
 BAR_ACT_LOG		C:\PROGRA~1\IBM\Informix\11.70\bar_ol_myinst.log
       #Path of log file for onbar.exe
 BAR_DEBUG_LOG		C:\PROGRA~1\IBM\Informix\11.70\bar_ol_myinst.log
       #Path of the debug log for onbar.exe
 BAR_DEBUG 0
 #BAR_MAX_BACKUP         0
 BAR_MAX_BACKUP          2
 #BAR_RETRY              1
 BAR_RETRY               2
 BAR_NB_XPORT_COUNT 20
 BAR_XFER_BUF_SIZE 15
 RESTARTABLE_RESTORE ON
 BAR_PROGRESS_FREQ 0
 BAR_BSALIB_PATH	C:\PROGRA~1\SEPsesam\bin\sesam\libbsa.dll	# Location of SEP sesam LIBBSA DLL
 BACKUP_FILTER
 RESTORE_FILTER
 BAR_PERFORMANCE 0
 BAR_CKPTSEC_TIMEOUT 15
 ...

Common installation steps

In the instance specific ONCONFIG file the BAR_MAX_BACKUP gives the number of parallel backup sessions. Note that BAR_MAX_BACKUP must be set at least to 2, otherwise, the restores will not work.

  • To set the XBSA specification version which SEP sesam supports, insert the following entry in the table bar_version on sysutils database:
  • bar_version bsa_version bar_sm sm_version
    1 1.0.1 sesam 1
  • Instead of inserting this entry into a database, you can also adopt the Informix template file:
    1. Copy the template file \$INFORMIDIR/etc/sm_versions.std to \$INFORMIXDIR/etc/sm_versions.
    2. Add the following line 1|1.0.1|sesam|1|, as shown in the example below:
    3. informix@linux:/opt/informix/> cd $INFORMIDIR/etc> informix@linux:/opt/informix/etc> cp sm_versions.std sm_versions informix@linux:/opt/informix/etc> vi sm_versions informix@linux:/opt/informix/etc> cat sm_versions #1|1.0.1|ism|1| 1|1.0.1|sesam|1| informix@linux:/opt/informix/etc>
Information sign.png Note
For the usage of SEP sesam command events, the login scripts of the Informix users should not expect any inputs.

Known issues

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

See also

Informix BackupInformix Restore

External references