Technote (troubleshooting)
Problem(Abstract)
After a failed initialisation of the Tivoli Storage Manager 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 Tivoli Storage Manager 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 Tivoli Storage Manager 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
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
