Note: Do Not perform this on Production Environments. This is only for educational and reference purposes and should be performed in Test Environments only.
So i was working with the STSC database during my project and i found an interesting thing that i would like to share.
So during the deployments if you get stuck on a point where you want to
- remove/change your ST Proxy or ST Meeting Servers etc, deployment status due to failed installation.
- or you just want to change the status of a product from Uninstalled to install / registered or vice verse in the ST System Console under Sametime Guided Activities.
You can do that by changing the value in the DepStatus column of Deployment Table in STSC database as follow.
1. Open the DB2 Control Panel and Open STSC Database.
2. Open the Deployment Table.
Check the DepStatus Column you will see Someting link this.
In ST System Console: In DepStatus Column of STSC Database:
Installed/Registered/Clustered = 1798 (for ST Proxy).
Installed/Registered/Clustered = 774 (for ST Community Server).
Uninstalled = 15 (for ST Proxy).
So if you change the status code to 15 and Commit the changes in Deployment Table for ST Proxy you will notice that the product status changes to Uninstalled in the ST System Console - Sametime Guided Activities and the server entry will be removed from Sametime Servers - Sametime Proxy Servers.
Note: This will not remove any WAS node / server if they are added, federated or clusterd in the ST System Console DMGR. This only works similar to register or unregister the Sametime Servers using registerWASserver.bat or unregisterWASserver.bat scripts found under Sametime Servers (Console) folder.
You can note down the status codes during your installation phase, and can easily unregister/revert back to that state if you want by changing the status codes.
So i was working with the STSC database during my project and i found an interesting thing that i would like to share.
So during the deployments if you get stuck on a point where you want to
- remove/change your ST Proxy or ST Meeting Servers etc, deployment status due to failed installation.
- or you just want to change the status of a product from Uninstalled to install / registered or vice verse in the ST System Console under Sametime Guided Activities.
You can do that by changing the value in the DepStatus column of Deployment Table in STSC database as follow.
1. Open the DB2 Control Panel and Open STSC Database.
2. Open the Deployment Table.
Check the DepStatus Column you will see Someting link this.
In ST System Console: In DepStatus Column of STSC Database:
Installed/Registered/Clustered = 1798 (for ST Proxy).
Installed/Registered/Clustered = 774 (for ST Community Server).
Uninstalled = 15 (for ST Proxy).
So if you change the status code to 15 and Commit the changes in Deployment Table for ST Proxy you will notice that the product status changes to Uninstalled in the ST System Console - Sametime Guided Activities and the server entry will be removed from Sametime Servers - Sametime Proxy Servers.
Note: This will not remove any WAS node / server if they are added, federated or clusterd in the ST System Console DMGR. This only works similar to register or unregister the Sametime Servers using registerWASserver.bat or unregisterWASserver.bat scripts found under Sametime Servers (Console) folder.
You can note down the status codes during your installation phase, and can easily unregister/revert back to that state if you want by changing the status codes.
No comments:
Post a Comment