Database Best Practices and Tips
333
n
ov
do
cx (e
n)
16
Ap
ril 20
10
2. Type the option number corresponding to Stop.
3. Press Enter twice.
For the External Database:
Stop the Novell ZENworks Embedded Datastore Service by
stopping the Windows Services manager on Windows, or by running the
/etc/init.d/
sybase-asa stop
command on Linux.
9
At the console prompt of the database server, run the following command to start the database
service:
On Windows:
dbeng10 %ZENWORKS_HOME%\database\zenworks_ZONE_NAME.db -n
rebuild
On Linux:
dbeng10 /var/opt/novell/zenworks/database/zenworks_ZONE_NAME.db
-n rebuild
10
Create a temporary directory with the name as
unload
within
c:\dbreload\
on Windows or
within
/tmp/dbreload/
on Linux.
11
Run the unload command.
On Windows:
dbunload -c "UID=zenadmin;PWD=
database_password
;ENG=rebuild" -
an c:\dbreload\unload\zenworks_<
management_zone_name>
.db
On Linux:
dbunload -c "UID=zenadmin;PWD=
database_password
;ENG=rebuild" -an
/tmp/dbreload/unload/zenworks_
<management_zone_name
>.db
12
After the database rebuild has been successfully completed, take a reliable backup of the newly
built database.
If you encounter any issues during the rebuild process, contact
Novell Support (http://
www.novell.com/support)
.
13
Stop the Novell ZENworks Embedded Datastore service by using the dbeng10 command:
On Windows:
Right-click the
Rebuild
icon located in Windows taskbar, then click
Shutdown
.
On Linux:
At the console prompt, enter
q
.
14
Overwrite the database and applicable log file in the database directory with the new ones
located in the
unload
directory (
zenworks_
management_zone_name
.*
).
The
unload
directory is located in
c:\dbreload\
on Windows or in
/tmp/dbreload/
on
Linux.
15
Start the Novell ZENworks Embedded Datastore service.
For the Embedded Database:
Start all the ZENworks services, including the Novell
ZENworks Embedded Datastore service:
1. At the console prompt, run the
novell-zenworks-configure -c Start
command.
2. Type the option number corresponding to Start.
3. Press Enter twice.
For the External Database:
Start the Novell ZENworks Embedded Datastore service in
the Services window on Windows, or run the
/etc/init.d/sybase-asa start
command on Linux.
16
Take a backup of the newly created database on a regular basis (daily or weekly).
