Will the Brazil DST change in 2018 affect CA Performance Management

Document ID : KB000118504
Last Modified Date : 25/10/2018
Show Technical Document Details
Introduction:
Lawmakers in Brazil have decided to move the start of Daylight Saving Time (DST) from 2018, effectively shortening the DST-period in the country by two weeks.
On the night between Saturday, November 3 and Sunday, November 4, 2018 clocks in the southern parts of Brazil will be set forward 1 hour from 00:00 (12:00 am, midnight) to 01:00 (1:00 am).

Same End Date
On December 16, 2017, the president of Brazil, Michel Temer, signed a decree moving the start of DST in the South American country from October to November.

Better for the Elections
The decree comes as a result of federal elections in Brazil in October next year. Setting the clocks forward after the second round of elections allows for a better vote count after the poll stations close in the different time zones in the country.
Question:
Will the Brazil DST change in 2018 affect CA Performance Management
Environment:
Any CAPM Version
Answer:
There is a Workaround for now , you just have to follow this steps

Check/Change Vertica DB Timezone:

1. Go to the Data Repository Server and Login with the dradmin user.

Go to /opt/vertica/bin/adminTools

Connect to the Database

User-added image

User-added image

Check the Current Time from the Vertica DB:

drdata=> SELECT GETDATE();

User-added image


Check the current timezone:

drdata=> SHOW TIMEZONE;   

User-added image


Set the TimeZone with this command:
drdata=> SET TIME ZONE TO 'America/Buenos_Aires';



2. Go to the CAPC

Users:

User-added image


Edit the User:
User-added image



Set the Timezone from America/SaoPaulo to 'America/Buenos_Aires'

User-added image

You will need to execute the Timezone changes to each User.


NOTE: If you want to manually change in the CAPC Mysql DB to all users, please contact CA Support