Optimizing CIP Server Database
This process requires placing the system in maintenance mode, meaning the system will be unusable during this process. Therefore it is highly recommended to schedule some downtime in order to perform this operation, the amount of time it takes depends on how much data a specific engine has as well as the server’s general performance. Normally this takes around an hour but it is possible it may take longer.
It is important to take a snapshot of the Virtual Machine prior to performing the optimization process. If your system is not virtualized then please contact our support team to ensure the process goes smoothly.
Follow the guide in this link to place the system in https://cipreporting.atlassian.net/wiki/spaces/SUP/pages/1273593858
Once the system is in Maintenance Mode open up the CIP Shell and type the following command to see a list of available engines:
engine list
Once you have the name of the engine you wish to optimize type in the command below, be sure to replace [engine_name] with the actual name of the engine obtained from the step above.
engine optimize [engine_name]At this point the process will continue until it’s done optimizing the database, on the rare possibility that it fails all that’s needed is to run the same command above and the system will continue optimizing from where it left off.
Once the process is done all that’s needed is to take the system off of Maintenance Mode by following the same guide linked in Step #1 and all your users should be able to log in again.
Done!