解决配置tsm在格式化数据库信息的时候报错:This database name already exists-warehouse的方法_MySQL, Oracle及数据库讨论区_Weblogic技术|Tuxedo技术|中间件技术|Oracle论坛|JAVA论坛|Linux/Unix技术|hadoop论坛

总帖数

每页帖数

1/1页

返回列表

发起投票

查看: 2863 | 回复: 0

主题： 解决配置tsm在格式化数据库信息的时候报错:This database name already exists-warehouse的方法

本主题由 koei123 于 2015-6-1 14:57:12 移动

dwx8023

注册用户

等级：上尉
经验：612
发帖：114
精华：0
注册：2011-11-8
状态：离线
发送短消息息给dwx8023

加好友发送短消息息给dwx8023

发消息

发表于：

2015-3-26 14:09:56 | [全部帖] [楼主帖]

楼主

执行下面命令格式化数据库时由于目录权限的问题报错了,再执行的时候提示:

ANR0367W The server failed to format the database TSMDB1. This database name already exists.

Problem(Abstract)After a failed initialisation of the TSM Server, the second attempt may fail with ANR0367W The server failed to format the database TSMDB1. This database name already exists.

在网上搜索一下，发现别人提供的解决办法如下：

--===================================

ANR0367W The server failed to format the database TSMDB1. This database name already exists.

Problem(Abstract)：After a failed initialisation of the TSM Server, the second attempt may fail with ANR0367W The server failed to format the database TSMDB1. This database name already exists.
Symptom：After a failed initialisation of a new TSM Server, the second attempt may fail with the following:
Tivoli Storage Manager for AIX
Version 6, Release 1, Level 2.0
Licensed Materials - Property of IBM
(C) Copyright IBM Corporation 1990, 2009.
All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.
ANR7801I Subsystem process ID is 966700.
ANR0900I Processing options file /usr/tivoli/tsm/server/bin/dsmserv.opt.
ANR7811I Using instance directory /tsmdata/server1
ANR4726I The ICC support module has been loaded.
ANR0152I Database manager successfully started.
ANR0152I Database manager successfully started.
ANR0367W The server failed to format the database TSMDB1. This database name already exists.
Error 2160 initializing the database
ANR2678E Server database format failed.

Cause：While the initialization failed, the database was created.

Resolving the problem：
Method 1:
From the TSM Server installation directory, issue the following command:
dsmserv removedb TSMDB1
If it succeeds, you can retry creating an instance. If it fails, we will need to try method 2.
Method 2:
For the second method, is to drop the database from DB2.
set db2instance=server1
db2stop force
db2start
db2 drop database TSMDB1
Method 3:
For the third method is to do an uncatalog of the database.
set db2instance=server1
db2 uncatalog database tsmdb1
--===================================

用文章中提到的第二种办法先把存在db2 dbdrop掉:

Method 2:
For the second method, is to drop the database from DB2.
set db2instance=server1
db2stop force
db2start
db2 drop database TSMDB1
--=====================================

之后把权限搞定了重新继续执行下面命令初始化成功了:

[tsminst1@udev ~]$ dsmserv format dbdir=/tsmdb/db activelogdir=/tsmdb/dblog archlogdir=/tsmdb/dbarchlog
ANR7800I DSMSERV generated at 10:49:41 on May 12 2010.
Tivoli Storage Manager for Linux/x86_64
Version 6, Release 2, Level 1.0
Licensed Materials - Property of IBM
(C) Copyright IBM Corporation 1990, 2010.
All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.
ANR7801I Subsystem process ID is 5446.
ANR0900I Processing options file /home/tsminst1/dsmserv.opt.
ANR7814I Using instance directory /home/tsminst1.
ANR4726I The ICC support module has been loaded.
ANR0152I Database manager successfully started.
ANR1380I The buffer pool monitor switch is enabled.
ANR0992I Server's database formatting complete.
ANR0369I Stopping the database manager because of a server shutdown.
ANR2976I Offline DB backup for database TSMDB1 started.
ANR2974I Offline DB backup for database TSMDB1 completed successfully.

--转自