NEC Attendant Management System Attendant Statistics Operations Manual

							NDA-30058   Revision 2Page 63
Attendant Management System - Attendant Statistics MAIN MENU OPTIONS
Non-Automated  
Reports (Cont)Procedure
Action Result
On the Options Menu, type n to select 
the Non-Automated Reports option. 
(1)The Non-Automated Reports screen 
displays a list of dated reports. (2)
Using the arrow keys, move the cursor 
to the desired report and press Enter.  
(Notice that Shift+d and Shift+u can 
be used to move down or up pages in a 
multi-page display.) The selected report is displayed. (3)
Use the DownPage command to move 
forward one page, the UpPage 
command to move back one page, the 
To p  command to move to the beginning 
of the display, and the Bottom 
command to move to the end of the 
display.
Search the Display
: Ty p e  s to select the 
Search command.  At the prompt, type 
the desired pattern and press Enter.
Print the Display
:  Type p 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.All occurrences of the given pattern on 
that page are highlighted.
There is a pause while the file or screen 
is sent to the printer.  Then the 
command line is returned.
To exit the display, type q (quit). The Reports menu is displayed. 
						

							MAIN MENU OPTIONS Attendant Management System - Attendant Statistics
Page 64NDA-30058   Revision 2
This Page Left Blank. 
						

							NDA-30058   Revision 2Page 65
Attendant Management System - Attendant Statistics ADMINISTRATION MENU
Chapter 4 ADMINISTRATION MENU
Overview
The Attendant Statistics Administration Menu is used to manage the database 
and access the log files in which entries are made from menus and report generation 
activities.
Figure 4-1   Attendant Statistics Administration Menu
Menu Options
The Attendant Statistics Administration Main Menu provides these options:
Database Administration  –Routinely collects call processing data and 
maintains it in the Informix database for up to two 
weeks to support statistics calculation for reports.  
This option makes it possible to perform 
maintenance tasks with this database. 
Log File Display  –Enters process and error messages into a menu log 
file and to a report generation log file.  Use this 
option 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.
UNIX  –Positions the cursor at the UNIX prompt.  Once 
this option is selected, refer to a UNIX reference 
guide.  Type the word exit at the UNIX prompt to 
return to the system login for re-entry to the 
Attendant Statistics Administration Menu.
The Database Administration and Log File Display options are described fully on 
the following pages.
1ddU^TQ^d CdQdYcdYSc 1T]Y^YcdbQdY_^ =U^e
=QY^ =U^e
4QdQRQcU 1T]Y^YcdbQdY_^9H
						

							Page 66NDA-30058   Revision 2
ADMINISTRATION MENU Attendant Management System - Attendant Statistics
Overview (Cont)
Procedure
Action Result
At the system login prompt, type 
statsadm and press Enter.The Attendant Statistics 
Administration Menu is displayed. 
Refer to the following pages for 
information and instructions in the use 
of each menu option.
To exit the Statistics Administration 
Menu, type l  (Logout) inside the 
brackets and press Enter.The system login prompt is displayed 
again. 
						

							NDA-30058   Revision 2Page 67
Attendant Management System - Attendant Statistics ADMINISTRATION MENU
Database Administration
Overview
The Database Administration option on the Attendant Statistics Administration 
Menu is used to manage the Informix database used by Attendant Stats to maintain 
the call processing and attendant login data, statistics, report formats, and indexed 
time schedules.
Figure 4-2   Database Administration
Menu Options
The Database Administration menu provides the following options that enable you 
to perform the actions listed:
Name Database–Change the name of the database.
Install Database–Create a new database.
Remove Database–Delete the current database.  WARNING!  Use of 
this option causes the loss of all call processing 
and attendant login data that has been collected 
over the past two weeks, report formats, and 
indexed time schedules.
Build Database Indexes–Structure the database indexes by which data is 
stored and retrieved according to instructions 
embedded in Attendant Stats software.
Erase Database Indexes–Erase the indexes by which data is stored and 
retrieved.
Cluster Tables–Re-order the database tables to increase efficiency 
during search and retrieval functions.
Display Table Count–Display the name of each database table and the 
number of records each contains.
1ddU^TQ^d CdQdYcdYSc 1T]Y^YcdbQdY_^ =U^e
=QY^ =U^e
4QdQRQcU 1T]Y^YcdbQdY_^
9H
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 M
(1)
(2) 
						

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

							NDA-30058   Revision 2Page 69
Attendant Management System - Attendant Statistics ADMINISTRATION MENU
Database Administration (Cont)
Name DatabaseThe Name Database option on the Database Administration menu is used to 
change the name of the database.
Figure 4-3   Name Database
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
^M
C`USYVi ^Q]U _V TUcYbUT TQdQRQcU*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
AeYd =U^e
5^dUb ?`dY_^* K M
(1)
(2)
Action Result
On the Database Administration menu, 
type n  inside the brackets at the prompt 
and press Enter. (1)The prompt Specify name of desired 
database: is displayed below the menu. 
(2)
Type the new name of the current 
database and press Enter.A message broadcasts the new name.  
The new name is inserted inside the 
parentheses beside the Name Database 
option, and the cursor is returned to the 
option prompt. 
						

							Page 70NDA-30058   Revision 2
ADMINISTRATION MENU Attendant Management System - Attendant Statistics
Database Administration (Cont)
Install DatabaseThe Install Database option on the Database Administration menu is used to 
create new database fields according to instructions embedded in Attendant Stats 
software.
Figure 4-4   Install Database
When to Use
This option is typically only performed during installation or (rarely) when the 
database is removed.  Once the new database fields are created through this option, 
use the Build Database Indexes option to name the database indexes that are used 
during search and retrieval functions.  
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
YM
9^cdQ\\ 4QdQRQcU
9^cdQ\\Y^W TQdQRQcU ²cdQdcTR³
6Y^YcXUT Y^cdQ\\Y^W TQdQRQcU ²cdQdcTR³
@bUcc BUdeb^ d_ S_^dY^eU
(1)
(2)
Action Result
On the Database Administration menu, 
type i  inside the brackets at the prompt 
and press Enter. (1)The Install Database screen is 
displayed with messages that show 
status of the installation. (2)
Press Enter when the installation is 
complete.The Database Administration menu is 
displayed. 
						

							NDA-30058   Revision 2Page 71
Attendant Management System - Attendant Statistics ADMINISTRATION MENU
Database Administration (Cont)
Remove DatabaseThe Remove Database option on the Database Administration menu is used to 
remove the entire Attendant Stats database.  WARNING:  
To protect the database, 
do not use this option without first backing up the database on tape using 
instructions provided in the Informix documentation.
Figure 4-5   Remove Database
Sequence
The Remove Database function removes all data now stored in the Attendant Stats 
database.  Afterwards it will be necessary to create new database fields using the 
Install Database option and then name the order of record storage with the Build 
Database Indexes option.
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
bM
BU]_fU 4QdQRQcU
BU]_fY^W dXU TQdQRQcU gY\\ SQecU Q\\ TQdQ
SebbU^d\i cd_bUT d_ RU TUcdb_iUT
1bU i_e cebU i^* i ,B5D.
BU]_fY^W dXU TQdQRQcU   
@bUcc 5^dUb d_ S_^dY^eU
(1)
(2)
Action Result
On the Database Administration menu, 
type r  inside the brackets at the prompt 
and press Enter. (1)The Remove Database screen is 
displayed with a warning and a 
confirmation prompt. (2)
At the confirmation prompt, type y and 
press Enter to delete the database or n 
and press Enter to cancel the deletion.If the deletion is confirmed, a message 
shows when the database is being 
removed.  The message “Press Enter to 
continue” shows when it is appropriate 
to exit the screen.
Press Enter. The Database Administration menu is 
redisplayed. 
						

							Page 72NDA-30058   Revision 2
ADMINISTRATION MENU Attendant Management System - Attendant Statistics
Database Administration (Cont)
Build Database 
IndexesThe Build Database Indexes option on the Attendant Stats Database 
Administration menu is used to create a file(s) of indexes that make access to the 
data in the database faster.
Figure 4-6   Build Database Indexes
Sequence
Once the Create Database option defines the fields of the new database 
according to Attendant Stats instructions, the Build Database Indexes option 
marks the fields that are to be used as indexes. After these two options have been 
used, the database is ready for new data. 
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
RM
2eY\T 4QdQRQcU 9^TUhUc
2eY\TY^W Y^TUhUc V_b TQdQRQcU ²cdQdcTR³
6Y^YcXUT ReY\TY^W TQdQRQcU Y^TUhUc
@bUcc 5^dUb d_ S_^dY^eU
(1)
(2)
Action Result
On the Database Administration menu, 
type b  inside the brackets at the prompt 
and press Enter. (1)The Build Database Indexes screen is 
displayed and shows that the database 
indexes are being made.  Afterward the 
message “Press Enter to continue” is 
displayed. (2)
Press Enter. The Database Administration menu is 
displayed again.