After installing Adaptive Server and Backup Server:
Install and configure the TSM client API on the same machine as Adaptive Server and Backup Server. Install and configure the TSM server on the same or different machine. See the TSM documentation for instructions.
Set these TSM-specific environment variables on the Backup Server machine:
DSMI_DIR – TSM installation directory location
DSMI_LOG – TSM error log location
DSMI_CONFIG – TSM configuration file
DSMI_LIB – TSM shared library fully qualified path name
For example, assuming that Adaptive Server, Backup Server, and the TSM client API are installed on a Linux AMD 64-bit machine
DSMI_DIR – /opt/tivoli/tsm/client/api/bin64
DSMI_LOG – /opt/tivoli/tsm/client/error_log
DSMI_CONFIG – /opt/tivoli/tsm/client/api/bin64/dsm.opt
DSMI_LIB – /opt/tivoli/tsm/client/api/bin64/libAPITSM64.so
Update the TSM system file (dsm.sys) and the TSM configuration file (dsm_opt). At a minimum, set these parameters:
SERVERNAME – TSM server name.
COMMMETHOD – TSM server communication type.
TCPPORT – TSM server port number.
TCPSERVERADDRESS – fully qualified name of TSM server.
NODENAME – registered name of TSM client.
PASSWORDACCESS – access method type of TSM password. Set to “generate”.
PASSWORDDIR – directory location of TSM password.
To improve performance, set the appropriate TSM Client configuration
parameters. See the TSM documentation for instructions.
Create the TSM client node at the TSM server. See the TSM documentation for instructions.
Use the sybtsmpasswd utility to:
Register the TSM client node with TSM server.
Generate the TSM-encrypted password file on the TSM client node.
sybtsmpasswd generates the TSM password file (TSM.PWD) in the directory specified by the PASSWORDDIR parameter in the TSM configuration file. (See step 3.)
Execute sybtsmpasswd while logged in as the operating system user “root.” sybtsmpasswd prompts for the existing password and the new password for the registered TSM client node.
Execute sybtsmpasswd only when you
set up TSM or change the TSM client node name, user name, or password.
Start Backup Server.
From the TSM server, grant the TSM client node name permission to delete backup copies at the TSM server. See the TSM documentation for instructions.
This enables these Sybase operations at the TSM client node:
sp_deletesmobj
dump database database_name to “syb_tsm::object_name“ with init
After completing these steps, you can execute these commands and stored procedures:
dump database
dump transaction
load database
load transaction
sp_querysmobj
sp_deletesmobj