Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2005
    Posts
    103

    Unanswered: Archiving transaction logs to TSM

    AIX 5.3
    DB2 8.2

    I set (LOGARCHMETH1) = TSMB_LOG1

    Now, I get this in db2diag.log:
    2007-04-26-14.07.16.465566-240 I1140956A426 LEVEL: Error
    PID : 528390 TID : 1 PROC : db2logmgr (SIGMA01) 0
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
    MESSAGE : Failed to archive log file S0000000.LOG to TSM chain 0 from
    /db2/<dbname>/log_repos/failover/db2inst1/<DBNAME>/NODE0000/C0000000/
    with rc = 11.

    Can anyone shed some light on the error, or, at least, list what configuration parameters need values so to use TSM?
    Thanks.

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    have you been authorized for tsm - a node has been setup
    there is a redbook : setting up tsm for db2 backups..
    have you setup the dsm config.....
    have a look
    http://www.redbooks.ibm.com/abstract...6247.html?Open
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by wehrle
    with rc = 11.
    TSM return code 11 means "no space on the TSM server".
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    Jul 2005
    Posts
    103
    Thanks.

    My problem seems to have been a dsm.opt file without an appropriate entry in it. I now seem to be archiving transaction logs to TSM.

    The Red Book mentioned the use of db2adutl to confirm this, I was curious, and so I tried "db2adutl query" . This is what I get:

    Error: Initialize session failed with ADSM return code 137

    Any suggestions on this one?

  5. #5
    Join Date
    Jun 2006
    Posts
    471
    have you setup the variables dsmi_xxx
    these are the variables used by the api interface
    the dsm.opt entries are for regular filesystem backup to tsm
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  6. #6
    Join Date
    Jul 2005
    Posts
    103
    When I have an appropriate entry in dsm.opt, archiving transaction logs to TSM seems to work. When I do not have a valid entry in dsm.opt, I get the rc = 11 error.

Posting Permissions

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