Database Best Practices and Tips
36
331
n
ov
do
cx (e
n)
16
Ap
ril 20
10
36
Database Best Practices and Tips
This sections includes some tips and best practices for Sybase database:
Section 36.1, “Database Best Practices,” on page 331
Section 36.2, “Database Tips,” on page 334
36.1 Database Best Practices
Section 36.1.1, “Rebuilding the Embedded or External Sybase Database,” on page 331
36.1.1 Rebuilding the Embedded or External Sybase Database
If you have an embedded or external Sybase database installed, you should rebuild the database so
that it runs on the latest version of the Sybase database engine.
1
Make sure that you have archived your database credentials.
To archive the credentials of an external Sybase database, contact your database administrator.
To archive the credentials of an embedded or external OEM Sybase database, perform the
following tasks on the database server:
1a
Make sure the database service is running.
On Windows:
In the Windows Services, make sure that the status of
Novell ZENworks
Embedded Datastore
is
Started
.
On Linux:
At the console prompt, enter
/etc/init.d/sybase-asa status
to verify
the status of the database. If the database is not running, enter
/etc/init.d/./sybase-
asa start
.
1b
Obtain the Sybase connection information by running the
zman dgc
command.
1c
Provide the credentials of the ZENworks administrator when prompted.
1d
Copy and save the database username and password in to a text file.
2
Stop the Novell ZENworks Embedded Datastore service, if it is running.
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 on the toolbar.
On Linux:
At the console prompt, enter
/etc/init.d/sybase-asa stop
.
3
At the console prompt, go to the Sybase database directory. By default, it is
%ZENWORKS_HOME%\database
on Windows, and
/var/opt/novell/zenworks/database
on
Linux.
4
Take a reliable backup of the
zenworks_zone_name.db
and
Zenworks_zone_name.log
files.
Содержание ZENWORKS 10 CONFIGURATION MANAGEMENT SP3 - NETWORK DISCOVERY DATABASE STRUCTURE
Страница 4: ...4 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 18: ...18 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 26: ...26 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 60: ...60 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 64: ...64 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 70: ...70 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 78: ...78 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 98: ...98 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 118: ...118 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 138: ...138 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 140: ...140 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 142: ...142 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 144: ...144 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 162: ...162 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 164: ...164 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 168: ...168 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 170: ...170 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 190: ...190 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 212: ...212 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 214: ...214 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 224: ...224 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 234: ...234 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 236: ...236 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 242: ...242 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 250: ...250 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 256: ...256 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 282: ...282 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 284: ...284 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 290: ...290 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 292: ...292 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 330: ...330 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 338: ...338 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 340: ...340 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 348: ...348 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 360: ...360 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 362: ...362 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 368: ...368 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 374: ...374 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...