ZENworks 10 Asset Management allows you move the data from a Sybase SQL Anywhere database (embedded Sybase database) to an OEM Sybase database (external Sybase database).
Before moving the data from an internal Sybase database to an external Sybase database, do the following:
Make sure that ZENworks 10 Asset Management is installed with an internal Sybase database on a Windows or Linux device.
Install the external Sybase database. 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.
On the device that has the external Sybase database installed, stop the Novell ZENworks Embedded Datastore service.
On Windows: Do the following:
From the Windows desktop
menu, click > .Double-click
> .Right-click the
service, then click , or select the service, then click on the toolbar.On Linux: At the console prompt, enter /etc/init.d/./sybase-asa stop.
Stop all the ZENworks Services on all the ZENworks Servers in the Management Zone.
On Windows: Do the following
Execute the following command at the server prompt:
novell-zenworks-configure -c Start
Specify the number next to the Stop action, then press Enter.
On Linux: Do the following:
Execute the following command at the server prompt:
/opt/novell/zenworks/bin/novell-zenworks-configure -c Start
Specify the number next to the Stop action, then press Enter.
From the device that has the internal Sybase database installed, copy zenworks_database.conf and all files within the database directory to the appropriate directories on the device that has the external Sybase database.
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 on Windows and in the /var/opt/novell/zenworks/ directory on Linux.
On the device that has the external Sybase database installed, open zenworks_database.conf and make sure that it contains the correct path of the database file.
On the device that has the internal Sybase database installed, edit zdm.xml (located in ZENworks_installation_path\conf\datamodel on Windows and in /etc/opt/novell/zenworks/datamodel on Linux):
Change the value of the Embedded entry key to false. By default, it is true.
Set the value of the Server entry key to the IP address of the device that has the external Sybase database installed.
Make sure that the value of the Port entry key is the port number on which the external Sybase database is running.
On the device that has the external Sybase database installed, start the Novell ZENworks Embedded Datastore service.
On Windows: Do the following:
From the Windows desktop
menu, click > .Double-click
> .Right-click the
service, then click , or select the service, then click on the toolbar.On Linux: At the console prompt, enter /etc/init.d/./sybase-asa start.
Assign the database role to the device that has the external Sybase database installed by running the following command in the DBISQL utility:
delete from zZenServerRoles where Roles = 'Database';commit;
Remove the Novell ZENworks Embedded Datastore service from the device that has the internal Sybase database installed:
On the Windows device: Perform the following tasks:
At the server prompt, execute the following command:
sc delete SQLANYs_ZENDatastore
Edit the%ZENWORKS_HOME%\conf\monitor.conf to remove dbsrv10 from the line highpriority=zenserver,casaserver,dbsrv10.
On the Linux device: Perform the following tasks:
Stop the Novell ZENworks Embedded Datastore service by executing the following command at the console prompt:
/etc/init.d/sybase-asa stop
Rename sybase-asa to sybase-asa1 by executing the following command:
mv sybase-asa sybase-asa1
Edit the /etc/opt/novell/zenworks/conf/monitor.conf to remove sybase-asa from the line services=novell-zenserver novell-zenload sybase-asa.
Start all the ZENworks Services on all the ZENworks Servers in the Management Zone.
On Windows: Do the following
Execute the following command at the server prompt:
novell-zenworks-configure -c Start
Specify the number next to the Start action, then press Enter.
On Linux: Do the following:
Execute the following command at the server prompt:
/opt/novell/zenworks/bin/novell-zenworks-configure -c Start
Specify the number next to the Start action, then press Enter.
(Conditional) If you have installed ZENworks Reporting Server, continue with Section 28.6.3, Configuring ZENworks Reporting Server to Point from Internal Sybase to External Sybase.
Do the following to point ZENworks Reporting Server to the new database:
Ensure that the data has been moved from the Internal Sybase to the External Sybase as explained in Section 28.6.2, Moving the Data from the Internal Sybase to the External Sybase.
Procure the following information of the new database to which you want ZENworks Reporting to point:
UserID
Password
Server Name
Database Name
IP Address
Enter the following URL in a Web browser:
https://Reporting_Server_IP_Address/zenworks-coreadmin
Click
.Click the following link:
;
Click
.Search for the following parameters and archive their values for later use:
username
Engine
Server
Port
The values are presented within tags. For example, the value for the username parameter is presented within the <entry key=”username”></entry> tag. The default username is zenadmin.
From the desktop
menu, click > .Double-click
> .The ODBC Data Source Administrator dialog box is displayed.
Click
.Click
> .In the ODBC Configuration for SQL Anywhere dialog box that is displayed, do the following:
Click the
tab, then fill in the following fields:UserID: Specify the username of the new database. By default, this field displays zenadmin.
Password: Specify the value of the username parameter that you had archived in
Click the
tab, then fill in the following field:Server Name: Specify the value of the Engine parameter that you had archived in Step 2.e.
Click the
tab, then set the value of the field as follows:host=<IPaddress_of_the_new_database_server:port>
The values of the IPaddress_of _the_new_database_server and port are the values of the <entry key="Server"></entry> and <entry key="Port"></entry> tags respectively that you had archived in Step 2e.
Click the
tab, then click .The SQL Anywhere message is displayed.
Click
.A message is displayed indicating that the connection to the new database is successful.
Click
.Click
.At the console prompt, run the novell-zenworks-configure -c UpdateBOE command.
ZENworks Reporting Server now points to the new database.
Ensure that the data has been moved from the Internal Sybase to the External Sybase as explained in Section 28.6.2, Moving the Data from the Internal Sybase to the External Sybase.
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.
Run the novell-zenworks-configure -c UpdateBOE command.
ZENworks Reporting Server now points to the new database.