NEC Attendant Management System Operations Manual

NDA-30046   Revision 3.0Page B-3
Attendant Management System Operations Manual AMS Database Maintenance Procedures
5. Before reorganizing the database, it is useful to find the exact number of extents 
in each of the fragmented tables. This way, once you reload the data, you can 
rerun this step to see the improved number.
To determine the exact number of extents for the fragmented tables, type 
tbcheck -pt amsdb | more and press Enter. You can type /extension to skip all 
of the internal informix tables...

Page B-4NDA-30046   Revision 3.0
AMS Database Maintenance Procedures Attendant Management System Operations Manual
Next we will unload the database. Even after this step, we have not removed any 
data from the database. We are only saving it to temporary files.
13. If you do not have the “Informix dbaccess Utility” option on your amsadm or 
statsadm menu, log out of amsadm and statsadm and log in as informix on two 
screens. Otherwise, enter x to activate dbaccess and skip the next step.
14. Type...

NDA-30046   Revision 3.0Page B-5
Attendant Management System Operations Manual AMS Database Maintenance Procedures
30. Choose Query Language then amsdb on one screen and statsdb then Choose 
on the other. Then choose loadams on one screen and loadstat on the other.
Note:
Note that if you Run the loadstat and you have many thousands of records in 
callprc, this may take several hours. 
31. If you do not need to restore the attendant statistics for the last week, you can 
edit the loadstat script and...

AMS Database Maintenance Procedures Attendant Management System Operations Manual
Page B-6NDA-30046   Revision 3.0
This Page Left Blank. 

NDA-30046   Revision 3.0Page C-1
Attendant Management System Operations Manual AMS Database Import Capabilities
Appendix C AMS Database Import Capabilities
The initial AMS database is created by either manually entering the information 
through the MAS input menus or by importing data from ASCII files. The utilities 
used to import this information into the AMS database requires the information to 
be in a predefined format. There are 4 different types of ASCII files from which 
data can be imported:...

Page C-2NDA-30046   Revision 3.0
AMS Database Import Capabilities Attendant Management System Operations Manual
External Record Format
You need to name the external record format file extl.txt.
Internal Record Format
You need to name the extension record format file intl.txt.
Table C-2  External Record Format
Field Description Size
External Name (Location/person) 30
Number to Display 15
Number to Call 21
ANI Number 21
Account # 10
Address 30
City 25
State 2
Zip Code 10
User Definable 1 25
User Definable...

NDA-30046   Revision 3.0Page C-3
Attendant Management System Operations Manual AMS Database Import Capabilities
Employee Record Format
You need to name the employee record format file empl.txt.
* If the Location Status Information (LSI) application is to be used in conjunction 
with the AMS, these fields are reserved for LSI.
Table C-4  Employee Record Format
Field Description Size
Employee Name 30
Extension 5
Title 25
ID 10
Beeper 15
Message Count 4
Account # 10
E-Mail Address 50
Vo i c e  M a i l b o x...

AMS Database Import Capabilities Attendant Management System Operations Manual
Page C-4NDA-30046   Revision 3.0
This Page Left Blank.