Environment
Novell ZENworks
Handheld Management 7 - ZHM7
Novell ZENworks Handheld management 6.5 - ZHM6.5
Novell ZENworks Handheld management 6.5 - ZHM6.5
Situation
ZENworks Handheld
Management uses databases to store information about managed
devices, and also certain book-keeping information, which is useful
for displaying results in ConsoleOne. The databases are
ServerData.mdb and ProxyData.mdb at the Server and the Access Point
respectively. Depending upon the number of managed devices in an
organization, the size of the database can keep on growing. This
can eventually degrade the performance of the system. Hence it is
important to have a periodic database maintenance plan in
place.
Resolution
ZENworks
Handheld Management has a command-line utility, dbtool which can be
used to compact the database, as well as fix the database in case
of errors. The administrator's guide discusses theusage of this
tool.
Few
recommendations on using the utility:
- When the server database is being compacted or fixed, it is recommended to stop the ZENworks Handheld Management Proxy service and the ZENworks Handheld Management Access Point service.
- It is a good idea to integrate the execution of this utility with the regular database backup activities of the organization. This will ensure that the databases are compacted regularly.
- An ideal frequency to do the database maintenance activities would be once in a fortnight. However running the tool more(or less) frequently depending upon the database(s) growth rate is a good idea.