移动短消息网管接口说明分析.doc

技 术 文 件 技术文件名称：中国移动短消息网管接口说明 技术文件编号： 版 本：V1.0 文件质量等级：共 13 页(包括封面) 拟 制 审 核 会 签 标准化 批 准 深圳市中兴通讯股份有限公司中国移动短消息网管接口说明ZXG10 SMSC部分的DB网管中间库为zx_smsc_omc_db 。table zm_omc_config is only used by omc, not for NM.zm_omc_configColumn nameDescriptionTypeNullsint_idZm__idintegernoAreaArea, post, module according to zte omc db, it is used to get the int_idsmallintnoPostArea, post, module according to zte omc db, it is used to get the int_id.tinyintnomoduleArea, post, module according to zte omc db, it is used to get the int_id.tinyintnoomc_idDefine the omc identityingeteromc_nameDefine the omc namechar(127)omc_IPDefine the omc ip addressvarchar(15)object_classSmsc 101smallintnoObject_version版本号char(25)zm_objectsColumn nameDescriptionTypeNullsint_idDefine the neintegernoTime_stampLast update timeTdatetimeobject_classZm_omc_config 0Smsc 101smallintnolocationnameAccording to table zm_omcconfigOmc_namevarchar (127)adminstateDefault 1: unlockedsmallintFM tablezm_alarmColumn nameDescriptionaccording omc columnTypeNullsAlarm_idThe alarm_id is the unique number assigned to each row. Primary key, not null.alarm.Alarm_idintegernoInt_idrefers to zm__id tableintegernoEvent_typeEvent type defines the type of alarm in question.0: Communication Alarm; 1: Processing Alarm;2:Quality of Service Alarm;3: Equipment Alarm;4: Environment Alarmselect title.Evtype from title where title.Titletype=alarm.CodetinyintyesProbable_causeProbable_cause is an alarm reference number. For example, when you refer to the alarm manual, you will use probable_cause as refer ence. alarm.CodeintegeryesEvent_timeThe time that the alarm event was generatedalarm.StartTimeTdatetimeyesActive_status The status of the alarm.0: cancelled1: active2: acknowledged (Ericsson only)alarm.StatussmallintyesCancel_time The time that the alarm event is cancelled.alarm.EndTimeTdatetimeyesPerceived_severityPerceived _Severity is the alarm severity clas sification.1: Critical2: Major3: Minor4: Warning8:inform alarm.StatesmallintyesAlarm_textThe text provides more information about the alarm in the textual form .select title.Contentwhere title.TitleType=alarm.Codechar(80)yes CM tablezm_cm_SignalPointColumn namecolumn descriptionvalue typeaccording OMC COLUMNInt_id短消息中心号integerzm__idTime_Stamp采集时间点TdateTimecurrent timeSignalPointId标识短信中心中的一个信令点tinyintzdb_zxj10.r_opc.(opc14m+opc14s +opc14p)SignalPointCode短信中心中的信令点的24位国内信令点编码tinyintzdb_zxj10.r_opc.(Opc24m+opc24s +opc24p)zm_cm_SignalLinkSetColumn namecolumn descriptionvalue typeaccording OMC COLUMNInt_id短消息中心号integerzm__idTime_Stamp采集时间点TdateTimecurrent timeSignalLinkSetId短信中心中的一个信令链路群intr_n7linkset.linksetSignalLinkSetName短信中心中的一个信令链路群名称varchar(40)r_n7linkset.desnamenbrSignalLinks短信中心中的一个信令链路群包含信令链路的数目tinyintr_n7linkset.linknumadjacentSPCode短信中心中的一个信令链路群对端信令点编码tinyint由r_n7linkset中得出officeid,在r_office中得到信令点编码dpcm+dpcs+dpcpPM tablezm_pm_CpuMeasureColumn namecolumn descriptionvalue typeaccording OMC COLUMNRecord_ id主键，唯一标识一条记录integerrecord_idInt_id短消息中心号integerzm__idv_scan_start_time 测量起始时间点TdateTimemop_MscCPUdata.sdatev_scan_stop_time 测量终止时间点TdateTimemop_MscCPUdata.sdate+5minutescpuLoad短信中心中心平均CPU利用率，即一定采集周期内cpu资源占用率平均值integermop_MscCPUdata.nMscCPURatio(取业务处理机各模块均值)MaxCpuLoad短消息中心CPU利用率峰值，即一定采集周期内cpu资源占用率最大值integermop_MscCPUdata.nMscCPURatio(取业务处理机各模块最大值)zm_pm_MOMTmsgFlowColumn namecolumn descriptionvalue typeaccording OMC COLUMNRecord_ id主键，唯一标识一条记录integerrecord_idInt_id短消息中心号integerzm__idv_scan_start_time 测量起始时间点TdateTimemop_ScMSdata.sdatev_scan_stop_time 测量终止时间点TdateTimemop_ScMSdata.sdate+5minutesMsgMOMS向短信中心提交（MO）的短消息条数integernScMS01+nScMS02+nScMS03+nScMS04+nScMS05（选所有地区）SuccProcMsgMO短消息成功处理的短消息条数(MO)integernScMS01+nScMS03（选所有地区）UnsuccMsgMO短消息中心提交短消息失败的条数(MO)integernScMS02+nScMS04+nScMS05（选所有地区）AttMsgMT短消息中心尝试下发至移动台的短消息条数(MT)integernScMS06+nScMS07+nScMS08+nScMS09+nScMS10+nScMS11+nScMS12+nScMS13+nScMS14+nScMS15（选所有地区）SuccMsgMT短消息中心成功下发至移动台的短消息条数(MT)integernScMS06+nScMS08+nScMS09+nScMS11+nScMS13+nScMS14（选所有地区）OnceSuccMsgMT短消息中心一次下发成功的短消息条数(MT)integernScMS06+nScMS11（选所有地区）UnsuccMsgMT短消息中心下发至移动台失败的短消息条数integernScMS07+nScMS10+nScMS12+nScMS15（选所有地区）MsMsgMO向短信中心提交的点对点短信条数integermop_ScMSdataX表中通过若干项求和获得nScMS01+ nScMS02OnceMsgMT短信中心下发的短信条数（不含重发）integermop_ScMSdataX表中获得nScMS06+ nScMS07+ nScMS11+ nScMS12MsSuccMsgMT短信中心下发成功的点对点短信条数integermop_ScMSdataX表中获得nScMS06+ nScMS08+ nScMS09zm_pm_ESMEmsgFlowColumn namecolumn descriptionvalue typeaccording OMC COLUMNRecord_ id主键，唯一标识一条记录integerrecord_idInt_id短消息中心号integerzm__idv_scan_start_time 测量起始时间点TdateTimemop_ScSMEdata.sdatev_scan_stop_time 测量终止时间点TdateTimemop_ScSMEdata.sdate+5minutesEsmeToSmscESME向短消息中心提交的短消息条数(AO)integermop_ScSMEdata.(nScSME01+nScSME02+nScSME03+nScSME04)EsmeToSmscSucc短消息中心成功处理的ESME提交的短消息条数(AO)integermop_ScSMEdata.(nScSME01+nScSME03)EsmeToSmscUnsuccESME提交失败的短消息条数(AO)integermop_ScSMEdata.(nScSME02+nScSME04)SmscToEsme短消息中心转发到ESME的短消息条数integermop_ScSMEdata.(nScSME05+nScSME06)SmscToEsmeSucc短消息中心转发短消息到ESME成功的总条数integermop_ScSMEdata.nScSME05SmscToEsmeUnsucc短消息中心转发短消息到ESME失败的总条数integermop_ScSMEdata.nScSME06zm_pm_UnsuccMTColumn namecolumn descriptionvalue typeaccording OMC COLUMNRecord_ id主键，唯一标识一条记录integerrecord_idInt_id短消息中心号integerzm__idv_scan_start_time 测量起始时间点TdateTimemop_ScMtFaildata.sdatev_scan_stop_time 测量终止时间点TdateTimemop_ScMtFaildata.sdate+5minutesUnknownSubscriber由于被叫为未知用户而发送失败次数，错误指令：unknown subscriber + 由于被叫用户没有在HLR中登记而使发送失败的次数, 错误指示：deregistered in the HLRintegermop_ScMtFaildata.nScMtFail01ServiceUnsupport由于被叫用户手机没有开通短消息业务而导致发送的失败次数, 错误指示：Teleservice not provisionedintegermop_ScMtFaildata.nScMtFail02CallBarred由于被叫用户被呼叫禁止而导致的发送失败次数, 错误指示：Call barredintegermop_ScMtFaildata.nScMtFail04FacilityUnsupport网络不支持导致的发送失败次数, 错误指示：Facility not supportedintegermop_ScMtFaildata.nScMtFail03NoPagingRes由于被叫用户呼叫无应答而使发送失败次数, 错误指示：no paging response via the MSC, SGSN or bothintegermop_ScMtFaildata.nScMtFail14MsDetached由于被叫用户被标记为关机而使发送失败的次数, 错误指示：the IMSI GPRS or both records are marked detached + 由于被叫用户关机而使发送失败的次数, 错误指示：IMSI or GPRS detachintegermop_ScMtFaildata.nScMtFail15RoamRestriction由于被叫MS呼叫限制而使发送失败的次数, 错误指示：the MS is subject to roaming restrictionsintegermop_ScMtFaildata.(nScMtFail05+nScMtFail16)UnidentifiedMs由于被叫用户为未标识而使发送失败的次数, 错误指示：Unidentified subscriberintegermop_ScMtFaildata.nScMtFail17MsPurged由于被叫MS被清除而使发送失败的次数, 错误指示：MS purgedintegermop_ScMtFaildata.nScMtFail18UserBusy一个短消息中心正在下发短消息而导致被叫MS忙使发送失败的次数, 错误指示：short message delivery from another SC + 由于被叫用户正在进行位置更新或路由更新而导致MS忙使发送失败的次数, 错误指示：Location Update or Inter SGSN Routing Area Update + 由于被叫用户正在被寻呼而导致MS忙使发送失败的次数, 错误指示：paging + 由于被叫用户正在进行紧急呼叫而导致MS忙使发送失败的次数, 错误指示：emergency call + 由于被叫用户处于呼叫建立过程而导致MS忙使发送失败的次数, 错误指示：call setupintegermop_ScMtFaildata.nScMtFail19LowLayerUnsupport由于被叫MS不支持短消息而导致的发送失败次数, 错误指示：SMS lower layers capabilities not provisionedintegermop_ScMtFaildata.nScMtFail10MsError由于MS接收短消息出现错误而导致的发送失败次数, 错误指示：Error in MSintegermop_ScMtFaildata.nScMtFail09IllegalSubscriber由于被叫用户非法而发送失败的次数, 错误指示：Illegal Subscriberintegermop_ScMtFaildata.nScMtFail11IllegalEquipment不合法的用户设备导致的发送失败次数, 错误指示：Illegal Equipmentintegermop_ScMtFaildata.nScMtFail12MemExceed由于用户手机内存溢出而发送失败次数, 错误指示：Memory Capacity Exceededintegermop_ScMtFaildata.nScMtFail08SystemFailure除以上失败原因之外的由于网络原因导致的失败次数, 错误指示：System failureintegermop_ScMtFaildata.nScMtFail06UserReason由于用户原因导致下发失败的短信条数（含重发）Integer终呼失败测量数据的1+2+4+5+8+9+10+11+12+14+15+16+17+18+19项的总和NetReason由于网络原因导致下发失败的短信条数integer终呼失败测量数据的3+6+7+13项的总和zm_pm_unsuccMOColumn namecolumn descriptionvalue typeaccording OMC COLUMNRecord_ id主键，唯一标识一条记录integerrecord_idInt_id短消息中心号integerzm__idv_scan_start_time 测量起始时间点TdateTimemop_ScMoFaildata.sdatev_scan_stop_time 测量终止时间点TdateTimemop_ScMoFaildata.sdate+5minutesUnsuccMOForUserReason由于用户原因导致的失败次数integermop_ScMoFaildata.(nScMoFail01+nScMoFail02+nScMoFail03+nScMoFail04)UnsuccMOForNetReason 由于网络原因导致的失败次数integermop_ScMoFaildata.(nScMoFail05+nScMoFail06+nScMoFail07+nScMoFail08+nScMoFail09+nScMoFail11+nScMoFail12)zm_pm_SmsSlColumn namecolumn descriptionvalue typeaccording OMC COLUMNRecord_ id主键，唯一标识一条记录integerrecord_idInt_id短消息中心号integerzm__idv_scan_start_time 测量起始时间点TdateTimemop_MscNO7linkdata.sdatev_scan_stop_time 测量终止时间点TdateTimemop_MscNO7linkdata.sdate+5minutesSignalingLinkLoad忙时链路负荷，即单位时间内传送字节数/信令链路宽带Floatmop_MscNO7linkdata.nMscLnkOcpperc（取各链路最大的负荷值）/10000SmsSlLoad信令链路总话务量，即在一个性能采集周期内一组信令链路的平均负荷（Erland表示）floatmop_MscNO7linkdata.nMscLnkOcpperc（取各链路的平均负荷值）/10000zm_pm_OtherDataColumn namecolumn descriptionvalue typeaccording OMC COLUMNRecord_ id主键，唯一标识一条记录integerrecord_idInt_id短消息中心号integerzm__idv_scan_start_time 测量起始时间点TdateTimemop_ScIntegdata.sdatev_scan_stop_time 测量终止时间点TdateTimemop_ScIntegdata.sdate+5minutesStorePeriod 未能下发的短消息在短消息中心储存的时间，取值单位为小时integermop_ScIntegdata.nScInteg21（取未能下发的短消息在短消息中心储存的平均时间，取值单位为秒）NbrMsgStored短消息中心短消息积压（等待发送）的条数。包括由于各种原因引起重发的短消息。可以在忙时内任选时间取值一次integermop_ScIntegdata.nScInteg15AlertScRvdSmsc 短消息中心收到的ALERT_SC总数，即当用户出现在服务区或在内存已满的情况下删除短消息引起HLR向SMSC发送ALERT_SC信令的次数integermop_ScIntegdata.nScInteg18succstorePeriod首次发送成功的短信平均延迟时间Integermop_ScIntegdata表中获取avg(nScInteg20)AvgMsgLen平均短消息长度integermop_ScIntegdata表中获取avg(nScInteg24)zm_pm_ppsColumn namecolumn descriptionvalue typeaccording OMC COLUMNRecord_ id主键，唯一标识一条记录integerrecord_idInt_id短消息中心号integerzm__idv_scan_start_time 测量起始时间点TdateTimemop_Scspecialdata.sdatev_scan_stop_time 测量终止时间点TdateTimemop_Sspecialdata.sdate+5minutesppsmoPPS手机向短信中心提交的短信条数(MOInt特殊业务测量数据中取PPS手机提交的短消息的总次数(MO)ppssuccmt短信中心向PPS手机下发成功的短信条数(MT)Int特殊业务测量数据中取PPS手机发起的短消息下发成功次数（MT）BrodMo广播业务提交条数（AO）Int特殊业务测量数据中取全用户广播下发成功短信条数+全用户广播下发失败短信条数BrodSuccMt广播业务发送成功条数（MT）Int特殊业务测量数据中取取全用户广播下发成功短信条数Zm_pm_esmeColumn namecolumn descriptionvalue typeaccording OMC COLUMNRecord_ id主键，唯一标识一条记录integerrecord_idInt_id短消息中心号integerzm__idv_scan_start_time 测量起始时间点TdateTimem