User`s guide

Hard Disk and System Recommendations
13-11
6700-A2-GY31-70
July 1999
UserDefaults=No
UserDevices=No
UserProfile=No
UserStraps=No
UserThresholds=No
Database Reorganization
Database reorganization is necessary:
H When the database file becomes fragmented by repeated changes of tables
and the speed of database operation is affected.
H After using the Purge All Calls and Purge Alerts commands.
Reorganization procedures are provided for Release 4.0 and Release 5.0.
" Procedure
To perform a reorganization with Release 4.0, do the following:
1. Ensure that the COMSPHERE 6700 Series NMS is shut down.
2. Using the RUN function available within the Program Manager File Menu
item, type \PCNMS\EXE\WINTALK and press OK.
3. Select the Session and Connect menu items.
4. Select DCWRK, then choose OK.
5. Select the Utilities and Export menu items.
6. Choose the Entire Database check box, then choose OK.
7. After the export is completed, select the Session and Disconnect menu items,
then choose OK.
8. Select the Admin and Install Database menu items.
9. Type DCWRK within the Database edit field.
10. Choose the New check box, then choose the Overwrite check box.
11. Select the Session and Connect menu items after the database is installed.
12. Select DCWRK, then choose OK.
13. Type set recovery off; then press CTRL/ENTER.
14. Select the Utilities and Import menu items.
15. Choose DCWRK.SQL from the Files list box, then choose OK.
16. Select the File and Exit menu items.
17. Choose No from the {untitled} has changed. Save current changes?
message box.
18. Choose Yes from the Disconnect All Databases? message box.