Here is a quick start guide for backing up DB2 to
TSM.  This will be based on the WinNT OS and the
4.11 TSM Api level.

DB2 provides native support for backing up to TSM.  DB2 utilizes the
TSM Api to perform these backups.  The following is the minimum steps
necessary to get DB2 to allow backups to TSM.

1.      Install TSM Backup/Archive client (this includes the api)

2.      Create a plain text file dsm.opt in x:\progra~1\Tivoli\TSM\api
       It must contain at least the following.
               COMMMETHOD TCPIP
               TCPSERVERADDRESS xxx.xxx.xxx.xxx
               NODENAME DB2TSM
               PASSWORDACCESS GENERATE

3.      Register the node DB2TSM on the TSM server
       It is recommended to create a new DOMAIN on the TSM server for this node.
       If you do create a new domain, make sure the node is updated with the new
domain.
       It needs only one management class with a backup copygroup that has the
       following retention settings.
               VEREXIST=1
               VERDELETED=0
               RETEXTRA=0
               RETONLY=0

4.      In Control Panel/System for the environment SYSTEM variables specify the
       variable DSMI_CONFIG with the value x:\progra~1\Tivoli\TSM\api\dsm.opt
       (Note,  DSMI_CONFIG is case sensitive.  The system not the user variable
needs to be set)

5.      Reboot the system or restart the db2 services so that the DSMI_CONFIG
       variable will be loaded into the db2 runtime engine.  Otherwise a backup 
to
       TSM will fail with error 406 DSM.OPT file not found.

6.      Sign-on as db2admin and change to the ...\sqllib\adsm directory

7.      Run the executable 'dsmapipw' and follow the prompts.  It will ask for
       the current password, then for a new password, and confirmation of the
       new password.  It should report if it is successful.

8.      Run the db2 command 'db2adutl query' to confirm that the password file
       was correctly set.   If the command comes back and says no db2 objects
       found then it is working (you haven't done any backups yet).  You should
       be able to check the activity log on the TSM server to confirm that the
node
       DB2TSM athenticated.  Db2adutl.exe is located in the  \sqllib\bin 
directory

9.  You can now perform a backup using the db2 command line or the db2
connect gui.
    i.e. backup db DBNAME use tsm

_____________________________________________________________________________________
Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com