Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Unanswered: Using the Tivoli api to back up a DB2 DB

    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
    ------------
    And back to SQL Server....I always find my way home
    View my Linkedin profile

  2. #2
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150
    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

  3. #3
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    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?
    ------------
    And back to SQL Server....I always find my way home
    View my Linkedin profile

  4. #4
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150
    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

  5. #5
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    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
    ------------
    And back to SQL Server....I always find my way home
    View my Linkedin profile

  6. #6
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150
    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

  7. #7
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    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?
    ------------
    And back to SQL Server....I always find my way home
    View my Linkedin profile

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •