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) =

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.

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.