Page 98 NDA-30122 Revision 1
ADMINISTRATION MENU Attendant Console Statistics Operations Manual
Database Administration
The Database Administration option on the Console Statistics Administration
Menu is used to manage the Informix database used by Console Stats. This
database maintains the call processing and attendant lo gin data, statistics, report
formats, and indexed time schedules for Console Stats.
Note: The Console Stats database and it components were created when the Console
Stats application was first installed. Should it become necessary to change the
Console Stats database, or some of its components, these menu options are us ed
to implement the desired changes.

Procedure

Overview The overall sequence for establishing a new database:
•If a current database exists, Remove the current database.
•Set the database space for the new database.
•Assign a Name to the new database.
•Install the new database.
•Use the Build Database Indices option to name the new database indices that
are used during search and retrieval functions.
Utility options are also provided to managed the database and view various
components of the database. These options include: Erase Database Indices,
Display Table Count, Update System Catalog, and Informix dbaccess Utility are
described in the following sections of this chapter.