Cisco Headend Digital Broadband Delivery System Guide De Montage
Chapter 5 Manage the Database with the dncsDbData Utility
80
740020 Rev H
Example of a Fragmented Database
The following example from the Doctor Report illustrates a fragmented database.
DNCS Database Check
============================================================
Total tempspace = 20520 pages ( 40.0 M)
Free tempspace = 20083 pages ( 39.2 M)
Database tempspace is at 2.2% used capacity.
Total dataspace = 2097150 pages ( 4095.9 M)
Free dataspace = 1919078 pages ( 3748.1 M)
OK: Database dataspace is at 8.5% used capacity.
Database Table Extents
============================================================
=Database Table=
=Extents=
atm_connection
7
displaychannels
2
elementary_stream
5
elementtable
5
elementtosource
3
emm
161
filemoduleinfo
6
hct_profile
65
============================================================
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.