Cisco Headend System Release 2.7 Installation Guide
Monitor and Eliminate Database Fragmentation
740020 Rev H
61
5 Run dncsDbData with the -l option to drop the DNCS database and then reload
it.
Notes:
Notes:
Dropping the database and then reloading it eliminates the fragmentation.
Procedures for running the dncsDbData utility with the -l option are found in
Load the Database (on page 73).
Load the Database (on page 73).
You are instructed to restart the system components after reloading the
database.
database.
6 Back up the database again.
Eliminating Database Fragmentation in the Application Server Database
When the Doctor Report indicates that the number of extents associated with the
prvdrneutraldata table in the Application Server database has reached 10, system
operators should plan to run the following procedures on the DNCS.
prvdrneutraldata table in the Application Server database has reached 10, system
operators should plan to run the following procedures on the DNCS.
Important! The following procedures are in outline form, only. Be sure to refer to
the specific procedures referenced in each step to eliminate database fragmentation.
1 Run the dbOptimizer program to delete unneeded EMMs from the database.
the specific procedures referenced in each step to eliminate database fragmentation.
1 Run the dbOptimizer program to delete unneeded EMMs from the database.
Note: Procedures for running the dbOptimizer program are found in Chapter 2,
Delete Unneeded EMMs with the dbOptimizer Program (on page 13).
Delete Unneeded EMMs with the dbOptimizer Program (on page 13).
2 Back up the database.
Notes:
Refer to the appropriate backup and restore procedures for instructions on
how to back up the database.
how to back up the database.
When you back up the database, the system backs up both the DNCS
database and the Application Server database.
database and the Application Server database.
3 Run the dncsDbData utility using the -z option to determine whether you can
unload the Application Server database to the hard drive of the DNCS.
Note: Refer to Unloading the Database to the Hard Drive (on page 68) for
specific instructions on how to use the -z option.
Note: Refer to Unloading the Database to the Hard Drive (on page 68) for
specific instructions on how to use the -z option.
4 Run dncsDbData with the -u option to unload the Application Server database.
Note: Procedures for running the dncsDbData utility with the -u option are
found in Unload the Database (on page 65).
found in Unload the Database (on page 65).