IBM Support

HOW TO: Remove or Uninstall additional language in Maximo

Technical Blog Post


Abstract

HOW TO: Remove or Uninstall additional language in Maximo

Body

Ever wonder how to remove a secondary or an additional language in Maximo? Today's your lucky day as I will walk you through on how you can do it in this blog entry.

 

First of all, there is no functionality of TDToolkit that will remove a secondary language. Therefore we will be doing this activity in the back-end, direct to your database.

 

We can start by viewing your available languages in your database. To view all your installed additional languages, run the following query against your database:

select languagename, maxlangcode from language where enabled = 1;

*This will list ALL languages including the base language.

e.g.:

image

 

 

 

 

 

If you are not sure what your base language is, run the following query:
select varvalue from maxvars where varname = 'BASELANGUAGE';

e.g.:

image

 

 

 

 

Once you know the language code for the language you want to remove, run the following SQL command against your database.

update language set enabled = 0 where maxlangcode = 'DE';

*Replace the DE with the code of the language you want to remove.

*This will disable the language but it will not remove the actual translation.

 

If you want to remove the actual translation in the database, continue on following the instructions below:

 

1) Run the following command and replace the DE with your language code.
select 'delete from ' || langtablename || ' where langcode = ''DE'';' from maxtable where langtablename is not null;

 

2) Run the output from the SQL in step 1 separately, SQLServer might need some tweaking to work if the table names are case sensitive.

3) Finally remove the language from the table used to keep track of versions:
delete from tdtversion where language = 'DE';

*This will remove the actual translation from the database.

 

IMPORTANT NOTE: Keep in mind that the MXServer needs to be restarted after either the disabling or the removal of an additional language. Make sure you do not disable the Base Language.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

UID

ibm11130313