今天碰到 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