ATM Transaction Anayzer User and Installation Guide

Installing HP NonStop ATM Transaction Analyzer 39
2-5 Upgrading ATM/TA to Version 2.0
This section explains the procedure to upgrade from a previous version of ATM/TA version2.0.
1. Stop the Elink Services and the ATM/TA Services using the Start->Programs->HP SST->ATM TA->Application
Server->Stop ATM TA Agents option.
2. Take a backup of the ATM/TA database on the SQL Server.
3. To upgrade the ATM/TA Database, run the ATMTAUPGRADE.sql database upgrade script using the SQL
Analyzer.
4. The ATM/TA Database has the HOSTTIMEINFO table that contains information for the offsets of each node
from UTC in minutes through different time ranges (TimeRangeBegin and TimeRangeEnd)around the year
taking into account the Daylight Savings Time information. You need to make changes in the table
according to your requirements. The example below displays the records in the HOSTTIMEINFO table for
year 2009 and 2010 for NODE1. Let’s consider that NODE1 is in the Pacific Time zone and they have
DST applied.
Table 2-2 HOSTTIMEINFO
NodeName TimeRangeBegin TimeRangeEnd OffsetFromGmt
\NODE1 2009-03-11 09:00:00.000 2009-11-04 08:59:59.000 -420
\NODE1 2009-11-04 09:00:00.000 2010-03-09 08:59:59.000 -480
\NODE1 2010-03-11 09:00:00.000 2010-11-04 08:59:59.000 -420
\NODE1 2010-03-11 09:00:00.000 2010-11-04 08:59:59.000 -480
<DBName> 2009-03-11 09:00:00.000 2009-11-04 08:59:59.000 -420
<DBName> 2009-11-04 09:00:00.000 2010-03-09 08:59:59.000 -480
<DBName> 2010-03-11 09:00:00.000 2010-11-04 08:59:59.000 -420
<DBName> 2010-03-11 09:00:00.000 2010-11-04 08:59:59.000 -480
Where <DBName> = ATMTA, which is ATM/TA database name and time will depend upon where the
database Server exists and NODE1 is the host name and time will depend upon where the host server
reside.
From March 11th 2009 till November 4th 2009 the local time on the node \NODE1 will have an offset of
-420 minutes from UTC. During DST (summer months), clocks are turned forward an hour, effectively
moving an hour of daylight from the morning to the evening. In the United States, clocks change at 2:00
a.m. local time. In spring, clocks spring forward from 1:59 a.m. to 3:00 a.m.; in fall, clocks fall back from
1:59 a.m. to 1:00 a.m. In EU, clocks change at 1:00 a.m. Universal Time. In spring, clocks spring forward
from 12:59 a.m. to 2:00 a.m.; in fall, clocks fall back from 1:59 a.m. to 1:00 a.m.
NOTE: Refer to http://webexhibits.org/daylightsaving/g.html DST changes in other countries around the
globe.
Installing HP NonStop ATM Transaction Analyzer