NEC Attendant Management System Attendant Statistics Operations Manual

							NDA-30058   Revision 2Page 73
Attendant Management System - Attendant Statistics ADMINISTRATION MENU
Database Administration (Cont)
Erase Database 
IndexesThe Erase Database Indexes option on the Database Administration menu is used 
to erase the indexes used to access data in the database.
Figure 4-7   Erase Database Indexes
Sequence
Use of this option is rare.  When the indexes are erased, using the Build Database 
Indexes option  is required to re-make them.
Procedure
4QdQRQcU 1T]Y^YcdbQdY_^
>Q]U 4QdQRQcU SebbU^d*
cdQdcTR
9^cdQ\\ 4QdQRQcU
BU]_fU 4QdQRQcU
2eY\T 4QdQRQcU 9^TUhUc
5bQcU 4QdQRQcU 9^TUhUc
3\ecdUb DQR\Uc
4Yc`\Qi DQR\U 3_e^d
AeYd =U^e
5^dUb ?`dY_^* K
UM
5bQcU 4QdQRQcU 9^TUhUc
5bQcY^W Y^TUhUc V_b TQdQRQcU ²cdQdcTR³
6Y^YcXUT UbQcY^W TQdQRQcU Y^TUhUc
@bUcc 5^dUb d_ S_^dY^eU
(1)
(2)
Action Result
On the Database Administration menu, 
type e  inside the brackets at the prompt 
and press Enter. (1)The Erase Database Indexes screen is 
displayed and shows that the database 
indexes are being erased.  Afterward 
the message “Press Enter to continue” 
is displayed. (2)
Press Enter. The Database Administration menu is 
displayed again. 
						

							Page 74NDA-30058   Revision 2
ADMINISTRATION MENU Attendant Management System - Attendant Statistics
Database Administration (Cont)
Cluster TablesThe Cluster Tables option on the Database Administration menu is used to re-
order the data in the database.
Figure 4-8   Cluster Tables
General Information
Clustering the database tables speeds up database searches and data retrieval.  
However, it does  require a large amount of time to complete.  Attendant Stats locks 
the database  while it is being clustered so that no one can interrupt by trying to 
access the database.  It is best to perform this task during low traffic times.
Procedure
4QdQRQcU 1T]Y^YcdbQdY_^
>Q]U 4QdQRQcU SebbU^d*
cdQdcTR
9^cdQ\\ 4QdQRQcU
BU]_fU 4QdQRQcU
2eY\T 4QdQRQcU 9^TUhUc
5bQcU 4QdQRQcU 9^TUhUc
3\ecdUb DQR\Uc
4Yc`\Qi DQR\U 3_e^d
AeYd =U^e
5^dUb ?`dY_^* K
SM
3\ecdUb DQR\Uc
3\ecdUbY^W dQR\Uc V_b TQdQRQcU ²cdQdcTR³
6Y^YcXUT S\ecdUbY^W TQdQRQcU dQR\Uc
@bUcc 5^dUb d_ S_^dY^eU
(1)
(2)
Action Result
On the Database Administration menu, 
type c  inside the brackets at the prompt 
and press Enter. (1)The Cluster Tables screen is displayed 
and shows that the data tables are being 
clustered.  Afterward the message 
“Press Enter to continue” is displayed. 
(2)
Press Enter. The Database Administration menu is 
displayed again. 
						

							NDA-30058   Revision 2Page 75
Attendant Management System - Attendant Statistics ADMINISTRATION MENU
Database Administration (Cont)
DisplayTable 
CountThe Display Table Count option on the Database Administration menu is used to 
list the internal database tables and to display a count of the records each contains.
Figure 4-9   Display Table Count
Procedure
4QdQRQcU 1T]Y^YcdbQdY_^
>Q]U 4QdQRQcU SebbU^d*
cdQdcTR
9^cdQ\\ 4QdQRQcU
BU]_fU 4QdQRQcU
2eY\T 4QdQRQcU 9^TUhUc
5bQcU 4QdQRQcU 9^TUhUc
3\ecdUb DQR\Uc
4Yc`\Qi DQR\U 3_e^d
AeYd =U^e
5^dUb ?`dY_^* K
TM
4Yc`\Qi DQR\U 3_e^d
Qdd\_W  %
Qddi  (
SQ\\`bS  
b`dV]d  )
dY]YTh  &
D_dQ\ ^e]RUb _V bUS_bTc  #%
@bUcc 5^dUb d_ S_^dY^eU
(1)
(2)
Action Result
On the Database Administration menu, 
type d  inside the brackets at the prompt 
and press Enter. (1)The Display Table Count screen 
displays each database table and, in 
parentheses, the number of records it 
contains.  The message “Press Enter to 
continue” is displayed below. (2)
Press Enter. The Database Administration menu is 
displayed again. 
						

							Page 76NDA-30058   Revision 2
ADMINISTRATION MENU Attendant Management System - Attendant Statistics
Log File Display
Overview
The Log File Display option on the Attendant Statistics Administration Menu is 
used to access the log files for display and printing of log entries.  Attendant Stats 
enters process and error messages to a menu log file and to a report generation log 
file.
Figure 4-10   Log File Display
Menu Options
The Log File Display menu provides the following options that enable you to 
perform the actions listed:
Menu Log Files–Access the files that contain process and error 
messages occurring during performance of 
menu functions.
Report Generator Log Files–Access the files that contain process and error 
messages occurring during automatic report 
generation.
These options make it possible to access these files for display and printing of log 
entries.  Note that entries are also made to the Applications Manager log file, 
entered through the APM System Operations Menu, for the Stat
_Logger 
component (AMS interface).
1ddU^TQ^d CdQdYcdYSc 1T]Y^YcdbQdY_^ =U^e
=QY^ =U^e
4QdQRQcU 1T]Y^YcdbQdY_^
9H

						

							NDA-30058   Revision 2Page 77
Attendant Management System - Attendant Statistics ADMINISTRATION MENU
Log File Display (Cont)
Procedure
Action Result
On the Attendant Statistics 
Administration Main Menu, type l  
inside the brackets at the prompt and 
press Enter. (1)The Log File Display menu is 
displayed. (2)
Refer to the following pages for 
information about each menu option.
To exit the Log File Display menu, type 
q at the prompt and press Enter.The Attendant Statistics 
Administration Main Menu is 
displayed. 
						

							Page 78NDA-30058   Revision 2
ADMINISTRATION MENU Attendant Management System - Attendant Statistics
Log File Display (Cont)
Menu Log FilesThe Menu Log Files option is used to access the files that contain process and error 
messages that occur during performance of  menu functions.
Figure 4-11   Menu Log File
Real-Time Display
The Menu Log File display reflects real-time activity in the file when it is in 
AutoScroll mode.  Use the Enter key to toggle the AutoScroll command on and 
off when the cursor is positioned on the command.  In AutoScroll mode, shown by 
the notation A–S in the bottom right corner of the screen, new messages are 
scrolled onto the screen as they occur and are added to the file.
Procedure

						

							NDA-30058   Revision 2Page 79
Attendant Management System - Attendant Statistics ADMINISTRATION MENU
Menu Log Files 
(Cont)Procedure (Cont)
Action Result
Use the To p  command to move to the 
beginning of the display and the 
Bottom command to move to the end 
of the display.
To Search the Display:
Ty p e  s and press Enter to select the 
Search command.  At the prompt type 
the desired pattern and press Enter.All occurrences of the given pattern on 
that page are highlighted.
To Print the Screen or File:
Ty p e  p and press Enter to select the 
Print command.  At the prompt, type f 
to print the whole file or s to print just 
the screen and press Enter.  (Press Esc 
to return the cursor to the command 
line, cancelling the print request.)There is a pause while the file or screen 
is sent to the printer.  Then the 
command line is returned.
To Work at UNIX Level:
Ty p e  c and press Enter to select the 
Command choice on the command 
line. The message Enter UNIX command 
and press Enter is displayed, and the 
cursor is positioned on a UNIX prompt.
To exit the display, type q at the prompt 
and press Enter.The Log File Display menu is 
displayed. 
						

							Page 80NDA-30058   Revision 2
ADMINISTRATION MENU Attendant Management System - Attendant Statistics
Log File Display (Cont)
Report Generator 
Log FilesThe Report Generator Log Files option is used to access the files that contain 
process and error message occurring during automatic generation of reports.
Figure 4-12   Report Generator Log File
Real-Time Display
The Report Generator Log File display reflects real-time activity in the file when 
it is in AutoScroll mode.  The Enter key is used to toggle the mode on and off 
when the cursor is positioned on the AutoScroll command.  In AutoScroll mode, 
shown by the notation A–S in the bottom right corner of the screen, new messages 
are scrolled onto the screen as they occur and are added to the file.
Procedure

						

							NDA-30058   Revision 2Page 81
Attendant Management System - Attendant Statistics ADMINISTRATION MENU
Report Generator 
Log Files (Cont)Procedure (Cont)
Action Result
Use the To p  command to move to the 
beginning of the display and the 
Bottom command to move to the end 
of the display.
On the Log File Display menu, type r  
inside the brackets at the prompt and 
press Enter. (1)The Report Generator Log Files list of 
available dated log files is displayed. 
(2)
Type the full name of the desired file at 
the prompt and press Enter.The named file is displayed with a new 
command line.
If desired, press Enter to turn on the 
AutoScroll mode.The notation A–S is displayed in the 
bottom right corner of the screen.
Use the To p  command to move to the 
beginning of the display and the 
Bottom command to move to the end 
of the display.
To Search the Display:
Ty p e  s and press Enter to select the 
Search command.  At the prompt, type 
the desired pattern and press Enter.All occurrences of the given pattern on 
that page are highlighted.
To Print the Screen or File:
Ty p e  p and press Enter to select the 
Print command.  At the prompt, type f 
to print the whole file or s to print just 
the screen and press Enter.  (Pressing 
Esc returns the cursor to the command 
line, cancelling the print request.)There is a pause while the file or screen 
is sent to the printer.  Then the 
command line is returned.
To Work at UNIX Level:
Ty p e  c and press Enter to select the 
Command choice on the command 
line. The message “Enter UNIX command 
and press Enter” is displayed, and the 
cursor is positioned on a UNIX prompt.
To exit the display, type q at the prompt 
and press Enter.The Log File Display menu is 
displayed. 
						

							ADMINISTRATION MENU Attendant Management System - Attendant Statistics
Page 82NDA-30058   Revision 2
This Page Left Blank.