Format Completed with Return Code 499

If you have been trying to upgrade TSM 5 to TSM 6 & received the following error:  “Format Completed with Return Code 499” Then follow the steps below, which I have got from IBM article to fix the problem. I have used these steps & they have worked for me & they should work for you too.

If this is not an upgrade & you started with a clean install, but you still got a missed up database then follow up the steps below & then follow up: “How do you remove a server instance without uninstalling the TSM server?” which will remove the corrupted instance & database & you will be ready for trying to initialize the instance again. Below is the how-to copied from IBM KB.


Upgrade wizard fails during Format of database

Upgrade Wizard for Tivoli Storage Manager from 5.X to 6.X fails with the following error:

Format Completed with Return Code 499

There are no additional error messages in the Upgrade wizard screen. The file Format.out does not get created.

The user id created for the Tivoli Storage Manager instance has not been added to the DB2ADMNS or DB2USERS group

Resolving the problem

Add the Tivoli Storage Manager instance user to the DB2ADMNS and DB2USERS GROUP by running the following on Windows command line:

net localgroup DB2ADMNS user_ID /add
net localgroup DB2USERS user_ID /add

Log off and log back on as the Tivoli Storage Manager instance user and run the upgrade wizard again.


Remember after completing the above steps to follow the article pointed to in the beginning of the article if this was a new clean install & not an upgrade.

5 Responses to 'Format Completed with Return Code 499'

  1. zhiwei - October 9th, 2010 at 3:54 am

    hello!Thank you for your article.It’s very useful to us.Please forgive me for unless your permission translating this article to chinese.And then,this is our。Your article is here:。

  2. admin - January 12th, 2011 at 1:10 pm

    Hi Zhiwei,

    Sorry for the very late reply, & I am glad you did translate and spread the knowledge. Further, thank you for the credit link :).


  3. Shwan - February 15th, 2011 at 1:13 pm

    Hello Eiad,

    Can you give me an article or a link where i can get a step by step procedure for performing TSM Disaster Recovery, as in kind of just all in one document type, if possible.

  4. Arunkumar - July 20th, 2011 at 11:57 pm

    Hi I need to run multiple instance of TSM Server in one server machine. How can i achieve it? Could you please provide me documents or links?

  5. Arunkumar - July 20th, 2011 at 11:58 pm

    Hi I need tape library configuration complete detail? Could you Please provide me?

Leave a Reply