SQL取数步骤级常用优化参数修改说明.docx

SQL日常LTE取数方法一、网管登陆：
远程地址：IP:10.197.148.195 用户名：administrator 密 码：nmsinstl
登陆界面如下：
C Q Q R
KDCIIVVOttV
.9)0004MUNUD
B BMcft* ,an^w^ UKH ■ ■
■ 9 #取指标工具：
Sql帐户名：rdr密码:rdr
站名设置:
Commissioning - SnapshotBTS Settings bts 设置

Pag* 2/8 O "
BTS g 11Yuan*
•
)Ji
Fltxl LIE BTS
Tim«$on« (JMT*8)AsiacSt)anQhai-
|mharet Local cells

Commissionirg Snapshot
Rad© Nefwock Connguratw无线网编KJK
15 O " W 〜
，• • v・・
Q5rm
cimwv uimrivMuv<M

・MRST“454)
• EiuMt UEwO rt^rKt
1|

L-：y
MIRPRL-)
11 tNB n>nw
Shunnx>M)Da»4uaYuafUt4LU

• UW»2U
End*Tag masmum AM
10

小区名称:
Commissioning - Snapshot
Radio Netwodc Conftgurabon
Pag* 14/18 O
Q SoOi
• MR8TS-W5O
・ LNBTS.Q4J43
“IRPRLQ
» LNAD>254
■ UUO255 |» WC
» LNMME4
♦ LNMME<
PURNL・‘

Q SoOi
• MR8TS-W5O
・ LNBTS.Q4J43
“IRPRLQ
» LNAD>254
■ UUO255 |» WC
» LNMME4
♦ LNMME<
PURNL・‘
eNb id设置:
COUA2GOO [iRTT 8(1 Q f
COUA2000〔iRTT C3FB t>X
3 barred 顿
CtflmdMdual ofb«to(gn smng ceils PC1
CH power reduce
Commissioning - Snapshot

Commissioning - Snapshot
Radio Network Configuration
14H8 O，w W•❸
・UeTS-94^3
24RPRL0
.UMU-2M
■ UUO35
• LNCSL-*
♦ LNUME-4

・UeTS-94^3
24RPRL0
.UMU-2M
■ UUO35
• LNCSL-*
♦ LNUME-4
Sortna W»3Mttcai •
MR8TS94M3 RoperWs
Mu*fX>0 W BTS 皿 SMHc
AcMt Mhe(n«t seamtr
AUo conftguraftcn Mooctd
94543P 1048575] tNSU
f・
Commissionhg snapshot

Commissionhg snapshot
Radio Network Conftguration
QSewi

QSewi
, MRSTS^4543

[■ LNBTS *M543
I
ANRPRtQ
■ LNAO>；54 , LNAD>：55 » iNca.- » LNMMC)

LNBTSM543 Propemes
Mxro idtnttfttr
AcMtoiiCSrB
S<xbng A>Phab^cal
ANR suppon focLTEw^hOAM ertension
94543
tNBid

Lcrld设置:
Commissioning Snapshot
Radio 比 twork ConAguration
P 小 14/18
■ MRSTS-94M
- U«TS M43
mta<tqu«ocy 5 r«st«aon atowta

AHRPRLO
f ♦putney rnosurtmtntj
42
i
• LNAO>»5
L* ttt» r>Mo<n Meets MCS m upank
Local ch rtsourc* C
g
IZ

• LNMME4
Mai ftumov actDRB
MO

PCI设置：

Commission Irg • SnapsixxRaa» wetwodt connguranoo
Pag W O * >
~• • v・・
Q
rrn^
AWX
■
・ MR8TS-94M)
■ LNBT$M3
Pthoac R1 rtpcnng ctsec
P»«CH durat>on
-1 Normal
.
N4RPRV)

» L>MO>2M
PHCH resource
N»1
.
» UUOJ-2!5
Phnicai i>/tf ch KMnttr
I “9

» LNMME9
■• •••••h «
Pmu mara^tqutocy nftghooang E-UTRA
23

BAND带宽及频点设置:
Commisskning Sn<>$ho(
LTE earners 栽波
P>9« 5/1*。■•广•,
LTfCMmr*
MA
Ftoxi LTE BTS
LOUl CM Frt^MACy

LOUl CM Frt^MACy
EARFCW Frt^ftcy (VHU
20 UH：

20 UH：
)W50 .
23400
230MM： (E-UTRA 40 FZND) P«M0 3W4»J
TM EARF CH «a*u« must MM aAsUftc* tom Z io*«c and*nts of z a*ow*4 ran^*
1171VCMAM7
J”2
fatrceelec fXtr^qwecy
Ov(mde fwnmi te^Macy
Commissionirg Snapshot
Radio Netwoct Connguratton
MR8TS-9454)
INBTS-H5I3
ANRPRL。
LH«O>2S4
UW»^5
Commissioning Snapshot
MR8T* 处
LXT$.^4M3 AMRPfU.0 LN*O>2»4
LNAD>2>6
C—
8 rtsourc* slunnQ modt
CMrequest p«no^ctfr
Channtl Mnd**dm TDD
CaniMM SRS OTXnum*
Radio Nefwom Connguraoon
E*UTRANoa«nM”
EARFCH for y OcwNmk 疏 Uptmic (TDOX
EruNe MCAM m davmink
EfUWtaMTBs^ULAAiC
EruM* AMC lor PDCCH link adapUttoa
p>0« i<dt
ItlVCMAMS
Pas 158 (J
20 MH：

PRACH参数设置:
Commissioning • Snapshot
Radio NetwocX Conftguraux)
P>oe 14/1 aO 〃
Q !<g
・ MRSTS-MM
・ LN6T9.HM3
AMRPRL0
. LNAO>2>4
PHCHrtMurc*
Ph03 Uyff CH tOKMr
Pmai inta**tqu«fKy migh&oang E-UTRA
Powtf offs« for SRS f mHsaon powvc cUcUMon
• LNMMEX
, LNMME1
PURNl-1 •CTF1
• AMRLCtO«^UUM« 1
• MIRLC2«E«3U2 » 4MRLC p«0)t*UMf3
Pawtf sttp
PRACH concurMtx
PRACH eyoesha
PRACH t»qu«ncy offset
PRACH rwghspwdnaQ

Commissioning - Snapshot 1 'F Radio Netwodc Conhguratxxip・a 158
Q c.ar6.。•
■MRBTS-^454：；
・ LteTS-M5<3
aiRPRLT
•U4*D>»
QRXFImmSsM(2<
O4hf.・24 fo<XO RAT>«^<
RiOptfWlotytxiOf■
RA m・”ax pg” olHtt for group 8 SfHOon10 06・

♦ UMME-0
» UAME1
RACH root1 (56
上行参考信号设置:
Commissioniig Sna(>$ho<
Radio Networt Configuration
Pa®t 14/18
UptnkcomM3bonmod«
UfAnk »mpcovt4 Mncy r«ad»on Hmtc
・ URSTS-MM)
・LN8T$^4!43
A/«PRL0
»UM»2$4
,UM»2$6
Uptnk •心 sign* cycftc sM
UM 0( My Mocittd PR0S
PUSCH信道设置:
Commissioning Snapshot
Radio Network Configuration
*♦158 O

. MR8TS^4M
・ LNeTS-H!43
Ffng co«Oa«<it used 由 RSRO
M
■
AftftFRLO • LFM»24
F«tnng OMflkS used 版 RSSt
IC2
.
» LNADJ-255
G8R congests h如 m
I2mi«
■
• UNMME4 » LNMME-
Group MliQnmtm foe PUSCH
2

PURML-
Higmpted sctnwio

.
TAC跟踪区设置:
CommissioniBg Sna(>shot
Radio Netwodc Conf^uration
Q ♦如
•MR8T$.»45O
. INRTM4U、

Q ♦如
•MR8T$.»45O
. INRTM4U、
WRPRLO » LNADJ-2M
• LNUME-4
••>« I.
• nnwTXK) nmtftotwt UE cowxr TRC commxMj w random access response Traaon^ ... codt
Transmiss^n Pg* OffsM 由 Downhnk Weffeftnct

RRU功率设置:
* >WT2*
f\IOKCommissioning
FW・1 7 1* *HT>
• "4'"6
t M，F29F*«1 tl
"2BTS Site Manager
33000000oooooooo
oooooooo”,

TXRX
.
*nX l» y“・ 1 ・《h MCC (1

TX»
•
w0)DMX<1

TXXX
•
eetCrwdtokXtlCHI w<hDM(1

X
.
4Mrw«tokx«icHi vChD^Xfl
•$潮
D9*tKutH*
TXRX
.AHMaMUIhWIHMM ^{y
MM)

TXRX

濒* t> toe.(•, i f mec(i
tSM)
IWWuiW
TXRX
,
wViDMd

TXRX
.
i» ix i f nm
W2V*))

常用切换参数解释.诺基亚全参数表.X1 docxs
上面两个文档有参数在BTS SITE MANAGER的对应位置，脚本COUNTER
批量参数修改使用介绍使用工具制作PLAN XML文件
示例批量修改异频测量起测与关闭门限：
1.打开工具
在参数文档上寻找参数:

tnresnoiazutKANacn
inresnoia tnz ukah ror t
threshold2Hrpd
Threshold Th2 CDMA2000-
eq
threshold2lnterFreq
Threshold th2 irterFreqJor

threshold2MobRsrq
|RSRQ mobility parameters
,na
threshold2Tdscdma
Threshold th2 TD-SCDMA
a
threshold2Wcdma
Threshold th2 V/CDMA for
aQcil
threshold2WcdmaQci 1
Threshold th2 V/CDMA for

threshold2a
Threshold th2a :or RSRP

threshold2aRsrq
RSRQ mobility parameters

threshold?
Threshold th3 fcr RSRP

A B C D
opiate叫 dv update
U0T$ IX1L UOOG
st niini
Thresholda关闭异频测量门限 threshold2lnterFreq 开始异频测量门限 对应网管上我们可以看到现网是-86-90

N£W0/DataFrom
Threshold th2 GERAN for RSRPThr”hold th2 GERAN for RSRP during OCI1
Threshold th2 interFreq for RSRPThreshold Th2 IntcrFreq for RSRP during QCI1
Threshold th2 TD-SCDMA for RSRPThreshold th2WCDMAfor RSRP
•105•100
-90•116
Threshold th2WCDMAfo< RSRP during QCI1Threshold th2a for RSRP
-86Threshold Th2a fo* RSRP During QCI1:
Threshold th3for RSRPomDwTo
Compare-100
Threshold th3a forRSRP

填写数据:

注意：
Ul value 就是 site manager ±的值Internal value就是我们写PLAN和SQL上提取出来的值
转换公式在附件中参数表里第0列如果改成-88 -92的话我们在工具上填写的值就是
KMIthreshold^UtKAN
=Ul value + 14U
RANQcil
threshold2GERANQci1
=Ul value + 140
d
threshold2Hrpd

•rFreq
threshold2lnterFreq[
=U j/alue + 1空
bRsq
threshold2MobRsrq
=(dT value + 20) * 2
cdma
threshold2Tdscdma
=Ul value + 140
dma
threshold2Wcdma
=Upvalue + 140
dmaQcil
threshold2WcdmaQci1
=Ul value^4-140
threshold2a匚
=Ul value + 140
；rq
threshold2aRsrq
=(Upvalue + 20)w 2

thresholds
=Ul value + 140

♦hrA^hnld?a
=i ii vainp + un
-88+140=52
-92+140=48
点保存q各
n
InOMHMMtSn
yvxheng....

n
yvxheng....
B
BaOwCom...
伟 PLAN 文 ■H 不・!》■■■

PM_TA2<U... cellMCC4...
B B
s DU.XM roots^nd.
»O*<
^mote.ex® • rd Shortcut依次进入OMC
login - Internet Explorer
BSD|
/ ■ ]ssi g*i0KC.com 3Jp
g、2jj Ne<A<t,M Login
x|_l
a ♦您
W Rdt Vtew Favorites loot beip

nsn

■NetActw
Vm«on15 5Log into
PasswordLogin name
OMCNokial23 I

btan rage^ugoaomc Qaoou
CMRuleEaeor OmBm CM AMy?er mm□r
Bit Elan Template Operation Upload Tools Help l< 8•mplates Op«rabon History Sch«dul«d Op«(at»ons
A3.3A
,入仲的PLAN名学flMtMH iutvup icu—— ]5■…[Chh .La$L [liod .〔Own Pr・.【Pep.；¥•， ]钏孙 G・n 【Pen ]g・・. Gv
>1... • O«... • No ♦ 2016... Not ... omc 2016... omc omc ・ Com.. 2016...
A3.3ANo ・ 2016 Not omc 2016 omc omc ・ Com 2016
NameTBS* 注
Descnption310
311翎一个白己皿I
Cancel

Eile View Elan Jemplate Operation Upload Tools Help
3X13\ Pkn« \ Templates | Operation History | Scheduled Operations [

Die Dew £lanK9 Import to Plan: test 111
Import file•i
Import formatParameters:
Valdate againstAudit:
RAML20▼ Profile file
O Ul values® Internal valuesActual Configuration
Clsabled ▼
Q Assign system templateIk Include site information
□ Regeate existing objects in create operation for coreO Eriontae real cells over external cells
□ Sk>p ensbng oblects In create operaion Use flbiect operaton defined in import fileO Enable policy plars
import Status
Imported file
点击开Ml导入Status
Action:
Managed obiects:
ErrorsWarnings
Audit findingsFullLog
ErrorsWarnings
interruptClose
倒，

Vbew Rian Template fiperatwn Upload Toofs Help 奇X e伊
isn
Ttmpf I QptriBonHttiory ] icfttduledOptniontl
F«»r ’tesM”~)ShowmM* >

函 OierationLess 4—! hame:
_ Description:q
Scope 叵'Entire plan
Plan Retails..
J LT= [ RACS I CM ]

▼ test 111 p PLMN-PLMN
O mrbts-65666
LIE Options
® Validate plan before pre-activation and BTS file generatioi
□ Provision only afler successful validation
✓ By-pass unreachable BTSs
Options
□ Save validation flies

Flan is not service affecting
ho other operations ongoingScheduling 匚I Schedule
-Not scheduled
Backup
5 Create backup plan
Name: test 111_bu_20160515_l 919_39
Operation
0 Prepare plan
叵 Provision
④ Activate
O Pre-activate
O Activate pre-activated plan
O Fall back RMC RNW
O Validate
O Generate BTS configuration lie

等PLAN 一直跑到出现FINSH字样且CLOSE按钮可点才算OK

批吊:闭站：Nemuadminnemuuser

hn Known Hosts6
Oracle lOg
SQL Plus
n
der yancf^ng....
B
LNCEL.xml
... Remote.exe -
Shortcut

图标:
输入帐户名密码后点击0K登录:
PL/SQL Developer
Starting Pf Version 7 J Oracle Logon

Reading p Reading k Logging oUsecnane 忡
Pa$$wc*d p7!
Database |丫COSSConnects
zl•llroundautomatJons

上次未保存的工作空间：cancel掉即可
Crash RecoveryPL/SQL Developef not terminated proper^. Recoveiy He$ detected
15 May 2016120222
15 May 2016 12 04:18
15 May 2016120211PL/SQL Devetopet 2@YCOSS - [SQL Window • JS.PLMN.HOUR J ddministrator
(263544]

打开SQL脚本:

提取示例:
■Open

，Yg ,
DATA (D:)・ YCsql，
▼ U3 | Search YCsql

Ogarize ▼New folder

三▼ E❷
■
Fdvortes
Name -
| Detemodfied
| Type±
■ Deskop
▲ New folder
5/10/2016 4:14 PM
Fie folder
B Downloads
__、j cd_confiQation$_NeCAct8.$ql
5/8/2016 6:38 PM
Miaosoa SQL S
..-Recent Places
土 X/m/n ] #A¥ cql
5/13/201610^1 PM
HaojoftSQLS
C Ubr dries
. hl
5/12/2016 9:22 PM
M心必l心
• Docunert$
—由 53 E FtMNKY.H|」
5/15/2016 10:06 AM
htaosoftSQIS
J Musk
Jj JS_KPI_PIMN_HOUR.«1I
**5/12/2016 4:10 PM
"rOMrft SQL S
■ PKtves
Jjhadj.sql
5/13/2016 4:36 PM
MKrowrft SQL 5
H Videos
uj fce_pard_ad)je<_NetArt8.$ql
12/16/2015 3:52 PM
f*cro$oft SQL S J

Jj ke_para_hardware.$q|
5/8/2016 2:19 PM
McrosoftSQlS
:号 YCDC1
& SYSTEM (C：)
£omc2.四|
5/10/2016 2:58 PM
HcrosoftSQIS
j DATA (D:)
_ i rrc&8erab_bne$.$ql
5/9/2016 10:38 AM
hkrosoft SQL S
—TEMP(T：)
Jj rru endnumbet .sql
1/21/2016 10:45 PM
HcrosoftSQLS

Jj RRUB8U.$ql
1/21/2016 10:45 PM
btoosoft SQL SrJ
*li Network▼
<1
J
±r

、

File name: |jS_KPLCELL.HOUR-$ql
|SQl senpt L.sqD
J
QpenCancel
Preset Edt Seraon Debug
Took Hkto Doament Reports v^ndow He<>
SOL | mHrLmFiFHh
LUtST
SIGN
LU”T
SXCN
LUE5T
SIGN
LUt3T
SXCN
LUE3T
SXCN
LUfST
SXCN
?n LCELLD.btSMBe like 'TC*' THtK *TC' ITKEN IXELLP.bonam like 'Tn* THIN 'T2, VKEN mtS.ID. LCCLAV. LMCZL.ID
ri! (LIMT. S XGM_Cg_3*U■一rrT.BO_S・LWST. 8 XGN_Cg_"TA・_ATT_ITT・ .Cg_EA>.iTT. _ cc*n：ea>[att Cg；EAB】TT CCKN^ISTABWATT cc«<n：ejl>[e CC*M~ISTA» ATTlk>_XLUE. ”G»l_CCMN_S3_E_Eli
诚・LU5. 8 9拓 g.&m_iTT.讪 ” Ut»rL_TOL),O,Xtn.U IKXJWDCSUHTLOIST.SXGW^Cam^rSTAl^COaFl/SUKLWST.SlGN RTfiuCST . ”CM.C8M_CSTA・. ATT.BO.XLU&T .药 ■一ATTjmttRS- ，K3 皿 st.sx4.cM_"荷.jnijdpRxa bKL 1OL) «100927> X* P>C srTw"s®ccrss PATXO
co, DEC8E (Srn(UPSB・ EFS^BEAPIR^SrnTP^ATTZHPTS) ,0.NULL, R0WP(5UJ!(LEPSB・ rPS^BEAUE^SETVPCOWPLETICWS)/ 3UH (LEPSB. EPS_BEAPER^SFroP^ATTTHPTS) • 100,2) ) AS C_IUB.SrrUP_SPCCJUTX。-
,ROON& (VtCC^t. SUM (LUIST. S XGN^COIN^tSTJLB^ATT^HO^S^LUtST. S lOI^Cam^BSTAB^ATT^MT* LUtST.SXGM-CC«W-trrO-ATT-l!o2r>*LuisT.SX«_CONH2r5TAB-ATT-a™tW^OI!ST-^X<a<Z<：a<N-rs7AB-ATT-ri,G> LVtST.SXCw[cg[KSTA«[ATT[lu5RK>*LUtST.Sx5M_<：oiiN.t3Ti・_JL?T_UL_TOL),0,LSu5i(M«§T."Giij：ciiM_"TlB. SUK( LOtST.S XGW^Cam^tSTlB^ATT^IIO^S^iarST. S XOM^CCMM^CSTlLB^ATT^IIT^LOtST . S XGW.CO®I_EJIB_£tT_Wx " <•*aaaa«OT*^ ■ • .W _.>■■・• • • •••(«•_■ ■« • •■••■一 . _■*

3 9

x % e
M *.

B v v g €
4 第
小！ 3Al •。-A♦，
lohKtt

Al •。-A♦，
lohKtt

■ J Rwrt<t*cts e
SQL | 031 SUMci |
SILICT LCKLAV.t*
«(ca>e when LCELIP , LCHRV.LHEK.L .DKCOOEfSUIKLUESl. LQKST.
LUIST LUCST LUIST LUEST
LUEDT
SIGN.
Slew SIGN SIGN SIGN 3X0M
CCMNJS CCKW^IS CCMN^15 ccwn^15 comets
CCMN~t3
,r»ECOOK(SUH<LEP5l.
soiiUFSB.m >m
,ROVWP(PICOC»I(SUI( LUtST.8XCN^CCKN^IS LUEST.SIGn[cCWN上 SURfLUrST.SXGN^CCN
srnjp^cowLtTxews) /
户3_质.*.
JT. 9 XGW_COHN_ESTABm ESTAB ATT HO "
RPE3
lW(LOCST.SXOIvCC» att omg・-

这里注意：天级别的指标提取时间的输入格式:
例如提取14日的指标输入格式为，起始日期：20160514结束日期:

结束日期:
20160515
这样脚本才能计算到14日0:00至15日0:00
计为14日天级别
M

J OMUfetot
n • u
B#. &
COPY之后粘贴到EXCEL里面就可以观看详细指标从而找出TOP小区。

脚本名称说明:

这是指标的表头模板，邮件附件里也有。
工作处理表.x】sx

BTS Site Manager 使用介绍
一、Site Manager基本参数修改
1.参数可以登录基站对单站单小区进行操作，也可以制作PLAN批量修改。
优化常用单站参数修改:
在BTS Commissioning的初始界面，设置了一个无线网络配置的快捷按钮，如下图。
Commissioning - Snapshot
introduction

Fl<xi LTEBTS
BTS Me
Local cm

TRS• r1 in
「J 172
r i8i
F 191
r 1 101 RF CHAIN 10RFCHAIN7
RFCHMN8RFCHAIN9

DtspUyi parant<t<s tom the commissioned BTSand its rou Vhe
System FSIN11
Q Tg*
D Eurmd
O 5*
每 Beconlguraton
[GotoRg<>ueiiwxkConll9ur»tion|： ~|无线网苗配X 快姓技tflBafkup Onmtsnomng Flits
邻区添加:

• X2方式（其临区id通常从255开始倒序设置）
• SI方式（其临区id通常从1开始顺序设置）Pnmat PLMH Beatty ofnttQK^r LTt ceflm ECGI
Feq plmn sty cf Lgreor m ch . EC3i|
j1t'<Commission^
R«jao Network ConftgjrationP>9« 14HI
NttghMw «HB MtnNMrU^o>1
Sotng Wfta^uiHOMCC P i o MNC。* ：MNCffl
•Ml色字体为MTI5方式
I Pr^w Pt MIJ e4»IJ8-1gUM»2
N*6«LTEcaasM«r Sig 区 4 电J■^号DL €»<•<
DOMM E/RFCN 0flT€c«fl MMd 8 fhXf *BDommi ranmttior
4 MtghMr M m ECQLoctf cairtMMCtOtfrMMffweghOorcM
PVMtuictiOofcefitfvvd^rMtghOoreNB23P 231
MWO <k(x MA » 姒g1藤■.Nt"
M2 CblXRO P 5031Tncmg vm Et ofoM 由 neaghoor «h8
UlaMOL rawm stcn
PIXH f 逖twl二 M 6«8 5 5 6 B y 二Mtyttto
ConmtssioningQ S4M(h
!MTStO4$7)ATiRMh. 0 LNAOJ-O LKACM-1 LNAD>2 LNMM-3 LNADJ-4 LN*O>5 LNAOJ-e LFUOJ-y lNAft>9 LNAD>9 LNA£X>10 LNACU-11 LNADJ-12 • •♦•♦* ♦•/

KM)cd OMrMw *wc«c QOt
AO>W tenders BMctttthf
AOate tmng >d«vx« Marram PM courten
AcWMt U^tan* s«i* Mn«n9
[{yo UE bw< A/IRtxire»Eutncy LW]: pkMto UC-bM«< M4R tx tf*»< ft^uerev LTE 1
AcW^t Ut-MMC "K «y VTfUH
AcM»U»M CCMP
AcXtv wMor mcfVc c«c tK« —MncemWi
ACMB VOCTC C*l UMfVtf
-MM ■
ACWSM HM8 «j00<Xt