Monitoring the key traffic tables for data availability
IBM recommends these guidelines for monitoring the key traffic tables for different technology packs for generating the data availability reports.
To select the appropriate tables to monitor for data availability,
follow these guidelines:
- Load the complete data.
- Locate the tables that have data that is loaded by using the SQL statements that are stated in Selecting tables for data availability for a vendor neutral technology pack and Selecting tables for data availability for a vendor specific technology pack.
- From the list of tables in the result set, select the tables that are common from entities by referencing the raw input files from network elements. Check the Product Requirements Specification and Functional Specification for a technology pack for blocks in raw files that are mapping to the abbreviated KPI group name.
- KPI group abbreviated names are the base for the table name without the vendor prefix.
Some example tables from selected technology packs:
| Network Object | Key KPI Groups | Loader Block | Raw Traffic Table |
|---|---|---|---|
| BSC | BSC.Huawei.GSM.Access_ traffic_volume |
B1275072018 | hua_bsc72018vol_tab |
| BSC | BSC.Huawei.GSM.Ps_capability | B1275073217 | hua_bsc73217_tab |
| M3UA | M3UA_Link.Huawei.GSM.M3UA_ link_utilisation |
B1275072118 | hua_m3ualink72118_tab |
| SCTP_Link | SCTP_Link.Huawei.GSM. Link_utilisation |
B67109468 | hua_sctplink09468_tab |
| SCTP_Link | SCTP_Link.Huawei.GSM. SCTP_IP_usage |
B67109469 | hua_sctplink09469_tab |
| SCTP_Link | SCTP_Link.Huawei.GSM. Utilisation |
B1275072217 | hua_sctplink72217_tab |
| Network Object | Key KPI Groups | Loader Block | Raw Traffic Table |
|---|---|---|---|
| BSC | BSC. Nokia.GSM.Quality_ of_Service |
P_NBSC_QOS | nok_bsc_qty_of_service_tab |
| Cell | Cell.Nokia.GSM.Traffic | P_NBSC_TRAFFIC | nok_cell_traffic_tab |
| Cell.Nokia.GSM.Resource_ Availability |
P_NBSC_RES_AVAIL | nok_cell_res_avail_tab | |
| Cell.Nokia.GSM.Packet_ Control_Unit |
P_NBSC_PACKET_ CONTROL_UNIT |
nok_cell_pkt_ctl_unit_tab | |
| Cell.Nokia.GSM.Handovers | P_NBSC_HO | nok_cell_handovers_tab | |
| DLCI | DLCI.Nokia.GSM. Frame_Relay |
P_NBSC_FRAME_ RELAY |
nok_dlci_frame_relay_tab |
| PCU | PCU.Nokia.GSM.PCU_ Utilization |
P_NBSC_PCU_ UTILIZATION |
nok_pcu_util_tab |
| Network Object | Key KPI Groups | Loader Block | Raw Traffic Table |
|---|---|---|---|
| BSC Performance Indicators | BSC.Motorola.GSM.Cell_ based_Busy_Hours |
bsc_all | mot_bsc_cell_based_bhs_tab |
| BSC.Motorola.GSM.SCCP_ Performance_and_utolization |
bsc_statistics | mot_bsc_sccp_prf_n_util_tab | |
| Cell performance indicators | Cell.Motorola.GSM.AMR_ TCH |
AMR_TCH | mot_cell_amr_tch_tab |
| Ethernet_link_mo performance indicators | Ethernet_link_mo.Motorola. GSM.Ethernet_link_statistics |
eth_statistics | mot_eth_link_stats_tab |
| Gb performance indicators | Gb.Motorola.GSM.GPRS_ Utilization |
gbl_statistics | mot_gblink_gprs_utils_tab |
| LAPD performance indicators | LAPD.Motorola.GSM.BSS_ data_transmission |
sdl_statistics | mot_LAPD_bss_dat_transm_tab |
| PCU performance indicators | PCU.Motorola.GSM.PCU_ overview |
pcu_statistics | mot_pcu_pcu_ov_tab |
| Processor performance indicators | Processor.Motorola.GSM. GPRS_Utilization |
pproc_statistics | mot_proc_gprs_utilizat_tab |
| Signalling_Link performance indicators | Signalling_Link.Motorola.GSM. MTP_C7_utilization |
mti_statistics | mot_siglnk_mtp_c7_util_tab |
| C25 performance indicators | X25.Motorola.GSM.BSS_data_ transmission |
cbl_statistics | mot_X25_bss_data_transm_tab |
Note: For KPI group Signalling_Link.Motorola.GSM.MTP_C7_utilization,
the summary is defined at Signalling_point level, instead of Signalling_Link
object. As the Signalling_point level is connected, there can be too
much detail at Signalling_Link level for data availability.
| Network Object | Key KPI Group | Loader Block | Raw Traffic Table |
|---|---|---|---|
| SGSN | SGSN.Huawei.GPRS.SGSN_LLC | M117440515 | hua_sgsn_lls_tab |
| Routing_Area | Routing_Area.Huawei.GPRS.Iu_ Mode_Attach_with_RAI |
M117440583 | hua_iu_mode_attach_rai_tab |
| M3UA_LinkSet | M3UA_LinkSet.Huawei.GPRS. M3UA_link_set |
M117440657 | hua_m3ua_link_set_tab |