32.5 Upgrading Workstation Inventory

To upgrade Workstation Inventory from ZENworks 6.5x Desktop Management to ZENworks 7, perform the following tasks in the order listed:

  1. Review the information in Section 32.5.1, Pre-Upgrade Considerations.

  2. Perform the tasks explained in Section 32.5.2, Tasks To Be Performed Before Upgrade and Database Migration.

  3. Perform the tasks explained in Section 32.5.3, Upgrading the ZENworks 6.5x Workstation Inventory Components.

  4. Perform the tasks explained in Section 32.5.4, Tasks to Perform after Database Migration.

32.5.1 Pre-Upgrade Considerations

Before you upgrade the Inventory components from ZENworks 6.5x Desktop Management to ZENworks 7, review the facts in the following sections:

Inventory Server

  • Both ZENworks 7 Inventory servers and ZENworks 6.5x Desktop Management Inventory servers can reside in the same eDirectory™ tree.

  • ZENworks 6.5x Desktop Management Inventory servers can roll up inventory data to a ZENworks 7 Inventory server, but a ZENworks 7 Inventory server cannot roll up inventory data to a ZENworks 6.5x Desktop Management Inventory server.

    If you perform roll-up of your inventory data, ZENworks 6.5x Desktop Management Inventory servers must be upgraded to ZENworks 7 in a top-down order. Upgrade the root server first, then the intermediate servers, and finally the leaf servers.

  • Both ZENworks 6.5x Desktop Management Inventory servers and ZENworks 7 Inventory servers can use ZENworks 6.5x Desktop Management Roll-Up policies that have been upgraded to ZENworks 7.

  • Do not attach a ZENworks 7 Inventory database directly to a ZENworks 6.5x Desktop Management Inventory server; likewise, do not attach a ZENworks 6.5x Desktop Management Inventory database directly to a ZENworks 7 Inventory server. Upgrade the Inventory server and its database in unison. Although you can migrate all the supported databases (Sybase, Oracle, and MS SQL), the ZENworks 7 Desktop Management installation automatically upgrades only the Sybase database.

  • Do not have a ZENworks 6.5x Desktop Management Inventory server and a ZENworks 7 Inventory server store inventory data directly to the same Inventory database.

  • A ZENworks 7 Inventory server can process .zip files from ZENworks 6.5x Desktop Management Inventory servers.

  • Do not delete the ZENworks 6.5x Desktop Management .str and .zip files in a ZENworks 6.5x Desktop Management Inventory server's SCANDIR directories after you've upgraded the Inventory server to ZENworks 7.

  • Upgrading a ZENworks 6.5x Desktop Management Inventory server to ZENworks 7 does not change the role of the Inventory server.

Inventory Agent

  • The ZENworks 6.5x Desktop Management Inventory agent can send inventory data to a ZENworks 7 Inventory server, which means the data can be stored in a ZENworks 7 Inventory database.

    The ZENworks 7 Inventory agent cannot send inventory data to a ZENworks 6.5x Desktop Management Inventory server, which means the data cannot be stored in a ZENworks 6.5x Desktop Management Inventory database.

    Do not upgrade to the ZENworks 7 Inventory Agent until you've upgraded your Inventory servers and databases.

  • The ZENworks 6.5x Desktop Management Inventory agent, and the ZENworks 7 Inventory agent can all use a ZENworks 6.5x Desktop Management Inventory policy that has been upgraded to ZENworks 7, or they can use a ZENworks 7 Inventory policy created with the ZENworks 7 Desktop Management snap-ins.

  • If you want to install or upgrade the ZENworks 6.5x Desktop Management agents through Workstation Imaging, ensure that the image is taken on a ZENworks 7 Desktop Management workstation that is unregistered.

Management Console

  • You can use ZENworks 7 Desktop Management snap-ins to ConsoleOne to administer the inventory data and inventory objects for ZENworks 6.5x Desktop Management and ZENworks 7 (such as Inventory Service object, database objects, Workstation Inventory policy, Roll-Up policy, Dictionary Update policy, and Database Location policy).

  • You cannot use the ConsoleOne snap-ins for ZENworks 6.5x Desktop Management to administer ZENworks 7 Desktop Management inventory data and inventory objects.

  • Do not use the management consoles of ZENworks 6.5x Desktop Management or ZENworks 7 Desktop Management to configure the same ZENworks for Desktops 4.x Inventory objects.

32.5.2 Tasks To Be Performed Before Upgrade and Database Migration

After reviewing the facts mentioned in Section 32.5.1, Pre-Upgrade Considerations, you must perform the following tasks in order before you upgrade from ZENworks 6.5x Desktop Management to ZENworks 7 Desktop Management:

  1. Stop the Inventory service.

    1. On a NetWare® Inventory server: At the server console prompt, enter sys:\system\invstop.ncf.

      If you do not want the Sybase database to be stopped automatically when you stop the Inventory services, comment the Unload dbsrv8.nlmline in the sys:\system\invstop.ncf file.

    2. On a Windows 2000/2003 Inventory server: In the Control Panel, double-click Administrative Tools, double-click Services, select Novell Inventory Service, then click Stop.

  2. Stop the Inventory database.

    1. On NetWare: At the Sybase console prompt, press the Q key.

    2. On Windows 2000/2003: In the Control Panel, double-click Administrative Tools, double-click Services, select Novell Database - Sybase, then click Stop.

  3. Stop the ZENworks Web server.

    On Windows 2000/2003: In the Control Panel, double-click Administrative Tools, double-click Services, select Novell ZFS Web Server, then click Stop.

  4. If Java has not been unloaded on the target NetWare servers, unload java.nlm (at the server console, enter java -exit).

    IMPORTANT:This command stops all Java processes running on the server. Verify that all Java processes are stopped while you are installing ZENworks 7 Desktop Management.

  5. On the target Windows servers, close the Services window.

  6. Make sure that you have made and archived a reliable backup of the database for ZENworks 6.5x Desktop Management

  7. Make sure that the database for ZENworks 6.5x Desktop Management is not accessed from ConsoleOne.

  8. Make sure that the recommended ZENworks 7 Workstation Inventory requirements are met. For more information, see Section II, Preparation.

  9. If ZENworks_installation_path\zenworks\inv\server\wminv\ properties\inventoryremoval.properties has been modified after the ZENworks 6.5x Desktop Management installation, take a reliable backup of inventoryremoval.properties.

  10. Make sure that the schema has been migrated to ZENworks 7. You can migrate the schema by using the ZENworks 7 Desktop Management installation program. For more information on how to migrate the schema, see Section 9.1.1, Extending the Schema Before the Installation.

  11. Before upgrading the Inventory server, make sure that you have upgraded its associated database server.

  12. If you have a ZENworks 6.5x Desktop Management database running Oracle, you must perform the following tasks before the migration:

    1. Ensure that the Oracle's version is 9.2.0.6 or later.

    2. In inventory_database_installation_path\init.ora_path\init.ora, set the value the following parameters as shown below:

      • db_cache_size=192M
      • sort_area_size=10000000
      • shared_pool_size = 157286400
      • open_cursors = 2048
      • log_buffer = 1024000
      • session_cached_cursors=2048
      • compatible=9.2.0

      You could increase the cache size and shared pool to have Shared Global Area (SGA) to 30-40% physical RAM size.

    3. Ensure that the Inventory database is up and running.

      You must have a larger rollback segment because the database migration and the storage of further data cannot succeed because of ORA-01555 and other rollback segment-related issues.

    4. Increase the value of the rollback segment by executing the following sql script to add an additional data file to the rollback segment (rbs) and to add a Redo log group:

      connect / as sysdba;
      
      alter tablespace rbs add datafile ’Inventory_database_installation_path\rbs2.ora’ size 40M autoextend on next 50K maxsize 60M;
      
      alter rollback segment rb0 storage (maxextents unlimited);
      
      alter rollback segment rb1 storage (maxextents unlimited); 
      
      ALTER DATABASE ADD LOGFILE GROUP 3 (’Inventory_database_installation_path\log3.ora’) SIZE 50M;
      
    5. Stop the Inventory database.

    6. Ensure that the value of the compatible parameter in inventory_database_installation_path\path_to_init.ora\init.ora is set to 9.2.0 or later.

    7. If the size of any data file is about to exceed 4096 MB, you must add extra data files to the corresponding tablespace.

    8. Extract the appropriate, platform-specific atlasperf_altertablespace.sql from zenworks_installation_directory\zenworks\inv\server\wminv\properties\sql.zip to C:.

      If Oracle is running on Windows, extract atlasperf_altertablespace.sql from the oracle\winntspecific directory within sql.zip.

      If Oracle is running on UNIX, extract atlasperf_altertablespace.sql from the oracle\unixspecific directory within sql.zip.

    9. Edit atlasperf_altertablespace.sql to set the value of maxsize for all data files to nearest multiple of 4 GB.

      For example, if the size of CIM8.ora is 5 GB, then set the value of MAXSIZE to 8192 MB.

    10. Ensure that the file path of all data files listed in atlasperf_altertablespace.sql is correct.

    11. Restart the Inventory database.

    12. Execute altaslperf_altertablespace.sql.

32.5.3 Upgrading the ZENworks 6.5x Workstation Inventory Components

You can upgrade the ZENworks 6.5x Desktop Management Workstation Inventory components by installing ZENworks 7 Desktop Management (or SP1), if the machine where you want to install the ZENworks 7 Desktop Management meets the installation requirements. For more information about the installation requirements, see Section II, Preparation.

The ZENworks 7 Desktop Management Inventory server supports the same set of roles as ZENworks 6.5x Desktop Management. Therefore, when you upgrade from ZENworks 6.5x Desktop Management to ZENworks 7 Desktop Management, the role of the Inventory server is retained.

The ZENworks 7 Desktop Management installation program (or the SP1 installation program) automatically migrates all the ZENworks 6.5x Desktop Management policies to ZENworks 7 Desktop Management (or to ZENworks 7 Desktop Management with SP1).

32.5.4 Tasks to Perform after Database Migration

You must perform the following tasks after upgrading the Inventory server and migrating the Inventory database is complete:

  1. Stop the Inventory service.

  2. If your Inventory database is running Oracle, do the following to improve the database performance:

    1. Extract atlasperf_alterfreelist.sql from zenworks_installation_directory\zenworks\inv\server\wminv\properties\sql.zip and execute at the SQLPLUS prompt.

    2. Execute the oracle\common\oracle_perf.sql and oracle\common\oracle_perf2.sql files from inventory_server_installation_path\zenworks\inv\server\wminv\properties\sql.zip to add performance enhancing indexes to the database.

    3. Execute oracle_dbexport_perf.sql from the Novell ZENworks 7 Companion 2 CD \database\oracle8i\common directory or from the Novell ZENworks 7 Companion with Support Pack 1 Companion 2 CD \database\oracle_x\common directory.

    4. (Conditional) If you are migrating from ZENworks 6.5 Desktop Management SP1 Hot Patch 1 or Hot Patch 2, or ZENworks 6.5 Desktop Management SP2, extract \oracle\common\zfd65sp1hp1_65sp2_70.sql from zenworks_installation_directory\zenworks\inv\server\wminv\properties\sql.zip and execute it at the SQLPLUS prompt.

      For more information on how to improve the performance of the Inventory database, see Performance Tips in Workstation Inventory in the Novell ZENworks 7 Desktop Management Administration Guide.

  3. (Optional) If the Inventory database is running MS SQL, execute the following scripts from inventory_server_installation_path\zenworks\inv\server\wminv\properties\sql.zip with appropriate user logins as explained below from the MS SQL Query Analyzer:

    1. Login as CIM, and execute mssql_perf_cim.sql.

    2. Login as mw_dba and execute mssql_perf_mw_dba.sql.

    3. Login as zenworks and execute msswl_perf_zenworks.sql.

    4. (Conditional) If you are migrating from ZENworks 6.5 Desktop Management SP1 Hot Patch 1or Hot Patch 2, or ZENworks 6.5 Desktop Management SP2, log in as CIM and execute \mssql\zfd65sp1hp1_65sp2_70.sql.

      This enhances the performance of the Inventory database.

      For more information on how to improve the performance of the Inventory database, see Performance Tips in Workstation Inventory in the Novell ZENworks 7 Desktop Management Administration Guide.

  4. Start the Inventory services.