Will the Brazil DST change in 2018 affect CA Performance Management

Document ID : KB000118504
Last Modified Date : 25/10/2018
Show Technical Document Details
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.
Will the Brazil DST change in 2018 affect CA Performance Management
Any CAPM Version
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


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