11.2.12 Expanding the Item storage database
If the capacity of the Item storage area or attached file storage area in the Item storage database is insufficient to store Items, you need to expand the capacity of the Item storage database. To do this, you need to estimate the data size of Items to be stored.
- Note:
-
If Item storage databases are stored on different drives and a hardware error occurs in one of those drives, you can no longer operate JP1/Service Support.
To expand the capacity of the Item storage database:
-
Execute the jssitemcount command.
Specify the -ALL option as an argument to check the number of Items registered in JP1/Service Support. For details about the jssitemcount command, see jssitemcount (counts Items) in Chapter 12. Commands.
-
Execute the jssitemcount command.
Specify the -ct option as an argument to check the number of Items that are to be stored in the Item storage database. At this time, specify the start date and end date of the period during which the Items to be stored were registered. For details about the jssitemcount command, see jssitemcount (counts Items) in Chapter 12. Commands.
-
Execute the jssdbstatchk.bat command.
Execute the jssdbstatchk.bat command to check the database capacity and usage for each Item storage area and attached file storage area in the Item management database and Item storage database. For details about the jssdbstatchk.bat command, see jssdbstatchk.bat (checks the database status) in Chapter 12. Commands.
-
Estimate the data size of Items to be stored.
Estimate the data size of Items to be stored based on the values you checked in steps 1 to 3.
The following shows an estimate example:
- Status of the Item management database
-
Number of Items registered in JP1/Service Support: 200,000
Number of Items to be stored: 100,000
Database capacity and usage of the Item storage area in the Item management database: 40 GB, 80%
Database capacity and usage of the attached file storage area in the Item management database: 30 GB, 50%
- Estimate results
-
Data size of Items to be stored: 40 * 0.8 * 10 / 20 = 16 GB
Data size of attached files to be stored: 30 * 0.5 * 10 / 20 = 7.5 GB
-
Calculate the amount of free space in the Item storage database.
Calculate the amount of free space in the Item storage area and attached file storage area in the Item storage database, based on the values you checked in step 3.
- Status of the Item storage database
-
Database capacity and usage of the Item storage area in the Item storage database: 128 GB, 90%
Database capacity and usage of the attached file storage area in the Item storage database: 64 GB, 70%
- Calculation results
-
Amount of free space in the Item storage area in the Item storage database: 12.8 GB
Amount of free space in the attached file storage area in the Item storage database: 19.2 GB
-
Check whether the data size is small enough to be stored in the Item storage database.
Based on the values obtained in steps 4 and 5, check whether the target Items can be stored in the Item storage database.
- Estimate and calculation results
-
Data size of the Items to be stored: 16 GB
Data size of the attached files to be stored: 7.5 GB
Amount of free space in the Item storage area in the Item storage database: 12.8 GB
Amount of free space in the attached file storage area in the Item storage database: 19.2 GB
- Check result
-
Because the data size of the Items to be stored is larger than the amount of free space in Item storage area in the Item storage database, the capacity of the Item storage area is insufficient. Note that this example only shows a rough estimate of data sizes. The capacity obtained by calculation might be different from the actual capacity in individual operation cases.
-
Stop services in the following order:
-
JP1/Service Support - Task Service service
-
JP1/Service Support - Web Service service
-
JP1/Service Support service
Note that this step is necessary only if you want to execute the jssitemstoredbexpand.bat command to expand the Item storage database.
-
-
Execute the jssitemstoredbexpand.bat command.
Execute the jssitemstoredbexpand.bat command to expand the Item storage database. This step is not necessary if the check result in step 6 indicates that target Items can be stored without expanding the Item storage database. For details about the jssitemstoredbexpand.bat command, see jssitemstoredbexpand.bat (expands an Item storage database) in Chapter 12. Commands.