IBM Tivoli Storage Manager, Version 7.1

AIX: Preparing the database manager for database backup

To back up the data in the database to Tivoli® Storage Manager, you must enable the database manager and configure the Tivoli Storage Manager application programming interface (API).

About this task

AIX operating systems Starting with Tivoli Storage Manager V7.1, it is no longer necessary to set the API password during a manual configuration of the server. If you set the API password during the manual configuration process, attempts to back up the database might fail.

If you use the Tivoli Storage Manager configuration wizard to create a Tivoli Storage Manager server instance, you do not have to complete these steps. If you are configuring an instance manually, complete the following steps before you issue either the BACKUP DB or the RESTORE DB commands.

Attention: If the database is unusable, the entire Tivoli Storage Manager server is unavailable. If a database is lost and cannot be recovered, it might be difficult or impossible to recover data that is managed by that server. Therefore, it is critically important to back up the database.

In the following commands, replace the example values with your actual values. The examples use tsminst1 for the server instance user ID, /tsminst1 for the Tivoli Storage Manager server instance directory, and /home/tsminst1 as the server instance users home directory.

Set the Tivoli Storage Manager API environment-variable configuration for the database instance:
1. Log in using the tsminst1 user ID.
2. When user tsminst1 is logged in, ensure that the DB2® environment is properly initialized. The DB2 environment is initialized by running the /home/tsminst1/sqllib/db2profile script, which normally runs automatically from the profile of the user ID. Ensure the .profile file exists in the instance users home directory, for example, /home/tsminst1/.profile. If .profile does not run the db2profile script, add the following lines:
```
if [ -f /home/tsminst1/sqllib/db2profile ]; then
      . /home/tsminst1/sqllib/db2profile
  fi
```
3. For the instance_directory/sqllib/userprofile file, add the following lines:
```
DSMI_CONFIG=server_instance_directory/tsmdbmgr.opt
DSMI_DIR=server_bin_directory/dbbkapi
DSMI_LOG=server_instance_directory
export DSMI_CONFIG DSMI_DIR DSMI_LOG 
```
  For the instance_directory/sqllib/usercshrc file, add the following lines:
```
setenv DSMI_CONFIG=server_instance_directory/tsmdbmgr.opt
setenv DSMI_DIR=server_bin_directory/dbbkapi
setenv DSMI_LOG=server_instance_directory
```
Log out and log in again as tsminst1, or issue this command:
```
. ~/.profile
```
Tip: Ensure that you enter a space after the initial dot (.) character.
Create a file that is called tsmdbmgr.opt in the server_instance directory, which is in the /tsminst1 directory in this example, and add the following line:
```
SERVERNAME TSMDBMGR_TSMINST1
```
Remember: The SERVERNAME that you use must be consistent in the tsmdbmgr.opt and dsm.sys files.
As root user, add the following lines to the Tivoli Storage Manager API dsm.sys configuration file. The dsm.sys configuration file is in the following default location:
- server_bin_directory/dbbkapi/dsm.sys
```
servername TSMDBMGR_TSMINST1 
commmethod tcpip 
tcpserveraddr localhost 
tcpport 1500 
errorlogname /tsminst1
nodename $$_TSMDBMGR_$$ 
```
where
- servername matches the servername in tsmdbmgr.opt.
- commethod is the client API used to contact the server for database backup. This value can be tcpip or sharedmem. For sharedmem, see step 5..
- tcpserveraddr is the server address that the client API uses to contact the server for database backup. This value must be localhost for database backup to work.
- tcpport is the port number that the client API uses to contact the server for database backup. Ensure that you enter the same tcpport option that is specified in the dsmserv.opt server options file.
- errorlogname is the error log where the client API logs errors that are encountered during a database backup. This log is typically in the server instance directory. The log can, however, be placed anywhere the instance user ID has write-permission.
- nodename is the node name that the client API uses to connect to the server during a database backup. This value must be $$_TSMDBMGR_$$ for a database backup to work.
Optional: Configure the server to back up the database by using shared memory. In this way, you might be able to reduce the processor load and improve throughput. Complete the following steps:
1. Review the dsmserv.opt file. If the following lines are not in the file, add them:
```
commmethod sharedmem 
shmport port_number
```
  where port_number specifies the port to be used for shared memory.
2. In the dsm.sys configuration file, locate the following lines:
```
commmethod tcpip 
tcpserveraddr localhost 
tcpport port_number
```
  Replace the specified lines with the following lines:
```
commmethod sharedmem 
shmport port_number
```
  where port_number specifies the port to be used for shared memory.

Feedback