POS Transaction Analyzer User and Installation Guide, SST Version 1.2

Installing HP NonStop POS Transaction Analyzer 25
Step I: Setup Complete
Figure 2-12 POS Transaction Analyzer Database Setup Completed Screen
The POS Transaction Analyzer Database Setup Completed screen denotes the completion of the Setup process.
Click on the Finish button to complete the Setup process. This completes the POS/TA Database Setup process.
Step J: Updating the HOSTTIMEINFO Table
The POS/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
NODE 1. Let’s consider that NODE1 is in the Pacific Time zone and they have DST applied.
Table 2-1 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> = POSDB, which is POS/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 POS Transaction Analyzer