Руководство По Установке для Cisco Headend System Release 2.7
Database Fragmentation, Database Used Capacity, and the Doctor Report
4020695 Rev C
75
Explanation of the Doctor Report Output
The preceding example shows output from two headings of the Doctor Report:
DNCS Database Check and Database Table Extents. Notice that two of the tables
under the Database Table Extents heading consist of more than ten extents. The
emm and hct_profile tables consist of 161 and 65 extents, respectively. The system
operator of this database should take steps to defragment this database.
DNCS Database Check and Database Table Extents. Notice that two of the tables
under the Database Table Extents heading consist of more than ten extents. The
emm and hct_profile tables consist of 161 and 65 extents, respectively. The system
operator of this database should take steps to defragment this database.
Note: Because system operators regularly load EMM CDs, the emm table is
especially subject to fragmentation.
especially subject to fragmentation.
Notice also the last line of data under the DNCS Database Check heading. This line
of data indicates that the database is at 8.5 percent used capacity. The Doctor Report
displays an error condition once the database reaches 75 percent used capacity.
of data indicates that the database is at 8.5 percent used capacity. The Doctor Report
displays an error condition once the database reaches 75 percent used capacity.
The next section, The Doctor Report Output After Defragmenting the Database,
shows the Doctor Report output of the same database after using the dncsDbData
utility to defragment the database.
shows the Doctor Report output of the same database after using the dncsDbData
utility to defragment the database.
The Doctor Report Output After Defragmenting the Database
The following example from the Doctor Report depicts the same database after you
have used the dncsDbData utility to defragment the database.
have used the dncsDbData utility to defragment the database.
Example of a Defragmented Database
The following example from the Doctor Report illustrates a defragmented database.
DNCS Database Check
============================================================
Total tempspace = 20520 pages ( 40.0 M)
Free tempspace = 20467 pages ( 39.9 M)
Database tempspace is at 0.3% used capacity.
Total dataspace = 2097150 pages ( 4095.9 M)
Free dataspace = 565463 pages ( 1104.4 M)
OK: Database dataspace is at 73.1% used capacity.