IBM Support

Adding a timezone if it is missing in the Maximo system

Question & Answer


Question

How can you add a timezone if it is not listed in the Maximo system?

Answer


First of all, the timezone used in the Maximo should be a valid Java timezone, which follows the TZ database. http://en.wikipedia.org/wiki/List_of_tz_database_time_zones
If there is a timezone missing in Maximo, you need to check that database first to get the valid timezone ID. Then the missing time zone should be configured in the Maximo SYNONYMDOMAIN table.

For example, timezone 'GMT +11:00 with no DST' is not available in Maximo time zones as default.
In that case, please follow the steps below :
1. Check the timezone data which timezone ID is valid for 'GMT +11:00 with no DST' and which area should be affected.

2. You then need to configure a new timezone into the Maximo timezone domain. But, it's not allowed to enter a new Maxvalue in the Maximo user interface. So you need to use a script like below.

For an Oracle database:

INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DESCRIPTION. DEFAULTS, SYNONYMDOMAINID,VALUEID) VALUES ('TIMEZONE', 'Pacific/Noumea', 'Pacific/Noumea', '(GMT + 11.00 DST/N) New Caledonia', 1, synonymdomainseq.nextval, 'TIMEZONE|Pacific/Noumea');

For a DB2 database:

INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DESCRIPTION. DEFAULTS, SYNONYMDOMAINID,VALUEID) VALUES ('TIMEZONE', 'Pacific/Noumea', 'Pacific/Noumea', '(GMT + 11.00 DST/N) New Caledonia', 1, NEXTVAL FOR synonymdomainseq, 'TIMEZONE|Pacific/Noumea');


For a SQL Server database:

1) SELECT MAX(SYNONYMDOMAINID)+1 FROM SYNONYMDOMAIN

If the returned value is ###,

2) INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DESCRIPTION. DEFAULTS,
SYNONYMDOMAINID,VALUEID) VALUES ('TIMEZONE', 'Pacific/Noumea', 'Pacific/Noumea',
'(GMT + 11.00 DST/N) New Caledonia', 1, ### , 'TIMEZONE|Pacific/Noumea');

3) UPDATE MAXSEQUENCE SET MAXRESERVED = ### + 1 WHERE TBNAME ='SYNONYMDOMAIN' AND NAME = 'SYNONYMDOMAINID'

Commit the database changes according to the database type.

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

Document Information

More support for:
IBM Maximo Asset Management

Software version:
7.5, 7.6

Document number:
276239

Modified date:
17 June 2018

UID

swg21981259

Manage My Notification Subscriptions