NEC Attendant Console Statistics Operations Manual

							NDA-30122   Revision 1 Page 103
Attendant Console Statistics Operations Manual ADMINISTRATION MENU
Database Administration (Cont.)
Build Database 
IndexesThe Build Database Indices option on the Console Stats Database Administration 
menu is used to create indices that make access to the data in the database faster. 
This function marks the specified database fields that are to be used for indices.
Note:
The Build Database Indices option must be implemented whenever a new data-
base is installed.
Step 1:
From the Database Administration menu (Figure 9-2), press the ’B’ key 
and press Enter. The Build Database Indices screen (Figure 9-5) will be 
displayed.
Figure 9-5   Build Database Indices Screen
Step 2:
The display will show the status of building indices. When the build is 
complete, press Enter. 
						

							Page 104 NDA-30122   Revision 1
ADMINISTRATION MENU Attendant Console Statistics Operations Manual
Database Administration (Cont.)
Erase Database 
IndexesTypically, it will only be necessary to use Erase Database Indexes option on the 
Database Administration menu when the database has become corrupted. When 
the indices are erased, the Build Database Indices option is required to re-make 
the indices.
Step 1:
From the Database Administration menu (Figure 9-2), press the ’E’ key 
and press Enter. The Erase Database Indices screen (Figure 9-6) will be 
displayed.
Figure 9-6   Erase Database Indices Screen
Step 2:
The display will show the status of the erase database indices process. 
When the erase is complete, press Enter.
Note:
It is necessary to re-build the database indices before using the database. Use the 
Build Database Indices
 function described in this chapter. 
						

							NDA-30122   Revision 1 Page 105
Attendant Console Statistics Operations Manual ADMINISTRATION MENU
Database Administration (Cont.)
Display Table 
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.
Step 1:
From the Database Administration menu (Figure 9-2), press the ’D’ key 
and press Enter. The Display Table Count screen (Figure 9-7) will be 
displayed.
Figure 9-7   Display Table Count Screen
Step 2:
The display will show the various tables used for the Console Stats 
database and the number of records for each table. When finished 
viewing the tables, press Enter. 
						

							Page 106 NDA-30122   Revision 1
ADMINISTRATION MENU Attendant Console Statistics Operations Manual
Database Administration (Cont.)
Update System 
CatalogThe Update System Catalog option on the Database Administration menu is used 
to update the table row counts stored in the Informix SYSTABLES catalog.
Step 1:
From the Database Administration menu (Figure 9-2), press the ’U’ key 
and press Enter. The Update System Catalog screen (Figure 9-8) will be 
displayed.
Figure 9-8   Update System Catalog Screen
Step 2:
When the update is complete, press Enter. 
						

							NDA-30122   Revision 1 Page 107
Attendant Console Statistics Operations Manual ADMINISTRATION MENU
Database Administration (Cont.)
Informix dbaccess 
UtilityThe Informix dbaccess Utility option on the Database Administration menu is used 
to activate the Informix dbaccess utility. For more information about this utility, 
see the Informix System Administrator’s Guide. 
						

							Page 108 NDA-30122   Revision 1
ADMINISTRATION MENU Attendant Console Statistics Operations Manual
Log File Display
The Log File Display option on the Console Statistics Administration Menu is 
used to access the log files for display and printing of log entries. Console Stats 
enters process and error messages to a menu log file and to a report generation log 
file.
Log File Display 
MenuFrom the Administration Main Menu (Figure 9-1), press the ’F’ key and press 
Enter to select the Log File Display option. The Log File Display menu screen 
(Figure 9-9) will be displayed.
Figure 9-9   Log File Display Screen
Menu OptionsThe Log File Display menu provides these options:
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.
Statistic Logger Log Files–Access the files that contain process and error 
messages occurring during statistic logging.
Patroller Log Files–Access the files that contain process and error 
messages occurring during patroller logging.
The specific step-by-step procedures for all these functions are described in the 
following sections of this chapter. 
						

							NDA-30122   Revision 1 Page 109
Attendant Console Statistics Operations Manual ADMINISTRATION MENU
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.
Step 1:
From the Log File Display screen (Figure 9-9), press the ’M’ key and 
press Enter. The Menu Log Files screen (Figure 9-10) will be displayed.
Figure 9-10   Menu Log Files Screen
Step 2:
The display shows the available menu log files listed on the left of the 
screen. At the prompt, enter the filename of the menu log file to view, and 
press Enter. The specified menu log file data will be displayed (Figure 
9-11). 
						

							Page 110 NDA-30122   Revision 1
ADMINISTRATION MENU Attendant Console Statistics Operations Manual
Log File Display (Cont.)
Menu Log Files 
(Cont.)
Figure 9-11   Menu Log File Data Screen
The Menu Log File Data screen shows the data log entries for the specified menu 
log file.
Screen Options
Various options are available at this screen:
Search–Use the Search option to find specific text in the file. Press 
the ’S’ key and press Enter. At the prompt enter the text 
value to search and press Enter. The found text will be 
shown on the screen in highlight. All occurrences of the 
found text will be shown.
To p / B o t t o m–
Use the 
To p  option to move to the beginning of the file and 
the 
Bottom option to move to the end of the file. Press the 
’
T’ or ’
B’ keys and press 
Enter. (The UP and DOWN arrow 
keys can also be used to scroll the file line-by-line.)
Command–Use the Command option to enter commands directly in the 
UNIX environment. Press the ’C’ key and press Enter to 
access UNIX. Enter the appropriate UNIX command at the 
prompt and press Enter.
Print–
Type ’
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.) 
						

							NDA-30122   Revision 1 Page 111
Attendant Console Statistics Operations Manual ADMINISTRATION MENU
Log File Display (Cont.)
Menu Log Files 
(Cont.)Screen Options (Cont.)
Autoscroll–The reflects real-time activity in the file when it is in 
AutoScroll mode. Press the ’A’ key and press Enter to 
toggle the AutoScroll option on and off. In Aut o S cro ll  
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.
Quit–The Quit option exits the Menu Log File Data screen and 
the Menu Log File menu is displayed. Press the ’Q’ key and 
Enter to exit this screen. 
						

							Page 112 NDA-30122   Revision 1
ADMINISTRATION MENU Attendant Console Statistics Operations Manual
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.
Step 1:
From the Log File Display screen (Figure 9-9), press the ’R’ key and 
press Enter. The Report Generator Log Files screen (Figure 9-12) will 
be displayed.
Figure 9-12   Report Generator Log Files Screen
Step 2:
The display shows the available report generator log files listed on the left 
of the screen. At the prompt, enter the filename of the report generator 
log file to view, and press Enter. The specified report generator log file 
data will be displayed (Figure 9-13).