Sunday, April 10, 2011

TSM V6.2.1 Windows Installation Issue (ANR0238E)

Over the last couple of weeks, I've been studying for the Implementation of IBM Tivoli Storage Manager V6.2 certification. Since I hadn't touched TSM for over a year and a half, it was probably best that I went ahead and installed it.

I decided to download the latest version (6.2) for Windows, mainly because I don't actively have access to a Linux or AIX machine at the moment.

When installing IBM Tivoli Storage Manager V6.2.1 for Windows (X64), I ran across a painful issue whereby I was unable to initialize the server instance at the completion of the installation.

When I would start the TSM server, I would receive the following error:

(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.

ANR4726I The ICC support module has been loaded.
ANR0990I Server restart-recovery in progress.
ANR0152I Database manager successfully started.
ANR0238E A database recovery task is prohibiting activation of TSMDB1 with
sqlcode -1116.

Error SQLCode 1116 definition is: A connection to or activation for database name cannot be made because of BACKUP PENDING.

To resolve the problem, you need to do the following steps:
1. Delete any data inside the TSM database, activelog, archivelog directories.
2. Drop the DB2 TSM database
3. Execute dsmserv format command specifying the database, active and archivelog directories
.

Once Step 3 is complete, a successful backup of the TSM DB will have hopefully completed. Then simply initialize the server!

No comments:

Post a Comment