db2 备份 tsm 报错

来源：互联网发布：单片机at下载编辑：程序博客网时间：2024/05/18 03:09

今天碰到 db2 的tsm 备份报错：

备份脚本：

db2 backup db fscnprd online incremental use tsm include logs >> $logfile

Step1:

head fscnprd.1.20120320182011.log
SQL2033N An error occurred while accessing TSM during the processing of a
database utility. TSM reason code: "137".

Step2:sulotion:

root@A05GPSGLDB1A:/db2home/db2fitx/sqllib/adsm>./dsmapipw

*************************************************************
* Tivoli Storage Manager                                    *
* API Version = 5.5.2                                       *
*************************************************************
Enter your current password:
Enter your new password:
Enter your new password again:
*** Server signon failed: (137) Authentication failure!
root@A05GPSGLDB1A:/db2home/db2fitx/sqllib/adsm>ex
:q
root@A05GPSGLDB1A:/db2home/db2fitx/sqllib/adsm>./dsmapipw

*************************************************************
* Tivoli Storage Manager                                    *
* API Version = 5.5.2                                       *
*************************************************************
Enter your current password:
Enter your new password:
Enter your new password again:

Your new password has been accepted and updated.

Step2:

In the tsm server:

tsm: TSM>unlock node A05GPSGLDB1A
ANR2066I Node A05GPSGLDB1A unlocked.

tsm: TSM>update node A05GPSGLDB1A abcd1234
ANR2063I Node A05GPSGLDB1A updated.

tsm: TSM>unlock node A05GPSGLDB1A
ANR2067I Node A05GPSGLDB1A is already unlocked.

Step3:

下面把密码写入 tsm local:

./dsmc

id: a05gpsgldb1a

password:abcd1234

Step3:

开始手工备份：

db2 backup db fscnprd online incremental use tsm include logs >> $logfile

head fscnprd.1.20120320184704.log

Backup successful. The timestamp for this backup image is : 20120320184705