Instructions for preventing databases from corruption – Database Stop Utility for CSI
Dear All Circle Cordinators,
We, POS team, tomorrow will give a Webex demonstration of an already live post office screen to all of you regarding this following matter. Please go through below topic.
Kind Attention : DMCC Team/All System Administrators/All Circle Coordinators:
During the course of implementation in CSI POS, the major issue we faced are no other than Sync Issues. In last few months we have also seen that the number of database file corruption in local post offices have increased rapidly.
While doing the RCA, we found that this is because of abrupt shutdown of server machines without shutting down the Database Server separately. This is a big point of worry for CSI POS team.
We assumed, on an ideal condition the database server machine will run 24×7, and the master data will flow during the off-hours, while transactional data will flow during the business hours. But on the ground it is difficult to maintain the same, as told by the DoP people. They cited that the power failure is predominant in remote Indian terrain and also keeping UPS ON is not possible since there is risk of fire from UPS and so on and so forth.
So we have decided to introduce the Stop Database Utility, which should be used before shutting down the server system at the End Of Day. This required to be followed sincerely to avoid DB corruption issues.
To download the utility please follow instructions as below: