To use Tivoli Storage Manager with Informix databases, you must install and configure the Tivoli Storage Manager client on your database server computer and Tivoli Storage Manager on your storage computer.
For more information about TSM, read the following manuals:
In addition, you must configure Informix Interface for TSM and perform other TSM configuration tasks on your Informix database server computer. These tasks are explained in the following sections.
The Informix Interface for TSM communicates with the TSM server using the TSM API. By default, Informix Interface for TSM uses the client user options file (dsm.opt) and client system options file (dsm.sys) located in the TSM API installation directory:
Use the sample dsm.opt.smp and dsm.sys.smp files distributed with the TSM API to help you get started quickly.
You must be the root user to perform edits to the dsm.opt and dsm.sys files.
See TSM Installing the Clients and TSM Trace Facility Guide for information regarding options you can specify in these files.
The TSM client user options file, dsm.opt, must refer to the correct TSM server stanza, as listed in the dsm.sys file.
Set the following options in the dsm.opt file:
The TSM client systems options file, dsm.sys, must refer to the correct TSM server address and communication method.
The following TSM options are the most important to set in the dsm.sys file:
The SERVERNAME option in the dsm.opt and dsm.sys files define server stanza names only. The TCPSERVERADDRESS option controls which server is actually contacted.
You can set up multiple server stanzas in the dsm.sys file. See the Tivoli Storage Manager Backup-Archive Client Installation and User's Guide for information about multiple server stanzas.
When you back up a database, the default management class for your node is used. You can override the default value with a different value that is specified in the INCLUDE option. This option is placed in the include-exclude options file. The file name of the include-exclude options file is in the client system options file (dsm.sys). For more information, see the Tivoli Storage Manager Backup-Archive Client Installation and User's Guide.
Use the following naming conventions for ON-Bar files:
/dbservername/dbservername/dbspacename/level
/dbservername/dbservername/server_number/unique_logid
For a database backup, an example of the INCLUDE statement is as follows:
Include /dbserverA/dbserverA/dbspaceA/* InformixDbMgmt
For a logical log back up, an example of the INCLUDE statement is as follows:
Include /dbserverA/dbserverA/55/* InformixLogMgmt
where the number 55 is the value of the SERVERNUM parameter in the ONCONFIG file.
Before backing up to and recovering from a TSM server, you must have a TSM registered node name and a password. The process of setting up a node name and password is called registration. After the Informix Interface for TSM node is registered with a TSM server, you can begin using the Informix Interface for TSM to back up and restore your Informix storage spaces and logical logs. If your workstation has a node name assigned to the TSM backup-archive client, you should have a different node name for Informix Interface for TSM. For information about performing the registration process, see the Tivoli Storage Manager Backup-Archive Client Installation and User's Guide.
To initialize the password for Informix Interface for TSM, use the txbsapswd program. This program sets up a connection with the server stanza that you specified in the dsm.opt file. You must run the txbsapswd program as user root before using Informix Interface for TSM.
To initialize the password: