Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    58

    Lightbulb Unanswered: Failed to archive log to TSM -- v8.2

    Hi,

    I was trying to turn logretain ON to archive logs to TSM for the first time. After updating db cfg parameters, recycled instance and inserted test data, got the following messages. I do not think it is TSM storage issue as I was able to perform full db backup using TSM successfully.

    Is there anything I missed? Any recommendations would be greatly appreciated. Thanks in advance.

    ================

    MESSAGE : Failed to archive log file S0000000.LOG to TSM chain 0 from
    /db2dat/emplq/db2emplq/NODE0000/SQL00001/SQLOGDIR/ with rc = 11.

    2008-09-17-12.29.33.777354-240 I880498C370 LEVEL: Warning
    PID : 3285196 TID : 1 PROC : db2logmgr (EMPLQ) 0
    INSTANCE: db2emplq NODE : 000
    FUNCTION: DB2 UDB, data protection, sqlpgRetryFailedArchive, probe:4780
    MESSAGE : Still unable to archive log file 0 due to rc 11 for LOGARCHMETH1
    using method 2 and target .

    ================ db cfg parameters

    Log retain for recovery enabled (LOGRETAIN) = RECOVERY
    User exit for logging enabled (USEREXIT) = OFF

    First log archive method (LOGARCHMETH1) = TSM
    Options for logarchmeth1 (LOGARCHOPT1) =
    Second log archive method (LOGARCHMETH2) = OFF

    TSM management class (TSM_MGMTCLASS) =
    TSM node name (TSM_NODENAME) = emplq_db
    TSM owner (TSM_OWNER) = db2emplq
    TSM password (TSM_PASSWORD) =

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    TSM return code 11 is DSM_RS_ABORT_NO_STO_SPACE_SKIP, meaning that either there is no storage available in the storage class there is or some problem with permissions or policies.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Apr 2004
    Posts
    58
    Once the Archive copy group definition for the management class is created on the TSM server, I was able to archive the log files successfully to TSM.

    Thanks.

Posting Permissions

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