lunedì 23 dicembre 2013

ANR2678e return code 499

The problem is with the windows non-unicode applications configuration. DB2 9.5 supports the english (united states) and spanish (españa) for non-unicode applications. In latinamerica generaly the deployment enginieers have in their the Virtual Machines or Windows servers the configuration different to english (united states) or spanish (españa) in the non-unicode applications. This is the problem, DB2 cannot create the TSM database and show the following error:

ANR0162W Supplemental database diagnostic information: -1034:**No State
Information Available (87)**:-1034 (**No Other Information Available (130)**).Failed (sqlca.sqlcode = -1034 ) to create database TSMDB1
Error 2158 initializing the database
ANR2678E Server database format failed.


The solution is:

Go to the control panel > Regional Settings (configuración Regional y de idioma)> open the advanced options tab (opciones avanzadas) and change the language for non-unicode applications to english (united states) or spanish (españa) and that's it.

Rerun the TSM Wizard and the TSM Server will Work fine

This problem is not in the TSM manuals.

Regards
Fernando Alvarez Toledo
TSM Certified Deployment 6.1

http://adsm.org/forum/showthread.php?18114-Problems-Installing-TSM-v6-1