4.3.5 Checking the database size and reorganizing the Store database
The Store database consists of the data files, which store the actual data, and the index files, which manage the data indices for faster access. With Store 1.0, deleting data in the data files only invalidates the area of that data, and the size of the files does not decrease automatically. Although the invalidated area in the data files is reused, the reusing rate might suffer when the number of instances to store performance data varies with each collection, causing the size of the Store database to exceed the estimated size of the exclusively occupied disk space. For this reason, when using Store 1.0, we recommend that you check the size of the Store database regularly, and reduce the invalidated area by reorganizing the Store database when it occupies more than 90% of the estimated disk space. You do not need to reorganize the database when using Store 2.0.
- Organization of this subsection
(1) Checking the size of the Store database
Check the sizes of all the files with extensions .DB and .IDX in the storage location of the Store database, and calculate the total size of the files. With Store 1.0, when the total size exceeds 90% of the estimated disk space, perform the following procedure to reorganize the Store database.
(2) Reorganizing the Store database (Store 1.0 only)
-
Start the Performance Management service that will manage the Store database you want to reorganize.
By using the jpcspm start command, start the PFM - Agent or PFM - Manager service to manage the Store database you want to reorganize, if it is not running already.
-
Use the jpctool db backup command to back up the Store database.
Execute the jpctool db backup command to back up the Store database that you want to reorganize. The jpctool db backup command extracts data from the data file, except in the invalidated area, and saves the data.
- Note:
-
For the jpctool db backup command to work properly, the corresponding backup file requires more than double the total size of the Store database calculated above. Make sure that you have enough free space before you run the command.
-
Stop the service of Performance Management that has been managing the Store database that you want to reorganize.
By using the jpcspm stop command, stop the PFM - Agent or PFM - Manager service that has been managing the Store database that you want to reorganize.
-
Use the jpctool db restore command to restore the Store database.
Execute the jpctool db restore command to restore the Store database from the backup you made in step 2.
-
Start the service of Performance Management.
If necessary, start the service that you stopped in step 3 by issuing the jpcspm start command.