Using the Tivoli api to back up a DB2 DB

JDionne · #1 (**permalink**) 07-07-04, 11:28

I have been chasing this down for about two weeks now. I have had the Tivoli api client installed, but they did not install the API SDK. I have read a good redbook on the topic and I have followed there directions on setting the DSMI variables. Im still getting the same error
SQL2062N An error occurred while accessing media

"D:\PROGRA~1\IBM\SQLLIB\bin\db2tsm.dll". Reason code: "406".

As good as the red book is it is still a bit confusing to me. Im not sure exactly that I have done this correctly. When the TSM client was installed the api runtime files werei nstalled. Is this all that I need from the TSM side?
Has anyone used TSM and DB2 to manage backups and can remeber the steps that they had to take?
Any help would be greeat
Thanx
Jim

mark_maz · #2 (**permalink**) 07-07-04, 12:38

Did you run the following command?

/home/instance/sqllib/adsm/dsmapiw

This initializes the connection to TSM and sets a password that is encrypted and it is stored. This is done so that subsequent authentication attempts to the TSM server are done automatically because you should set it to generate on the server side.

Hope this helps

Mark

JDionne · #3 (**permalink**) 07-07-04, 12:53

I ran the app that u sugested and it finished with out errors. But I am still getting the same error
IBM.com thinks that my DSMI_Config is not pointng to the correct opt file.
Do I need to make an opt file for the api tool? I just copied the original opt file and put it in the api directory. I have then set the varialbe to that dir.

Did I do something wrong?

mark_maz · #4 (**permalink**) 07-07-04, 13:03

This is how we did it

we created a dsm.db2.opt file and a dsm.sys file in /usr/tivoli/tsm/client/api/bin directory (maybe a different location on windows)

We also created a userprofile file in /home/instance/sqllib directory

$ more userprofile
export DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin/dsm.db2.opt
export DSMI_DIR=/usr/tivoli/tsm/client/api/bin
export DSMI_LOG=/archive/proda/work1/tsmtmp
$ pwd
/home/"instance"/sqllib

here are the dsm files

$ more dsm.opt
************************************************** **********************
* Tivoli Storage Manager *
* *
* Sample Client User Options file for AIX and SunOS (dsm.opt.smp) *
************************************************** **********************

* This file contains an option you can use to specify the TSM
* server to contact if more than one is defined in your client
* system options file (dsm.sys). Copy dsm.opt.smp to dsm.opt.
* If you enter a server name for the option below, remove the
* leading asterisk (*).

************************************************** **********************

SErvername "yourserver"
QUIET

$ more dsm.sys
************************************************** **********************
* Tivoli Storage Manager *
* *
* Sample Client System Options file for AIX and SunOS (dsm.sys.smp) *
************************************************** **********************

* This file contains the minimum options required to get started
* using TSM. Copy dsm.sys.smp to dsm.sys. In the dsm.sys file,
* enter the appropriate values for each option listed below and
* remove the leading asterisk (*) for each one.

* If your client node communicates with multiple TSM servers, be
* sure to add a stanza, beginning with the SERVERNAME option, for
* each additional server.

************************************************** **********************

SErvername (this will be what you have your tsm server called for this client)
COMMmethod TCPip
TCPPort 1500
TCPServeraddress TSM server hostname
Nodename (the client name associated with this)
COMPRESSION NO
PASSWORDACCESS GENERATE
txnbytelimit 25600
tcpwindowsize 64
tcpbuffsize 32
tcpnodelay yes
uselargebuffers yes
errorlogretention 32 d
errorlogname /archive/proda/work1/tsmtmp/dsmdb2error.log

SErvername yourserver
COMMmethod TCPip
TCPPort 1500
TCPServeraddress yourserver

Hope this helps

Mark

JDionne · #5 (**permalink**) 07-08-04, 09:05

I have read that when you have the TSM client installed and the api client TSM sees the two as seperate clients. Does this mean that I need to set up seperate hosts to talk to TSM?
Jim

mark_maz · #6 (**permalink**) 07-08-04, 09:48

Not necessarily but DB2 uses the "api" to talk to TSM so that is why that has to be set up. The other "path" for the ba client just needs to have some generic entries if you are not going to use them but TSM still looks at them during start up (I am by no means an expert and feel real lucky to get this working on the first go, we normally have problems as well)

Mark

JDionne · #7 (**permalink**) 07-08-04, 10:21

The tsm admin had already created an opt file. it is as follows

Code:

LANG AMENG
********************************************************************
* IBM Adstar Distributed Storage Manager
*
* Sample dsm.opt for 32-Bit Windows backup and archive Client - V3 level
*
* See options.wri for complete options file documentation
************************************************************************

*====================================================================
* TCP/IP
*====================================================================

commmethod      tcpip
tcpport          1500
TCPServeraddress CNCTSM

************************************************************************
* COMPression
*
* +------------------+----------------------------------------------+
* | COMPression      | ON|OFf                                       |
* +------------------+----------------------------------------------+
* System default: OFf
*
* Option file example:
*
* COMPression ON
* COMPression OFf
************************************************************************

COMPression ON

************************************************************************
* DOMain
*
* +------------------+----------------------------------------------+
* | DOMain           | ALL-LOCAL|domain                             |
* +------------------+----------------------------------------------+
* System default: ALL-LOCAL
*
* Options file examples:
*
* DOMain ALL-LOCAL Q:
************************************************************************


************************************************************************
* EXclude and INclude
*
* +------------------+----------------------------------------------+
* | EXclude          | pattern                                      |
* +------------------+----------------------------------------------+
* | INclude          | pattern                                      |
* +------------------+----------------------------------------------+
*
* EXclude and INclude patterns are written using an extended pattern
* match language.  This language uses the native operating system's
* metacharacters (wildcards) whenever possible.  A list of the
* supported metacharacters for the match language follows:
*
*   Function               AIX       DOS          OS/2
*   ---------------------  --------  --------     ---------
*   Match one character    ?         ?            ?
*   Match n characters     *         *            *
*   Match n directories    /... (1)  \... (1)     \...  (1)
*   Directory Separator    /         \            \
*   Open Character Class   [    [(1)     [(1)
*   Character Class Range  -         -    (1)     -     (1)
*   Close Character Class  ]    ](1)     ](1)
*   Literal Escape         \         \    (1)     \     (1)
*   Drive Separator        none      :            :
*
*
************************************************************************
Exclude "*:\macintosh volume\*"
Exclude "*:\macintosh volume\*.*"
Exclude "*:\macintosh volume\...\*"
Exclude "*:\macintosh volume\...\*.*"
Exclude "*:\microsoft uam volume\*"
Exclude "*:\microsoft uam volume\*.*"
Exclude "*:\microsoft uam volume\...\*"
Exclude "*:\microsoft uam volume\...\*.*"
Exclude "*:\...\EA DATA. SF"
Exclude *:\...\pagefile.sys
Exclude *:\IBMBIO.COM
Exclude *:\IBMDOS.COM
Exclude *:\MSDOS.SYS
Exclude *:\IO.SYS
Exclude *:\...\SYSTEM32\CONFIG\*.*
Exclude *:\...\SYSTEM32\CONFIG\...\*
Exclude *:\disks\*.*
Exclude *:\disks\...\*
Exclude *:\db2\*.*
Exclude *:\db2\...\*

************************************************************************

************************************************************************
* NodeName
*
* +------------------+----------------------------------------------+
* | MACHinename      | client_name                                  |
* +------------------+----------------------------------------------+
* Default:  Netbios Name (NT/Win95 Computer name)
*
* Option file example:
*
* MACHinename
************************************************************************

NODENAME	SCRBBUSUSCNC05


************************************************************************
* REPlace
*
* +------------------+----------------------------------------------+
* | REPlace          | Yes|No|Prompt                                |
* +------------------+----------------------------------------------+
* System default: Prompt
*
* Option file example:
*
* REPlace N
* REPlace Y
************************************************************************


************************************************************************
* SUbdir
*
* +------------------+----------------------------------------------+
* | SUbdir           | Yes|No                                       |
* +------------------+----------------------------------------------+
* System default: No
*
* Option file example:
*
* SUbdir Yes
* SUbdir No
************************************************************************


************************************************************************
* TCPPort
*
* +------------------+----------------------------------------------+
* | TCPPort          | port_addr                                    |
* +------------------+----------------------------------------------+
* Default: 1500
*
* Option file example:
*
************************************************************************
* TCPPORT 1500


************************************************************************
* TCPServeraddress
*
* +------------------+----------------------------------------------+
* | TCPServeraddress | server_addr                                  |
* +------------------+----------------------------------------------+
* Default: None
*
* Option file examples:
*
************************************************************************
* TCPServeraddress localhost

* TCPBUFFSIZE   31
* TCPWINDOWSIZE 24



************************************************************************
* Verbose
*
* +------------------+----------------------------------------------+
* | Verbose          |                                              |
* +------------------+----------------------------------------------+
* System default: Verbose
*
* Option file example:
*
* Verbose
************************************************************************


passwordaccess generate
errorlogretention 7 d
schedlogretention 7 d


COMPRESSALWAYS YES

I just copied it into a diff directory and pointed my DSMI_Config variable to it.

Was this the right thing to do?

Internet Services

Web Development

Digital Marketing

Consumer Tech