Cisco Headend System Release 2.7 Installation Guide

Page of 252
 
Chapter 8    Identify and Correct Database Problems with the checkDB Script 
 
 
 
106 
4020695 Rev C 
 
Analysis of Logfile 
Refer to the preceding logfile as you read through this analysis. Your logfiles are 
likely to contain similar points of interest. 
Analysis of checkDB Logfile 
Line Numbers 
Explanation 
Lines 2 and 3 
Lines 2 and 3 indicate how many records exist in the 
hct_profile and secure_micro tables in the database. 
Line 4 
Line 4 indicates the maximum value for subscription 
packages in the eu_eid column in the package table. 
Important: Sites where this value exceeds 220 should 
report this condition to Cisco Services. 
Line 5 
Line 5 reports registration configuration. Options are 
Open Registration and Administrative Gateway. Our 
engineers recommend Administrative Gateway to 
prevent DHCTs from being added to your system 
without your knowledge. 
Lines 6 through 10 
These lines identify DHCTs that are in the database 
without serial numbers. Line 6 indicates that there are 
65,407 DHCTs in the database without a serial number. 
Line 8 begins to list them, but the list has been truncated 
in this example to conserve space. 
Contact Cisco Services if your logfile indicates that you 
have DHCTs in the database without serial numbers. 
Cisco Services will retrieve the list from your DNCS and 
will insert the correct serial numbers into your database. 
Lines 11 through 15 
These lines identify 233 DHCTs with serial number and 
MAC address entries in the pdsernummap table, but 
without a required corresponding entry in the 
hct_profile table. The checkDB script therefore concludes 
that these are orphaned records and recommends that 
they be deleted. 
Line 16 
This line reports that there are no entries in the 
secure_micro table of DHCTs that have a MAC address 
but have no corresponding entry in the hct_profile table.