No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade
MENU

FAQ-How to solve the problem of querying so slowly on client after large number of devices be added or splited in R008

Publication Date:  2012-07-24 Views:  8 Downloads:  0
Issue Description
Q:
FAQ-How to solve the problem of querying so slowly on client after so many  devices be added or splited in R008?
Alarm Information

Null

Handling Process
A:
After so many devices were added or splited in N2000BMS R008,sometimes open the ADSL、ServicePort windows or open the device panel will be so slowly .This is caused by the statistics ot sybase table ,so we need to update the sybase table statistics manually.
Enter isql:
#isql -Usa -PXXX -SN2000DBServer ---XXX is the password of sa.
Execute follow script:
use BMSDB
go
update all statistics ma5600v3_adsl_PortTab
go
update all statistics ma5600v3_pvc_CxcTab
go
update all statistics ma5600v3_pvc_VplVclTab
go
update all statistics ma5600v3_pvc_SrvFlowTab
go
update all statistics ma5600v3_gdm_ObjectTab
go 
About the table like adsl or pvc ,we can modify it according to the Device type,like ma5600tv8 ,ma5100v2 and so on.
Root Cause

Null

Suggestions

Null

END