How to Set UCMDB Server Time, Change Time Zone Setting, or Correct System-induced Clock Drift

Document ID:KM03685423
Creation Date:20-Jul-2020
Modified Date:20-Jul-2020
- Micro Focus Products:
  universal cmdb 2018.05
  
  universal cmdb 2018.08
  
  universal cmdb 2018.11
  
  universal cmdb 2019.02
  
  universal cmdb 2019.05
  
  universal cmdb 2019.08
  
  universal cmdb 2019.11

Summary

When changing the UCMDB server system time backward or forward on the database server, administrators should follow a scenario that eliminates risk of unresponsive servers and/or data inconsistencies (for both standalone or high-availability based UCMDB systems).

Question

Note: UCMDB server (also all HA nodes servers) and the database server should be based on UTC time. This helps preventing issues caused by time zone and daylight savings time changes.

To do so,

Stop UCMDB server.

In case of cluster environment, stop all the nodes.
Perform actions needed to change the system time.
On the UCMDB server machine, execute the following command:
- Windows: Go to the C:\UCMDB\UCMDBServer\tools\dbscripts folder, and run the following command from command prompt:
  
  dbtool resetClusterConf
- Linux: /opt/UCMDB/UCMDBServer/tools/dbscripts/dbtool.sh resetClusterConf
Restart UCMDB server.