User`s guide
Table Of Contents
- Contents
- About This Guide
- Introduction
- Installation
- Start-Up
- Configuration
- Displays
- Statistics
- Device Management
- Dial Function
- Firmware Download
- Reports
- Session
- Platform/Network Performance Monitor
- Hard Disk and System Recommendations
- NMS Windows Conventions
- Record and Device Locks
- Cabling Requirements
- Data Input Sheets
- Glossary
- Index
Hard Disk and System Recommendations
13-12
6700-A2-GY31-70
July 1999
This is an alternative method to reorganize the database. The procedure below
unloads the database into a temporary file, reinitializes the database, and then
reloads the database.
The temporary file is placed in the system default temporary directory, if found. If
no TEMP variable is defined in AUTOEXEC.bat, then look in \WINDOWS\TEMP.
There must be adequate free space on the drive that contains the temporary
directory. The amount of space required could be twice the size of the database
file.
This process will correct fragmentation of the tables within the database file. To
correct fragmentation of the database file, use Windows DEFRAG or a similar
third party utility.
Procedure
To perform a reorganization with Release 5.0, do the following:
1. Ensure that the COMSPHERE 6700 Series NMS is shut down.
2. Backup the database file, C:\PCNMS\DCWRK\DCWRK.DBS and press OK.
If an error occurs during reorganization, both the temporary file and the
database could be lost.
3. Using the RUN function available within the Program Manager File Menu,
type C:\PCNMS\EXE\SQLTALK.EXE and press OK.
4. In the Login dialog box, enter DCWRK for the database name and choose OK.
5. At the prompt SQL> in the SQLTALK window, type REORGANIZE; and press
Enter.
6. After several lines of progress information, the prompt SQL> will reappear.
The amount of time required for the reorganization is dependent on both the
size of the database and the processing speed of the PC. The database
reorganization could take an hour or longer.
7. Type EXIT and press Enter.