Cisco Headend System Release 2.7 Installation Guide
List EMMs by Age
740020 Rev H
15
List EMMs by Age
Summarizing the Ages of EMMs on Your System
Use the following procedure to generate a list that shows the ages of EMMs that are
in your database.
1 If necessary, open an xterm window on the DNCS.
2 Type dbOptimizer -h and then press Enter. The system generates a list of EMMs
in your database.
1 If necessary, open an xterm window on the DNCS.
2 Type dbOptimizer -h and then press Enter. The system generates a list of EMMs
by age.
dboptimizer -h
--------------------------------------------------------------------------------------------------
Mar 19, 9:09:46 -- dbOptimizer Started
dbOptimizer Options selected: -h
Total DHCTs (secure_micro rows) in the database:
dboptimizer -h
--------------------------------------------------------------------------------------------------
Mar 19, 9:09:46 -- dbOptimizer Started
dbOptimizer Options selected: -h
Total DHCTs (secure_micro rows) in the database:
51136
Total DHCTs with IPPV flag set (sm_admin_state=1): 41
Total EMMs in the database:
Total EMMs in the database:
1700549
--------------------------------------------------------------------------------------------------
Non-staging EMMs req'd for operation:
Non-staging EMMs req'd for operation:
348893
21%
Staging EMMs 10 days old or less:
46473
3%
Staging EMMs over 10 days old:
1298028
76%
Staging EMMs over 20 days old:
1215300
71%
Staging EMMs over 30 days old:
1161462
68%
Staging EMMs over 40 days old:
1065018
63%
Staging EMMs over 50 days old:
972708
57%
Staging EMMs over 60 days old:
873933
51%
Staging EMMs over 70 days old:
788883
46%
Staging EMMs over 80 days old:
755403
44%
Staging EMMs over 90 days old:
718197
42%
Mar 19, 9:20:53 dbOptimizer Ended
--------------------------------------------------------------------------------------------------
Notes:
--------------------------------------------------------------------------------------------------
Notes:
The system depicted in this illustration shows a total of 1700549 EMMs in the
database.
database.
Of those 1700549 EMMs, 348893 are still needed for operation. You may,
therefore, be able to delete the other 1351656 EMMs from your database
(1700549 - 348893 = 1351656).
therefore, be able to delete the other 1351656 EMMs from your database
(1700549 - 348893 = 1351656).