29.4 Moving the Data from an External OEM Sybase Database to an Embedded Sybase Database

ZENworks 10 Asset Management allows you move the data from an OEM Sybase database (external Sybase database) to a Embedded OEM Sybase SQL Anywhere database (embedded Sybase database) that is installed on the ZENworks Server.

29.4.1 Preparing to Move the Data

Before moving the data from an external Sybase database to an embedded Sybase database, do the following:

  • Make sure that ZENworks 10 Asset Management is configured to an external OEM Sybase database. The database can be installed on a Windows or Linux device.

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

    During the installation of the embedded Sybase database, you must consider the following points while configuring the Sybase Access Configuration page:

    • The database name can be same as that of the external Sybase database or can be a unique name.

    • Make sure that the username and password are same as that of the external Sybase database.

    • Make sure that the database server name is unique.

29.4.2 Moving the Data from the External Sybase to the Embedded Sybase

  1. Stop all the ZENworks Services on all the ZENworks Servers in the Management Zone.

    • 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 the ZENworks Server that has the embedded Sybase database installed, delete the contents of the database directory.

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

  3. On the device that has the external Sybase database installed, 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.

  4. From the device that has the external Sybase database installed, copy all files within the database directory to the appropriate directories on the ZENworks Server that has the embedded Sybase database.

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

  5. On the ZENworks Server that has the embedded Sybase database installed, open zenworks_database.conf and make sure that it contains the correct path of the database file.

  6. On the ZENworks Server that has the embedded Sybase database installed, edit zdm.xml (located in ZENworks_installation_path\conf\datamodel on Windows and in /etc/opt/novell/zenworks/datamodel on Linux):

    • Add the following entry:

      <entry key="Embedded">true</entry>

    • Set the value of the Server entry key to 127.0.0.1 (the IP address of the ZENworks Server that has the embedded Sybase database installed).

    • Make sure that the value of the Port entry key is the port number on which the embedded Sybase database is running.

    • Set the value of the Engine entry key to the database server name specified during the installation of the embedded Sybase database.

    • (Optional) If you’ve specified a unique database name during the installation of the embedded Sybase database, set the value of the Database entry key to the unique database name.

  7. Start all the ZENworks Services on all the ZENworks Servers in the Management Zone.

    • 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.4.3, Configuring ZENworks Reporting Server to Point from the External Sybase to the Embedded Sybase.

29.4.3 Configuring ZENworks Reporting Server to Point from the External Sybase to the Embedded Sybase

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

Configuring ZENworks Reporting Server to Point to the Embedded Sybase on Windows

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

  2. From the Windows 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.

    • Click Yes on the SQL Anywhere message that appears.

      A message is again 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.

Configuring ZENworks Reporting Server to Point to the Embedded Sybase on Linux

  1. Ensure that the data has been moved from one External Sybase to another External Sybase as explained in Section 29.4.2, Moving the Data from the External Sybase to the Embedded 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.