Configuring a Tivoli Storage Manager client
Before the Db2® database manager can use an IBM® Tivoli® Storage Manager (TSM) client to manage database or table space backup or restore operations, you must configure the TSM environment.
Before you begin
A functioning TSM client and server must be installed and configured. In addition, the TSM client API must be installed on each Db2 database server. TSM client proxy nodes are supported if the TSM server has been configured to support them. For information on server configuration and proxy node support, see Considerations for using Tivoli Storage Manager or refer to the Tivoli documentation.
Procedure
To configure the TSM environment for use by Db2 database systems:
What to do next
Depending on your backup and log archiving strategies, you might need to perform additional steps to configure the TSM clients if you want to use proxy nodes. Proxy nodes enable you to consolidate backups and log archives of databases existing on multiple client nodes or under multiple users to a common target nodename on the TSM server. This configuration is useful when the administrator or computer that performs the backup can change over time, such as with clusters. The asnodename option also allows data to be restored from a different computer or from a user different than the one that performed the backup.
If you want to use TSM in your Db2 pureScale® environment, proxy node configurations are recommended because each member can be represented as a TSM client or node and be mapped to a common proxy node.
If you do not want to use proxy nodes by default, no additional client setup is required. When you want to perform backup or restore operations using proxy nodes, specify the asnodename value in the OPTIONS parameter when invoking the BACKUP DATABASE or RESTORE DATABASE commands.
- Update database configuration parameters to use different proxy nodes for different databases.
- Update the dsm.sys file to use the same proxy node for all the users and databases on a machine.
Note: Every user-host combination using the same TSM proxy name will appear as the same Db2 instance to TSM. This can mean that if multiple Db2 instances use the same database name in a TSM client-node proxy configuration, then they can potentially overwrite each other's log archives and backup images. To avoid this:
- Create a different proxy hostname for each Db2 instance.
- Do not use TSM's client-node proxy feature if multiple Db2 instances might create databases using the same TSM proxy name.
- TSM client setup using vendoropt, logarchopt1, and logarchopt2
You can set one or more of the following database configuration parameters to enable different proxy node settings for each database:
- To enable commands using TSM (such as backup and restore) to use
proxy nodes, specify the asnodename option in the vendoropt database
configuration parameter, as follows:
where proxynode is the name of the shared TSM proxy node.db2 update db cfg for dbname using vendoropt
'-asnodename=proxynode'
- To configure log archiving to the TSM server, set the logarchmeth1 database
configuration parameter to TSM and specify the name of the proxy node
as the asnodename value in the logarchopt1 database
configuration parameter, as follows:
where proxynode is the name of the shared TSM proxy node.db2 update db cfg for dbname using logarchmeth1 tsm logarchopt1
'-asnodename=proxynode'
You can make similar updates to the logarchmeth2 and logarchopt2 database configuration parameters.
In Db2 pureScale environments, these database configuration parameters are global parameters and you can set them from any member.
- To enable commands using TSM (such as backup and restore) to use
proxy nodes, specify the asnodename option in the vendoropt database
configuration parameter, as follows:
- TSM client setup method using the dsm.sys file
- Edit the dsm.sys file and add the proxy node information,
as follows:
where proxynode is the name of the shared TSM proxy node.asnodename proxynode
- Ensure that the dsm.opt file specified in
the DSMI_CONFIG path contains the name of the
TSM server, as follows:
where servername is the TSM server name.servername servername
- Edit the dsm.sys file and add the proxy node information,
as follows: