How to clear the database for M2000

How to clear the database for M2000, version 12.

1) deselect the subscribed NE to cancel the subscription 

2) Stop all the services

. /opt/oss/server/svc_profile.sh
stop_svc

3/ clear the historical data of power-saving info, if customer doesn’t agree to delete, please skip this step.

$ . /opt/oss/server/svc_profile.sh

$ isql -SDBSVR1 -Usa –Pxxxxxx       //change xxxxxx to real password

1> use omcdb

2> go

1> truncate table tbl_selected_ne

2> go

1> truncate table tbl_power_fdn_id

2> go

1> truncate table tbl_power_consume_hour

2> go

1> quit

4/ Clear the data from the table, which will not impact on the live M2000.

$ . /opt/oss/server/svc_profile.sh

$ isql -SDBSVR1 -Usa –Pxxxxxx       //change xxxxxx to real password

1> use omcdb

2> go

1> truncate table dc_v_SessionOpRecord

2> go

1> quit

5/ start all the services

. /opt/oss/server/svc_profile.sh
start_svc