linux下数据库备份失败,ANR2983E Linux平台数据库备份失败sqlcode -2033 sqlerrmc 168

Problem

Linux平台Tivoli Storage Manager服务器数据库备份失败，失败信息为ANR2983E，

DB2 sqlcode -2033 sqlerrmc 168

Symptom

当执行数据库备份时，Tivoli Storage Manager服务器日志中出现下面的错误信息：

ANR0424W Session 198 for node $$_TSMDBMGR_$$ (DB2/LINUXX8664) refused - invalid password submitted.

ANR0403I Session 198 ended for node $$_TSMDBMGR_$$ (DB2/LINUXX8664).

ANR2983E Database backup terminated due to environment or setup issue related to DSMI_DIR - DB2 sqlcode -2033 sqlerrmc 168 .

Cause

配置文件dsm.sys中关于Tivoli Storage Manager数据库备份的部分中，PASSWORDACCESS参数被设置成了generate。

Environment

Tivoli Storage Manager 7.1在Linux平台

Resolving The Problem

请执行以下步骤来解决‘sqlerrmc 168’的错误：

1. 在dsm.sys文件中关于Tivoli Storage Manager服务器数据库备份的部分中，删除"PASSWORDACCESS generate"

2. 确保Tivoli Storage Manager服务器数据库备份的部分只包含以下内容：

-----------------

servername TSMDBMGR_TSMINST1

commmethod tcpip

tcpserveraddr localhost

tcpport 1500

errorlogname /tsminst1

nodename $$_TSMDBMGR_$$

----------

关于Tivoli Storage Manager服务器数据库备份设置请参考Linux: Preparing the database manager for database backup

Related Information

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Component":"Server","Platform":[{"code":"PF016","label":"Linux"}],"Version":"7.1","Edition":"All Editions","Line of Business":{"code":"LOB26","label":"Storage"}}]