POS Transaction Analyzer User and Installation Guide, SST Version 1.2

Installing HP NonStop POS Transaction Analyzer 23
Step E: Option Type
Figure 2-8 POS Transaction Analyzer Database Select Option Type Screen
The Select Option Type screen is displayed. Select the database option that best suits your needs. Choosing the
Create POSDB Database and Tables option will create POSDB database and tables. You need to have the
Database Creator rights for creating the database and tables. Choosing the Create only POSDB Tables option
will create only the POSDB tables. It is assumed that the POSDB database has been created manually. You
need to have the POSDB database db_owner and public rights.
Step F: Maintenance Job Start Time (Database Server)
Figure 2-9 POS Transaction Analyzer Database Maintenance Job Start Time (Database Server) Screen
The Maintenance Job Start Time (Database Server) screen is displayed. Enter the Maintenance Job Start Time in
HHMMSS format only and the value should be less than ‘235959’. Also make sure that MS SQL Server Agent is
running in MS SQL Server for this job.
The Database job (MAINTENANCE_JOB_POSTA) will perform the following tasks:
a. Deleting the marked deleted entity types, the statistics and the alerts for the corresponding entity types.
b. Defragmentation of indexes.
NOTE: The POSDB tables will be defragged if average fragmentation percentage is greater than 30%.
Installing HP NonStop POS Transaction Analyzer