5.2 Moving the Data from the Internal Sybase to the External Sybase
-
On the device that has the external Sybase database installed, stop the Novell ZENworks Embedded Datastore service.
-
On Windows:
-
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.
-
-
On the device that has the external Sybase database installed, stop the Novell ZENworks Embedded Datastore for auditing service.
-
On Windows:
-
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-audit-asa stop.
-
-
Stop the ZENworks Services on all the ZENworks Servers in the Management Zone. For more information, see Step 2.a in the Backing Up the Embedded Sybase SQL Anywhere Database on a Windows or Linux Server.
-
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 ensure 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.
-
ensure 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:
-
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.
-
-
Delete the database role for the device that has the internal Sybase database installed by running the following command in the DBISQL utility on the external database server:
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/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. For more information, see Step 2.c in the Backing Up the Embedded Sybase SQL Anywhere Database on a Windows or Linux Server.
The ZENworks Server now points to new database.