ATM Transaction Anayzer User and Installation Guide

Installing HP NonStop ATM Transaction Analyzer 23
Step E: Option Type
Figure 2-8 ATM 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 ATMTA Database and Tables option will create ATMTA database and tables. You need to
have the Database Creator rights for creating the database and tables.
Choosing the Create only ATMTA Tables option will create only the ATMTA tables. It is assumed that the ATMTA
database has been created manually. You need to have the ATMTA database db_owner and public rights.
Step F: Maintenance Job Start Time (Database Server)
Figure 2-9 ATM 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_ATMTA) 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 ATMTA tables will be defragged if average fragmentation percentage is greater than 30%.
Installing HP NonStop ATM Transaction Analyzer