Cisco Headend System Release 2.5 Installationsanleitung
Monitor and Eliminate Database Fragmentation
4020695 Rev C
55
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 67).
Load the Database (on page 67).
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.
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 7).
Delete Unneeded EMMs with the dbOptimizer Program (on page 7).
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 62) for
specific instructions on how to use the -z option.
Note: Refer to Unloading the Database to the Hard Drive (on page 62) 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 59).
found in Unload the Database (on page 59).