rsran125 - rnsap signalling
DESCRIPTION
Rsran125 - Rnsap SignallingTRANSCRIPT
Iur PerformancePeriod start time PLMN name RNC name HOT_ID MCC_ID
RNC_729a04.17.2013 PLMN RNC1 2 283 100.0004.17.2013 PLMN RNC1 2 30000000004.17.2013 PLMN RNC1 3 283 100.0004.17.2013 PLMN RNC1 3 30000000004.17.2013 PLMN RNC1 4 283 100.0004.17.2013 PLMN RNC1 4 30000000004.17.2013 PLMN RNC1 801 283 100.0004.17.2013 PLMN RNC1 801 30000000004.17.2013 PLMN RNC2Y 1 283 100.0004.17.2013 PLMN RNC2Y 1 30000000004.17.2013 PLMN RNC2Y 3 283 100.0004.17.2013 PLMN RNC2Y 801 283 100.0004.17.2013 PLMN RNC2Y 801 30000000004.17.2013 PLMN RNC3 1 283 100.0004.17.2013 PLMN RNC3 1 30000000004.17.2013 PLMN RNC3 2 283 100.0004.17.2013 PLMN RNC3 2 30000000004.17.2013 PLMN RNC3 2111 283 0.0004.17.2013 PLMN RNC3 2138 283 0.0004.17.2013 PLMN RNC3 3111 283 0.0004.17.2013 PLMN RNC3 3138 283 0.0004.17.2013 PLMN RNC3 4 283 100.0004.17.2013 PLMN RNC3 4 30000000004.17.2013 PLMN RNC4 1 283 100.0004.17.2013 PLMN RNC4 1 30000000004.17.2013 PLMN RNC4 3 283 100.0004.17.2013 PLMN RNC4 3 30000000004.17.2013 PLMN RNC5Y 1 283 100.0004.17.2013 PLMN RNC5Y 2 283 100.0004.17.2013 PLMN RNC5Y 2 300000000
Iur avail
Iur Performance SRNC inter-RNC
RNC_2301a RNC_2299a RNC_2300a RNC_2305RNC_2295a0.00 0 0 6 00.00 0 0 0 00.00 0 0 256 00.00 0 0 0 00.00 1 0 464 00.00 0 0 0 00.00 0 0 0 00.00 0 0 0 00.00 0 0 22 00.00 0 0 0 00.00 0 0 0 00.00 0 0 5 00.00 0 0 0 00.00 0 0 268 00.00 0 0 0 00.00 0 0 0 00.00 0 0 0 00.00 0 0 0 00.00 0 0 0 00.00 0 0 0 00.00 0 0 0 00.00 6 0 1,589 00.00 0 12 0 00.00 0 0 540 00.00 0 1 0 00.00 12 0 1,383 00.00 0 6 0 00.00 0 0 0 00.00 0 0 0 00.00 0 0 0 0
Iur non-working Sent error indic msg Rcvd error indic msg RL fail RL add fail
SRNC inter-RNC DRNC inter-RNC
RNC_2297a RNC_2307a RNC_2309a RNC_2306RNC_2296a RNC_2298a RNC_2308a0.00 0 0.00 33.00 0 0.00 0
0 0.00 0 00.00 0 0.00 287.00 0 0.00 0
0 0.00 0 00.00 0 0.00 567.00 0 0.00 0
0 0.00 0 00 0.00 0 00 0.00 0 0
0.00 0 0.00 7.00 0 0.00 00 0.00 0 00 0.00 0.00 0 0
0.00 0 0.00 0.00 0 00 0.00 0 0
0.00 0 0.00 272.00 0 0.00 00 0.00 0 00 0.00 0 00 0.00 0 00 0.00 0 00 0.00 0 00 0.00 0 00 0.00 0 0
-0.08 13 0.08 1,514.00 0 0.00 00 0.00 0 2
0.00 0 0.00 504.00 0 0.00 00 0.00 0 0
0.00 2 0.02 1,708.00 0 -0.08 00 0.00 0 130 0.00 0.00 0 00 0.00 5.00 0 0.00 00 0.00 0 0
FR RL add RL stp fail FR RL stp RL fail RL add fail FR RL add RL stp fail
DRNC inter-RNC
RNC_2310a
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
FR RL stp
Report Title RSRAN125 - RNSAP SignallingNOP Report Release Version RSRAN RU30 EP1/EP2 (OnTop) 5.5.2RS Report Release Version 5.5.2Report ID rsran_RU30/reports/RSRAN125.xmlReport Description RNSAP SignallingStart Time 04.17.2013 23:00:00End Time 04.18.2013 00:00:00Objects Level: PLMN; PLMN (1001)Object Aggregation Level PLMN/RNC/HOT/MCC1Time Aggregation Level dayThreshold noneSorting noneData Source pmwPoolAdvanced Filter none
KPI ID KPI Alias KPI Title KPI FormulIur avail Iur Availabi100*decode(Iur non-working Iur interfa l3iur2.iur_Sent error indic msg Sent Error l3iur2.sentRcvd error indic msg Received Erl3iur2.rec_RL fail RL Fail fo (l3iur2.faiRL add fail RL Add Fai(l3iur2.addFR RL add Failure ra 100 - 100*RL stp fail RL Setup F(l3iur2.setFR RL stp Failure ra 100 - 100*RL fail RL Fail fo (l3iur2.faiRL add fail RL Add Fai(l3iur2.addFR RL add Failure ra 100 - 100*RL stp fail RL Setup F(l3iur2.setFR RL stp Failure ra 100 - 100*
RNC_729aRNC_2301aRNC_2299aRNC_2300aRNC_2305aRNC_2295aRNC_2297aRNC_2307aRNC_2309aRNC_2306aRNC_2296aRNC_2298aRNC_2308aRNC_2310a
Unit[%][Seconds][#][#][#][#][%][#][%][%][#][%][#][%]
Cache handler com.nokia.oss.qengine.support.CacheAwareEngineEvaluation method tmp tables(1)Init duration 0.015Sql generation 0.0030Execution duration 0.197Load from cache noneCreate tmp Tables 0.183Drop tmp Tables 0.015Load data db 0.0010Load data and write to cache 0.018
Start Time End Time2013-04-18 19:13:49.704 2013-04-18 19:13:49.887
Note Sqlcreating tmp table: jf_L3IUR2_1856337214
select trunc( p.period_start_time, 'dd' ) period_start_time, rnc.co_gid rnc_gid, p.hot_id hot_id, p.mcc_id mcc_id, SUM(setup_req_sho_on_srnc ) setup_req_sho_on_srnc, SUM(setup_req_sho_on_drnc ) setup_req_sho_on_drnc, SUM(setup_succ_sho_srnc ) setup_succ_sho_srnc, SUM(setup_succ_sho_on_drnc ) setup_succ_sho_on_drnc, SUM(setup_fail_sho_srnc_due_rnl ) setup_fail_sho_srnc_due_rnl, SUM(setup_fail_sho_srnc_due_trl ) setup_fail_sho_srnc_due_trl, SUM(setup_fail_sho_srnc_due_prot ) setup_fail_sho_srnc_due_prot, SUM(setup_fail_sho_srnc_due_misc ) setup_fail_sho_srnc_due_misc, SUM(setup_fail_sho_drnc_due_rnl ) setup_fail_sho_drnc_due_rnl, SUM(setup_fail_sho_drnc_due_trl ) setup_fail_sho_drnc_due_trl, SUM(setup_fail_sho_drnc_due_prot ) setup_fail_sho_drnc_due_prot, SUM(setup_fail_sho_drnc_due_misc ) setup_fail_sho_drnc_due_misc, SUM(add_req_sho_srnc ) add_req_sho_srnc, SUM(add_req_sho_drnc ) add_req_sho_drnc, SUM(add_succ_sho_srnc ) add_succ_sho_srnc, SUM(add_succ_sho_drnc ) add_succ_sho_drnc, SUM(add_fail_sho_srnc_rnl ) add_fail_sho_srnc_rnl, SUM(add_fail_sho_srnc_trl ) add_fail_sho_srnc_trl, SUM(add_fail_sho_srnc_prot ) add_fail_sho_srnc_prot, SUM(add_fail_sho_srnc_misc ) add_fail_sho_srnc_misc, SUM(add_fail_sho_drnc_rnl ) add_fail_sho_drnc_rnl, SUM(add_fail_sho_drnc_trl ) add_fail_sho_drnc_trl, SUM(add_fail_sho_drnc_prot ) add_fail_sho_drnc_prot, SUM(add_fail_sho_drnc_misc ) add_fail_sho_drnc_misc, SUM(fail_rl_add_srnc_rl_syn_fail ) fail_rl_add_srnc_rl_syn_fail, SUM(fail_rl_add_srnc_rnl ) fail_rl_add_srnc_rnl, SUM(fail_rl_add_srnc_trl ) fail_rl_add_srnc_trl, SUM(fail_rl_add_srnc_prot ) fail_rl_add_srnc_prot, SUM(fail_rl_add_srnc_misc ) fail_rl_add_srnc_misc, SUM(fail_rl_add_drnc_rl_syn_fail ) fail_rl_add_drnc_rl_syn_fail, SUM(fail_rl_add_drnc_rnl ) fail_rl_add_drnc_rnl, SUM(fail_rl_add_drnc_trl ) fail_rl_add_drnc_trl, SUM(fail_rl_add_drnc_prot ) fail_rl_add_drnc_prot,
2013-04-18 19:13:49.890 2013-04-18 19:13:49.901
SUM(fail_rl_add_drnc_misc ) fail_rl_add_drnc_misc, SUM(sent_error_ind_iur ) sent_error_ind_iur, SUM(rec_error_ind_iur ) rec_error_ind_iur, SUM(IUR_AVAILABILITY) IUR_AVAILABILITY, SUM(IUR_AVAILABILITY_DENOM) IUR_AVAILABILITY_DENOM, SUM(IUR_NOT_WORKING_DURATION) IUR_NOT_WORKING_DURATION from utp_common_objects plmn, utp_common_objects rnc, nokrww_ps_l3iur2_mnc11_raw p where plmn.co_gid in ( '1001' ) and period_start_time >= to_date('2013/04/17 23:00:00', 'yyyy/mm/dd hh24:mi:ss') and period_start_time < to_date('2013/04/18 00:00:00', 'yyyy/mm/dd hh24:mi:ss') and rnc.co_gid = p.rnc_id and rnc.co_parent_gid = plmn.co_gid and plmn.co_oc_id=16 and rnc.co_oc_id=811 group by trunc( p.period_start_time, 'dd' ), rnc.co_gid, p.hot_id, p.mcc_id
report from tmp tablesselect L3IUR2.period_start_time period_start_time, nvl(plmn.co_name, 'NN('||plmn.co_gid||')') "PLMN name", nvl(rnc.co_name, 'NN('||rnc.co_gid||')') "RNC name", L3IUR2.rnc_gid, L3IUR2.hot_id, L3IUR2.mcc_id, to_number(100*decode(l3iur2.iur_availability_denom,0,null, l3iur2.iur_availability / l3iur2.iur_availability_denom)) "RNC_729a",to_number(l3iur2.iur_not_working_duration) "RNC_2301a", to_number(l3iur2.sent_error_ind_iur) "RNC_2299a", to_number(l3iur2.rec_error_ind_iur) "RNC_2300a", to_number((l3iur2.fail_rl_add_srnc_rl_syn_fail + l3iur2.fail_rl_add_srnc_rnl + l3iur2.fail_rl_add_srnc_trl + l3iur2.fail_rl_add_srnc_prot + l3iur2.fail_rl_add_srnc_misc)) "RNC_2305a", to_number((l3iur2.add_fail_sho_srnc_rnl + l3iur2.add_fail_sho_srnc_trl + l3iur2.add_fail_sho_srnc_prot + l3iur2.add_fail_sho_srnc_misc)) "RNC_2295a", to_number(100 - 100*decode( l3iur2.add_req_sho_srnc,0,null, l3iur2.add_succ_sho_srnc / l3iur2.add_req_sho_srnc)) "RNC_2297a", to_number((l3iur2.setup_fail_sho_srnc_due_rnl + l3iur2.setup_fail_sho_srnc_due_trl + l3iur2.setup_fail_sho_srnc_due_prot + l3iur2.setup_fail_sho_srnc_due_misc)) "RNC_2307a", to_number(100 - 100*decode( l3iur2.setup_req_sho_on_srnc,0,null, l3iur2.setup_succ_sho_srnc / l3iur2.setup_req_sho_on_srnc)) "RNC_2309a", to_number((l3iur2.fail_rl_add_drnc_rl_syn_fail + l3iur2.fail_rl_add_drnc_rnl + l3iur2.fail_rl_add_drnc_trl + l3iur2.fail_rl_add_drnc_prot + l3iur2.fail_rl_add_drnc_misc)) "RNC_2306a", to_number((l3iur2.add_fail_sho_drnc_rnl + l3iur2.add_fail_sho_drnc_trl + l3iur2.add_fail_sho_drnc_prot + l3iur2.add_fail_sho_drnc_misc)) "RNC_2296a", to_number(100 - 100*decode( l3iur2.add_req_sho_drnc,0,null, l3iur2.add_succ_sho_drnc / l3iur2.add_req_sho_drnc)) "RNC_2298a", to_number((l3iur2.setup_fail_sho_drnc_due_rnl + l3iur2.setup_fail_sho_drnc_due_trl + l3iur2.setup_fail_sho_drnc_due_prot + l3iur2.setup_fail_sho_drnc_due_misc)) "RNC_2308a", to_number(100 - 100*decode( l3iur2.setup_req_sho_on_drnc,0,null, l3iur2.setup_succ_sho_on_drnc / l3iur2.setup_req_sho_on_drnc)) "RNC_2310a" from utp_common_objects plmn, utp_common_objects rnc , jf_L3IUR2_1856337214 L3IUR2 where rnc.co_parent_gid = plmn.co_gid and
to_number(100*decode(l3iur2.iur_availability_denom,0,null, l3iur2.iur_availability / l3iur2.iur_availability_denom)) "RNC_729a",
to_number((l3iur2.fail_rl_add_srnc_rl_syn_fail + l3iur2.fail_rl_add_srnc_rnl + l3iur2.fail_rl_add_srnc_trl + l3iur2.fail_rl_add_srnc_prot + l3iur2.fail_rl_add_srnc_misc)) "RNC_2305a", to_number((l3iur2.add_fail_sho_srnc_rnl + l3iur2.add_fail_sho_srnc_trl + l3iur2.add_fail_sho_srnc_prot + l3iur2.add_fail_sho_srnc_misc)) "RNC_2295a", to_number(100 - 100*decode( l3iur2.add_req_sho_srnc,0,null, l3iur2.add_succ_sho_srnc / l3iur2.add_req_sho_srnc)) "RNC_2297a", to_number((l3iur2.setup_fail_sho_srnc_due_rnl + l3iur2.setup_fail_sho_srnc_due_trl + l3iur2.setup_fail_sho_srnc_due_prot + l3iur2.setup_fail_sho_srnc_due_misc)) "RNC_2307a", to_number(100 - 100*decode( l3iur2.setup_req_sho_on_srnc,0,null, l3iur2.setup_succ_sho_srnc / l3iur2.setup_req_sho_on_srnc)) "RNC_2309a", to_number((l3iur2.fail_rl_add_drnc_rl_syn_fail + l3iur2.fail_rl_add_drnc_rnl + l3iur2.fail_rl_add_drnc_trl + l3iur2.fail_rl_add_drnc_prot + l3iur2.fail_rl_add_drnc_misc)) "RNC_2306a", to_number((l3iur2.add_fail_sho_drnc_rnl + l3iur2.add_fail_sho_drnc_trl + l3iur2.add_fail_sho_drnc_prot + l3iur2.add_fail_sho_drnc_misc)) "RNC_2296a", to_number(100 - 100*decode( l3iur2.add_req_sho_drnc,0,null, l3iur2.add_succ_sho_drnc / l3iur2.add_req_sho_drnc)) "RNC_2298a", to_number((l3iur2.setup_fail_sho_drnc_due_rnl + l3iur2.setup_fail_sho_drnc_due_trl + l3iur2.setup_fail_sho_drnc_due_prot + l3iur2.setup_fail_sho_drnc_due_misc)) "RNC_2308a", to_number(100 - 100*decode( l3iur2.setup_req_sho_on_drnc,0,null, l3iur2.setup_succ_sho_on_drnc / l3iur2.setup_req_sho_on_drnc)) "RNC_2310a"
L3IUR2.rnc_gid = rnc.co_gid order by 2,1,3,4,5,6