Cisco Headend System Release 2.7 Installation Guide
Overview of the checkDB Script
740020 Rev H
105
Prerequisites
Consider the following important prerequisites before you run the checkDB script:
Be sure that you have a current backup of your DNCS database before running
the checkDB script with the -f or -F options. Refer to the appropriate copy of the
backup and restore procedures for detailed instructions on how to back up the
DNCS database.
Note: The checkDB script makes no database changes when run with no options
or with the -v option. The script may change the database when run with the -f
or -F options. Refer to Run the checkDB Script (on page 106) for additional
information concerning the options associated with the checkDB script.
the checkDB script with the -f or -F options. Refer to the appropriate copy of the
backup and restore procedures for detailed instructions on how to back up the
DNCS database.
Note: The checkDB script makes no database changes when run with no options
or with the -v option. The script may change the database when run with the -f
or -F options. Refer to Run the checkDB Script (on page 106) for additional
information concerning the options associated with the checkDB script.
If you configure the checkDB script to automatically remove orphaned records
from the DNCS database, you need two other utilities installed on your DNCS to
complete the task: delete-sm and deleteDhct. Both utilities are included on the
DBDS Utilities CD.
Note: Refer to Chapter 3, Reset DHCT Configuration With the delete-sm Utility
(on page 21), of this DBDS Utilities Version 5.1 Installation Instructions and DNCS
Utilities User’s Guide for information about the delete-sm utility. Refer to The
deleteDhct Utility (on page 105) for information about the deleteDhct utility.
from the DNCS database, you need two other utilities installed on your DNCS to
complete the task: delete-sm and deleteDhct. Both utilities are included on the
DBDS Utilities CD.
Note: Refer to Chapter 3, Reset DHCT Configuration With the delete-sm Utility
(on page 21), of this DBDS Utilities Version 5.1 Installation Instructions and DNCS
Utilities User’s Guide for information about the delete-sm utility. Refer to The
deleteDhct Utility (on page 105) for information about the deleteDhct utility.
The deleteDhct Utility
When used with the -f or -F options, the checkDB script calls the deleteDhct utility in
order to delete DHCT records from the database. The logic of the checkDB script is
such that all references to the deleteDhct utility occur automatically; no user
intervention is required. The deleteDhct utility is included on the DBDS Utility CD.
order to delete DHCT records from the database. The logic of the checkDB script is
such that all references to the deleteDhct utility occur automatically; no user
intervention is required. The deleteDhct utility is included on the DBDS Utility CD.
The deleteDhct utility was designed by Cisco to completely delete DHCT records
from the DNCS database. It deletes a single DHCT or can delete all DHCTs in a list
containing DHCT MAC addresses that are presented in a text file.
from the DNCS database. It deletes a single DHCT or can delete all DHCTs in a list
containing DHCT MAC addresses that are presented in a text file.
The logic in the deleteDhct utility is very good at finding all database rows in all the
different DHCT tables that contain or used to contain records for the specified
DHCT(s). The deleteDhct utility deletes orphaned DHCT records. While orphaned
DHCT records are less common now than they have been in the past, at one time
duplicate database rows were generated for RMA DHCTs when they were returned
from repair with a changed secure_micro address.
different DHCT tables that contain or used to contain records for the specified
DHCT(s). The deleteDhct utility deletes orphaned DHCT records. While orphaned
DHCT records are less common now than they have been in the past, at one time
duplicate database rows were generated for RMA DHCTs when they were returned
from repair with a changed secure_micro address.