Cisco Headend System Release 2.7 Guide De Montage
Database Fragmentation, Database Used Capacity, and the Doctor Report
740020 Rev H
81
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.
Database Table Extents
============================================================
=Database Table=
=Extents=
authorization
3
elementtable
2
pdsegment
2
============================================================
Explanation of the Doctor Report Output
In the preceding example, no table lists more than 10 extents. Therefore, the database
has been successfully defragmented.
has been successfully defragmented.