Preparation:

Add a new key into registry (regedit) HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System

Dword32 LocalAccountTokenFilterPolicy 1

This requires a reboot

c:> netsh advfirewall firewall add rule name="TSM server port 1500 client" dir=in action=allow protocol=TCP localport=1500
c:> netsh advfirewall firewall add rule name="TSM server internal" dir=in action=allow protocol=TCP localport=137,139,445 profile=domain,private
c:> netsh advfirewall firewall add rule name="TSM OPCenter" dir=in action=allow protocol=TCP localport=11090
c:> netsh advfirewall firewall add rule name="TSM admin port 1550" dir=in action=allow protocol=TCP localport=1550

secpol.msc

Install TSM server:

change PATH for TSM c:\TSM Operation center port 11090

passwd operation center SSL: xxxxxxxx

As Windows CLI (cmd)

net user tsminst1 password /add
net localgroup Administrators tsminst1 /add
net localgroup DB2ADMNS tsminst1 /add
net localgroup DB2USERS tsminst1 /add

dsmicfgx

enable print and file sharing FW 445

set passexp 9999
SET ACTLOGRETENTION 90
SET EVENTRETENTION 180
SET SUMMARYRETENTION 180
reg lic file=tsmee.lic

SET COMMTIMEOUT 3600
SET EXPINTERVAL 0
SET IDLETIMEOUT 60
SET MAXSESSIONS 250
SET NUMOPENVOLSALLOWED 20
SET DEDUPREQUIRESBACKUP NO

Tivoli Storage Manager DB2 instance directory location. Technote (troubleshooting)

Problem(Abstract)

A Tivoli Storage Manager server is installed and creates the DB2 instance directory for the Tivoli Storage Manager server on the root of the installation disk. Resolving the problem

It is not possible to change the DB2 Instance directory for the Tivoli Storage Manager during installation to a specific directory path. It will be installed at the root of the physical drive letter. As per the installation instructions the following command must be used :

db2 update dbm cfg using dftdbpath instance_location

Instance_location can only be a drive letter, not a directory path.

C:\TSM\db2\BIN>db2ilist
SERVER1

C:\TSM\db2\BIN>db2idrop server1
C:\TSM\db2\BIN>db2ilist

C:\Windows\System32>sc delete "IBM Spectrum Protect SERVER1"

Delete the registry key server1

HKEY_LOCAL_MACHINE\SOFTWARE\IBM\ADSM\CurrentVersion\Server\SERVER1

ANR2984E Database backup terminated due to environment or setup issue related to DSMI_CONFIG - DB2 sqlcode -2033 sqlerrmc 406.

This issue occurs only on Windows systems. To resolve the issue, configure the client API options file for IBM Db2 by completing the following steps. These instructions also apply if you installed a previous version of the server with a V8.1.6 client.

1. Determine the location of the Db2 instance directory by issuing the following command:

db2set -i database_instance_name db2instprof

where database_instance_name is the name of the database instance.

For example, if tsminst1 is the database instance name, issue the following command:

$ db2set -i tsminst1 db2instprof

By default, the client options file that you will create in Step 2 is named dsm.opt and is located in a subdirectory that has the same name as the database instance. The subdirectory is located in the Db2 instance directory path that is returned when the previous command is issued.

For example, if the database instance name is tsminst1 and the Db2 instance directory is c:\programdata\ibm\db2\db2tsm1, the client options file will be stored at the following location with the default name dsm.opt: c:\programdata\ibm\db2\db2tsm1\tsminst1\dsm.opt

Tip: Optionally, you can configure the DSMI_CONFIG environment variable to specify an alternative name and location for the client options file.

2. Create an API client options file that is called dsm.opt with the following contents: *

nodename $$_TSMDBMGR_$$
commmethod tcpip
tcpserveraddr localhost
tcpport port_number

where:

  The **nodename** parameter specifies the node name that the client API uses to connect to the server during database backup operations. To ensure that the database can be backed up, this value must be $$_TSMDBMGR_$$.
  The **commmethod** parameter specifies the communication method that the client API uses to contact the server.
  The **tcpserveraddr** parameter specifies the server address that the client API uses to contact the server for database backup operations. To ensure that the database can be backed up, this value must be localhost.
  The **tcpport** parameter specifies the port number that the client API uses to contact the server for database backup operations. Enter the same tcpport value that is specified in the dsmserv.opt server options file. By default, the port number is 1500.

3. Save the API client options file in the appropriate directory as described in Step 1.