29.3 Moving the Data from One External Sybase Database to another External Sybase Database

ZENworks 10 Asset Management allows you move the data from one OEM Sybase database (external Sybase database) to another external Sybase database.

29.3.1 Preparing to Move the Data

Before moving the data from one external Sybase database to another external Sybase database, do the following:

  • Make sure that the ZENworks Server is configured to an external Sybase database. The database can be installed on the ZENworks Server, or on a different Windows or Linux device.The data is moved from this database to another external database. Assume that the device that hosts the database is EDB1.

  • Make sure that you have another Windows or Linux device with an external Sybase database installed. Assume that this device to which you are moving the data to is EDB2.

    For more information on how to install an external Sybase database, see Installing an External ZENworks Database in the ZENworks 10 Asset Management Installation Guide.

29.3.2 Moving the Data from One External Sybase to Another External Sybase

  1. Stop all the ZENworks Services on all the ZENworks Servers that are connected to EDB1.

    • On Windows: Do the following

      1. Execute the following command at the server prompt:

        novell-zenworks-configure -c Start

      2. Specify the number next to the Stop action, then press Enter.

    • On Linux: Do the following:

      1. Execute the following command at the server prompt:

        /opt/novell/zenworks/bin/novell-zenworks-configure -c Start

      2. Specify the number next to the Stop action, then press Enter.

  2. On EDB1 and EDB2 devices, stop the Novell ZENworks Embedded Datastore service.

    • On Windows: Do the following:

      1. From the Windows desktop Start menu, click Settings > Control Panel.

      2. Double-click Administrative Tools > Services.

      3. Right-click the Novell ZENworks Embedded Datastore service, then click Stop, or select the Novell ZENworks Embedded Datastore service, then click Stop icon on the toolbar.

    • On Linux: At the console prompt, enter /etc/init.d/./sybase-asa stop.

  3. From the EDB1 device, copy zenworks_database.conf and all files within the database directory to the appropriate directories on the EDB2 device.

    The zenworks_database.conf is located in the ZENworks_installation_path\conf\ directory on Windows and in the /etc/opt/novell/zenworks/ directory on Linux.

    The database directory is located in ZENworks_installation_path by default on Windows and in the /var/opt/novell/zenworks/ directory on Linux.

  4. On the EDB2 device, open zenworks_database.conf and make sure that it contains the correct path of the database file.

  5. On each ZENworks Server that is connected to EDB1, edit zdm.xml (located in ZENworks_installation_path\conf\datamodel on Windows and in /etc/opt/novell/zenworks/datamodel on Linux):

    • Set the value of the Server entry key to the IP address of the EDB2 device.

    • Make sure that the value of the Port entry key is the port number on which the EDB2 device is running.

  6. On the EDB2 device, start the Novell ZENworks Embedded Datastore service:

    • On Windows: Do the following:

      1. From the Windows desktop Start menu, click Settings > Control Panel.

      2. Double-click Administrative Tools > Services.

      3. Right-click the Novell ZENworks Embedded Datastore service, then click Start, or select the Novell ZENworks Embedded Datastore service, then click Start icon on the toolbar.

    • On Linux: At the console prompt, enter /etc/init.d/./sybase-asa start.

  7. Start all the ZENworks Services on all the ZENworks Servers that are connected to the database.

    • On Windows: Do the following

      1. Execute the following command at the server prompt:

        novell-zenworks-configure -c Start

      2. Specify the number next to the Start action, then press Enter.

    • On Linux: Do the following:

      1. Execute the following command at the server prompt:

        /opt/novell/zenworks/bin/novell-zenworks-configure -c Start

      2. Specify the number next to the Start action, then press Enter.

  8. (Conditional) If you have installed ZENworks Reporting Server, continue with Section 29.3.3, Configuring ZENworks Reporting Server to Point from One External Sybase to Another External Sybase.

29.3.3 Configuring ZENworks Reporting Server to Point from One External Sybase to Another External Sybase

Do the following to point ZENworks Reporting Server to the new database:

Connecting ZENworks Reporting Server to the New Database on Windows

  1. Ensure that the data has been moved from one External Sybase to another External Sybase as explained in Section 29.3.2, Moving the Data from One External Sybase to Another External Sybase.

  2. From the desktop Start menu, click Settings > Control Panel.

  3. Double-click Administrative Tools > Data Sources(ODBC).

    The ODBC Data Source Administrator dialog box is displayed.

  4. Click System DSN.

  5. Click ZENworks Database > Configure.

  6. In the ODBC Configuration for SQL Anywhere dialog box that is displayed, do the following:

    • Click the Login tab, then specify the userID and password of the new database.

    • Click the Database tab, then do the following:

      • In the Server Name field, specify the server name of the new database.

      • In the Database Name field, specify the name of the new database.

    • Click the Network tab, then set the value of the TCP/IP field as follows:

      host=<IPaddress of the new database server:port>

    • Click the ODBC tab, then click Test Connection.

      The SQL Anywhere message is displayed.

    • Click Yes.

      A message is displayed indicating that the connection to the new database is successful.

    • Click OK.

  7. Click OK.

  8. At the console prompt, run the novell-zenworks-configure -c UpdateBOE command.

ZENworks Reporting Server now points to the new database.

Connecting ZENworks Reporting Server to the New Database on Linux

  1. Ensure that the data has been moved from one External Sybase to another External Sybase as explained in Section 29.3.2, Moving the Data from One External Sybase to Another External Sybase.

  2. Edit the /opt/novell/zenworks/share/boe/bobje/odbc.ini file as follows:

    • Set the value of the ServerName variable to the server name of the new database.

    • Set the value of the DatabaseName variable to the name of the new database.

    • Set the value of the CommLinks variable to the IP address and port of the new database server.

  3. Run the novell-zenworks-configure -c UpdateBOE command.

ZENworks Reporting Server now points to the new database.