Tuning the performance of ZENworks Inventory on Sybase or MSSQL

  • 3463453
  • 05-May-2007
  • 30-Apr-2012

Environment

Novell ZENworks 6.5 Desktop Management Support Pack 2 - ZDM6.5 SP2 ZENworks Inventory
Novell ZENworks 7 Desktop Management - ZDM7 Inventory

Situation

ZENworks Inventory Storer slow storing inventory data
The Inventory Storer takes a considerable amount of time to store the inventory data

Resolution

1. Stop the Inventory Service.

a. On a NetWare server, type the following command at the server
console:

STOPSER *

b. From the desktop of a Windows server, click Start > Settings >
Control Panel > Administrative Tools > Services, right-click the
Novell Inventory Service, then click Stop.

2. Close all instances of ConsoleOne that are connected to this
database.

3. If your Inventory database is running on Sybase, modify the
database indexes using the sybindex utility.

a. To run the sybindex utility on a NetWare server:

1) On the Inventory server, extract Inventory_server_
installation_path\zenworks\inv\server\wminv\properties\sql.zip
to a temporary directory retaining the directory structure.
For example, extract sql.zip to sys:\sql.

The temporary directory will contain the Sybase directory.

2) If the Sybase Inventory database is either not hosted on the
Inventory server or is running on a port other than 2638,
edit Inventory_server_installation_path\zenworks\inv\server\
wminv\properties\sqlupdater.properties to specify the host
and port on which the Sybase Inventory database is running.

3) At the Inventory server system console prompt, enter:
sybindex -path directory>\sybase.

For example, sybindex -path sys:\sql\sql\sybase where sql is the
directory to which sql.zip is extracted in Step 1.

b. To run the sybindex utility on a Windows server:

1) On the Inventory server, extract Inventory_server_installation
_path\zenworks\ inv\server\wminv\properties\sql.zip to a
temporary directory retaining the directory structure. For
example, extract sql.zip to c:\sql.

The temporary directory will contain the Sybase directory.

2) If the Sybase Inventory database is either not hosted on the
Inventory server or is running on a port other than 2638,
edit Inventory_server_installation_path\zenworks\inv\server\
wminv\properties\sqlupdater.properties to specify the host
and port on which the Sybase Inventory database is running.

3) At the Inventory server command prompt, navigate to
Inventory_server_installation_path\zenworks\inv\server\
wminv\bin, and enter: sybindex -path
\sybase.

For example, sybindex -path c:\sql\sql\sybase where sql is the
directory to which sql.zip is extracted in Step 1.

NOTE: This execution might take significant amount of time to
complete depending on the database size.

4. If your Inventory database is running MSSQL database, execute the
following scripts available in the MSSQL directory of
\zenworks\inv\server\wminv\
properties\sql.zip with appropriate user logins as explained below
from the MS SQL Query Analyzer:

a. Log in as CIM and execute mssql_perf_cim.sql.
b. Log in as ZENworks and execute mssql_perf_zenworks.sql.
c. Log in as ManageWise and execute mssql_perf_managewise.sql.
d. Log in as MW_DBA and execute mssql_perf_mw_dba.sql.

Ignore any warnings related to CREATE or DROP statements during the script
execution.

5. Restart the Inventory Service.

a. On a NetWare server, type the following command at the server
console:

STARTINV.NCF

b. From the desktop of a Windows server, click Start > Settings >
Control Panel > Administrative Tools > Services, right-click the
Novell Inventory Service, then click Start.

6. Restart the ConsoleOne.

.
This TID is only applicable if you have at least the level of code specified below:

For ZDM7: this is ZENworks 7 with SP1 Desktop Management, available atNovell Downloads

For ZDM6.5 SP2: fixed in ZENworks 6.5 Desktop Management SP2 IR1 or newer found atNovell Downloads

Additional Information

The indexes of the Inventory database would have become aged or fragmented and have to be recreated.

Formerly known as TID# 10099616 NOVL104172

Change Log

13 May 2010 - Kurt Finlayson - Modified links to point to readmes.