Every morning I need to manually restart all WebI Processing Servers (WPS) to pick up changes that are done automatically in the DB2 middleware on the server. Otherwise reports would go for data to a wrong database.
What would be the easiest/cleanest/most suitable way to perform WPS restart automatically? Any sort of Java or Restful program/script? Can you please suggest?
I could maybe have a script that kills WPS process on the OS level but that does not seem to me as a safest/cleanest way of doing it.