Specifications

Chapter 6: Programming
Database Utilities
Page 6-10 Mitel
®
5000 Installation Manual – Issue 3.0, October 2008
Database Utilities
The same menu that lists the Session Manager also provides access to database utilities
designed to help maintain database integrity during installation, conversion, and maintenance
processes. These utilities consist of the Database Conversion utility (DB Converter) and the
Database Test and Repair utility (DB Test).
Database Test and Repair Utility
The Database Test and Repair Utility tests databases for corruption. In most cases, it is able to
repair the corruption. You can choose among eight tests to run. Each test can be enabled for
testing only, or it can be enabled for test and repair.
DB Test ensures that no more resources are reserved than the system can support. If resources
are reserved beyond the maximum number a system can support, DB Test reports the error and
corrects it by defaulting the excess reserved fields to 0.
The DB Test utility supports the Model 8602 IP softphone and will not report errors because of
this new device type.
With v2.3 or later, the DB Test utility recognizes the T1M-2 and T1M as valid modules for the
Mitel 5000 system (expansion bays 1-3). DB Test also tests the port types of the T1M-2 and
T1M modules and flags any configuration type other than T1, T1/PRI, E1/PRI, or None.
Running a Test
These tests do not find all of the corruptions that are possible. However, they cover a large
number of them. Frequently found corruptions are described in Common Errors. If the Repair
function is enabled and the repair status is Not Repaired, the program was unable to fix the
problem. In that case, contact Mitel for assistance.
Occasionally, a repair can cause another corruption. If this happens and the required test has
not been run, DB Test will notify you that another test needs to be run to repair the new
corruption. If DB Test detects an error but is unable to repair it, contact Mitel Technical Support
for assistance.
When the Database Test and Repair utility makes a repair by deleting records, it is possible for
further corruption to be generated. All of the corruption can be removed by running the proper
test. For example, if endpoint 1000 was deleted because of a major corruption, all references to
endpoint 1000 would still be in the database. The Referential Integrity test would be able to
clean up these references. Therefore, once the repairs are made, the utility may warn you that
other tests/repairs need to be run in order for total clean up to occur. If the proper test
automatically runs after the deletion occurs, then no warning is necessary because the test has
already run. However, you may notice additional error messages as the new corruption is
repaired.
NOTICE
Database Modification. If repairs are enabled, the given database will be modified.
Therefore, you must make a backup copy of your database before running this program. This
will give you a backup copy in case the repairs were undesirable.