how is possible to destroy/delete several models in bulk without impacting on SpectroSERVER?

Document ID : KB000016175
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Customer has several models from type SharedMediaLink that need to be destroyed from SSdb. He tried via oneclick and also via vnmsh CLI. Always the same result: after the destroy process is started he noted an high cpu utilization and spectroSERVER could not be clearly shutdown. What do to?

Question:

How is possible to destroy/delete several models in bulk without impacting on SpectroSERVER?

Environment:
any
Answer:

1. Open a case with CA Support to obtain the SSdebug executable for your Spectrum version. 

2. Put the SSdebug executable in the SS directory on the SS in the <SPECROOT>/SS directory (change the permissions to be executable if need be). 

3. With the SpectroSERVER still running, execute the following command in CLI:

cd <SPECROOT>/vnmsh

connect

./show models mth=<specify_the_model_type> | awk '{print "delete " $1}' > modeltodelete.play 

4. Move the modeltodelete.play file to the SS directory. 

5. Save your SSdb.

6. Stop the SpectroSERVER. If it does not stop, you will need to crash the SS and reload your SSdb from either step #5 or from a previous SSdb savefile. 

7. Navigate to the SS directory in a bash shell. 

8. Execute the following command to mark the models for deletion: 

./SSdebug -database -play modeltodelete.play model.OUT 

9. Start the SpectroSERVER 

10. The VNM.OUT will note that the models have been marked for deletion.

11. The SS cpu will spike to 100% while it deletes the models. This is normal and could take many hours (we have typically found that it takes approximately 1 hour for every 75000 models).