Hello everyone!
Today, I'd like to share a case.
Problem Description
Synchronization is not happening in U2000 for newly integrated sites, that after Site integration technology mode like (G / U / L) is not reflecting.
Problem Analysis
We need clean the bigger x2 table to improve the efficiency for data insert to DB.
Note:
During execution of the data deletion tool, all the CmDcService services must be stopped. The service interruption duration is subject to the volume of historical data in the data table. Typically, it takes about 30 minutes to execute this tool. During service interruption, the U2000 cannot synchronize NE configuration data, cannot issue MML commands, and delays reporting NE disconnection alarms. After the CmDcService services are started, the U2000 reports manually cleared NE disconnection alarms again.
Step 1 Log in to the following website: http://support.huawei.com/carrier/navi?coltype=software#col=software&detailId=PBI1-23015264&path=PBI1-7851894/PBI1-7854702/PBI1-7275896/PBI1-21103986/PBI1-4141950. On the website site, find and download the latest tool package M2000Toolkit-ENG(Smart_Assistant_Series).rar.
Step 2 Decompress the tool package M2000Toolkit-ENG(Smart_Assistant_Series).rar. Deploy the data deletion tool by following the instructions provided in section "Operation Instructions 2.1Preparations" of Guide to Clearing Invalid Historical Data from Table A on the M2000 or U2000 in the M2000Toolkit-ENG(Smart_Assistant_Series)> Configuration > Tool for Clearing Invalid Historical Data of Table A directory.
Step 3 Use ossuser to login to the U2000 master server. Perform the following operations to filter and delete invalid data automatically and quickly from table A with up to 8,000,000 data records:
1. Run the following commands to stop all the CmDcService services:
$ . /opt/oss/server/svc_profile.sh
$ eval `svc_deploy -cmd querysvc | grep CmDcService | awk '{print "svc_adm -cmd stopsvc " $2 ";"}'`
2. Run the following command to delete invalid data from table A:
$ ./RetreadMoiTool.sh -quickAll
3. After deleting invalid data, run the following command to restart all the CmDcService services:
$ eval `svc_deploy -cmd querysvc | grep CmDcService | awk '{print "svc_adm -cmd startsvc " $2 ";"}'`
----End
Root Cause
Many synchs for X2 MOCs, which related the configuration of “GLOBALPROCSWITCH”, if the period is too short, will trigger frequent synch from NEs,
It caused have some bigger table, impact efficiency for data insert to DB.
So there have too many synchs wait in the task queue, the synch for new NE also wait a long time in the queue.
We find some table related to x2 MOCs are very bigger
Solution Description
We need clean the bigger x2 table to improve the efficiency for data insert to DB.
Note:
During execution of the data deletion tool, all the CmDcService services must be stopped. The service interruption duration is subject to the volume of historical data in the data table. Typically, it takes about 30 minutes to execute this tool. During service interruption, the U2000 cannot synchronize NE configuration data, cannot issue MML commands, and delays reporting NE disconnection alarms. After the CmDcService services are started, the U2000 reports manually cleared NE disconnection alarms again.
Step 1 Log in to the following website: http://support.huawei.com/carrier/navi?coltype=software#col=software&detailId=PBI1-23015264&path=PBI1-7851894/PBI1-7854702/PBI1-7275896/PBI1-21103986/PBI1-4141950. On the website site, find and download the latest tool package M2000Toolkit-ENG(Smart_Assistant_Series).rar.
Step 2 Decompress the tool package M2000Toolkit-ENG(Smart_Assistant_Series).rar. Deploy the data deletion tool by following the instructions provided in section "Operation Instructions 2.1Preparations" of Guide to Clearing Invalid Historical Data from Table A on the M2000 or U2000 in the M2000Toolkit-ENG(Smart_Assistant_Series)> Configuration > Tool for Clearing Invalid Historical Data of Table A directory.
Step 3 Use ossuser to login to the U2000 master server. Perform the following operations to filter and delete invalid data automatically and quickly from table A with up to 8,000,000 data records:
1. Run the following commands to stop all the CmDcService services:
$ . /opt/oss/server/svc_profile.sh
$ eval `svc_deploy -cmd querysvc | grep CmDcService | awk '{print "svc_adm -cmd stopsvc " $2 ";"}'`
2. Run the following command to delete invalid data from table A:
$ ./RetreadMoiTool.sh -quickAll
3. After deleting invalid data, run the following command to restart all the CmDcService services:
$ eval `svc_deploy -cmd querysvc | grep CmDcService | awk '{print "svc_adm -cmd startsvc " $2 ";"}'`
----End
Welcome to leave a message below.
We’ll study together.
Thank you!
