Remove an additional language from Maximo

Maximo is a multi-language platform that allows us to enable one or more additional languages (or secondary languages) either using the TDToolkit[.bat|.sh] command or from “Tivoli’s Process Automation Suite Configuration Tool“.

However, should you need to remove a secondary language, there is no tool or command to do so. For this reason, I detail below a procedure to eliminate it (the language to be eliminated in this example will be French).

1. Stop Maximo services
2. Identify the Maximo base language

select varvalue from maxvars where varname = 'BASELANGUAGE';

3. List ALL enabled languages (including base), to get the language code for the additional language you want to remove.

select languagename, maxlangcode from language where enabled = 1;

4. Check the version information of all Maximo components for the language to be removed (French – FR)

select pmpname, version from tdtversion where language = 'FR';

5. Disable the language with the following statement

update language set enabled = 0 where maxlangcode = 'FR';
commit;

6. Delete the translations made in the language to delete. To do this, the SQL statements returned by the following query must be executed.

-- ORACLE or DB2
select 'delete from ' || langtablename || ' where langcode = ''FR'';' from maxtable where langtablename is not null order by tablename;
-- SQL SERVER
select 'delete from ' + langtablename + ' where langcode = ''FR'';' from maxtable where langtablename is not null order by tablename;

  This is an example of the SQL statements that the above query would return:

delete from L_ALNDOMAIN where langcode = 'FR';
delete from L_ASSETATTRIBUTE where langcode = 'FR';
delete from L_COMMTEMPLATE where langcode = 'FR';
delete from L_COMPANIES where langcode = 'FR';
...
...
commit;

7. Remove language from the language version tracking table

delete from tdtversion where language = 'FR';
commit;

Note: Under no circumstances should you remove the Maximo base language.