Maintaining the ZENworks Handheld Management databases

  • 3909885
  • 27-Feb-2007
  • 16-Mar-2012

Environment

Novell ZENworks Handheld Management 7 - ZHM7
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.