As the number of distributions you run increases, the size of the databases at the server and on the proxy service computers grows.
ZENworks Handheld Management provides separate tools to reduce the size of the server and proxy service databases.
The ZENworks Handheld Management tools to compact and repair the server database are for the internal ODBC-compatible databases only. If you have configured ZENworks Handheld Management to use Microsoft SQL Server, use the utilities provided with Microsoft SQL Server to perform database maintenance.
The following sections contain additional information:
Before performing database operations, you should back up the ZENworks Handheld Management installation directory (specifically serverdata.mdb).
Before compacting a server database, make sure to shut down all ZENworks Handheld Management applications, including ConsoleOne.
Make sure that no other computer is accessing the database (for example, a remote copy of ConsoleOne).
If another computer has the database locked, you receive an error message if you try the operation. Shut down the ConsoleOne on that computer and retry the operation.
To compact the server database:
Use either Windows Explorer or the command prompt on the ZENworks Handheld Management installation machine to access the ZENworks Handheld Management Server installation directory.
From the installation directory, run dbtool.exe.
If you are sure no other process is accessing the database (for example, a remote installation of ConsoleOne), click .
The database is compacted and the service is restarted.
The proxy service database can be compacted by using dbtool.exe from the command line in the client installation directory (program files\novell\zfhap).
To compact a proxy service database:
Use the command prompt on the ZENworks Handheld Management proxy service machine to access the ZENworks Handheld Management client installation directory.
From the installation directory, run dbtool.exe/proxy /compact.
You are reminded that the ZENworks Handheld Management client is stopped and restarted after the database is compacted.
Click .
If the server internal ODBC-compatible database or proxy service database cannot be opened when ZENworks Handheld Management or the proxy service starts, you might need to compact and repair the database.
If the database is corrupt, you might see a message in the log file that indicates that the database could not be opened. To compact and repair the database, you need to use the dbtool command with the /compact option. Other dbtool options are described below.
Table 7-1 DBtool options
|
Option |
Function |
|---|---|
|
/compact |
Compact and repair a database |
|
/proxy |
Perform on a proxy service database |
|
/server |
Perform on a server database |
For example, to repair a proxy service database, enter dbtool /proxy /compact.
Dbtool.exe is installed in the zfh and zfhap installation directories.