5-15
Cisco Media Gateway Manager 5.0 User Guide
OL-5461-02
Chapter 5 Maintaining an Efficient Network
How Do I Manage the Database?
Prune alarm and event data
(prune_fm.sh)
alarm_event_table
active_alarm_table
Number of days
1–31
Removes all alarm and event entries
that were created before n days.
Prune admin job table
(prune_admin_job_table.sh)
admin_job_table Number of days
1–31
Removes all admin job entries that
were created before n days.
Prune server monitor table
(prune_server_monitor.sh)
server_monitor_table Number of days
1–31
Removes all server monitor entries
that were created before n days.
Prune PM data (prune_pm.sh) all_data tables Number of days
1–31
Removes all PM entries that were
created before n days.
Remove an NE (prune_ne.sh)
Caution Before running the
script, shut down all
Cisco MGM clients
and the Cisco MGM
server. See the
“1.4.1 Starting and
Stopping the
Cisco MGM Server”
section on page 1-6.
active_alarm_table
additional_device_info
admin_job_table
alarm_count_table
alarm_event_table
aps_group_table
audit_log_table
circuit_dest_tbl
circuit_span_tbl
circuit_tbl
circuit_vcg_tbl
domain_table
eqpt_info_table
eqpt_relationship_table
if_cross_connect
if_dwdm_channel_group
if_optical_phy_config_table
interface_aps_info
interface_dwdm_frequency
interface_stack_table
managed_et_tab
map_cust_table
mib2_interface_table
ne_inventory_table
ne_port_status_table
ne_swimage_table
NE SYS ID Removes all information about the
NE from the database. Use this script
with extreme caution.
Table 5-6 Database Pruning (continued)
What to Prune
(Script Name) Tables Affected Input Parameters Remarks
Comments to this Manuals