TD维护操作文档

《TD维护操作文档》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、中国移动TD-SCDMACorba3.0接口维护及网管TD北向接口检查维护文档TD本地数据检查补采维护文档一、早上和临下班前做一次TD数据检查。1、底层入库检查在rawdb/rawoptr@UWNMS2查看前天至当天TD数据入库情况：正常情况下数据总数在3800左右。观察有无明显的缺数，或者数据量偏小的情况rawdb/rawoptr@UWNMS2selecttime,TD+hwsz1总数,datanggz2,hwr97,hwrsz1,hwrdg1,ztergz2,ztergz3,ztergz4,zter,

2、ericgz1,ztes,hwsz1from(selectcount(*)TD,start_timefromdal_objtype_tdwherestart_time>=trunc(sysdate-1)groupbystart_time)TD,(selectcount(*)datanggz2,start_timefromdal_objtype_tdwhereomc_id=3932andstart_time>=trunc(sysdate-1)groupbystart_time)datanggz2,(sele

3、ctcount(*)hwr97,start_timefromdal_objtype_tdwhereomc_id=3803andstart_time>=trunc(sysdate-1)groupbystart_time)hwr97,(selectcount(*)hwrsz1,start_timefromdal_objtype_tdwhereomc_id=3804andstart_time>=trunc(sysdate-1)groupbystart_time)hwrsz1,(selectcount(*)zte

4、rgz2,start_timefromdal_objtype_tdwhereomc_id=3704andstart_time>=trunc(sysdate-1)groupbystart_time)ztergz2,(selectcount(*)ztergz3,start_timefromdal_objtype_tdwhereomc_id=3705andstart_time>=trunc(sysdate-1)groupbystart_time)ztergz3,(selectcount(*)ztergz4,st

5、art_timefromdal_objtype_tdwhereomc_id=3706andstart_time>=trunc(sysdate-1)groupbystart_time)ztergz4,(selectcount(*)hwrdg1,start_timefromdal_objtype_tdwhereomc_id=3805andstart_time>=trunc(sysdate-1)groupbystart_time)hwrdg1,(selectcount(*)zter,start_timefrom

6、dal_objtype_tdwhereomc_id=3702andstart_time>=trunc(sysdate-1)groupbystart_time)zter,(selectcount(*)ericgz1,start_timefromdal_objtype_tdwhereomc_id=3103andstart_time>=trunc(sysdate-1)groupbystart_time)ericgz1,(selectcount(*)ztes,start_timefromdal_objtype_t

7、dwhereomc_id=3701andstart_time>=trunc(sysdate-1)groupbystart_time)ztes,(selectcount(*)hwsz1,start_timefromrawdb.dal_objtypewhereomc_id=3811andstart_time>=trunc(sysdate-1)groupbystart_time)hwsz1,(selectfirst_resulttimefromnpmdb.tcc_time_snap@uwnms2wherefir

8、st_result>=trunc(sysdate-1)andfirst_result