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.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21981259