11.2.11 Rotating the storage locations in the Item storage database
If Items for specified years have been stored in the active storage area and you want to store more Items, you need to rotate the locations where Items are stored (storage areas). Any Items stored in the switching destination must be deleted. Before deleting Items, you can output information about the Items to a CSV file.
To rotate the storage locations in the Item storage database:
-
Stop services in the following order:
-
JP1/Service Support - Task Service service
-
JP1/Service Support - Web Service service
-
JP1/Service Support service
-
-
Execute the jssdbstatchk.bat command.
Check the status of Items stored in the active storage area. If more Items can be stored in the active storage area, the following steps are not necessary. For details about the jssdbstatchk.bat command, see jssdbstatchk.bat (checks the database status) in Chapter 12. Commands.
-
Execute the jssitemstoredbsetup.bat command.
If the storage area for the switching destination has not been set up, execute the jssitemstoredbsetup.bat command to set up the storage area. This step is not necessary if the storage area for the switching destination has been set up. For details about the jssitemstoredbsetup.bat command, see jssitemstoredbsetup.bat (sets up an Item storage database) in Chapter 12. Commands.
-
Execute the jssitemstoredbrotate command.
Execute the jssitemstoredbrotate command to rotate the storage areas. This step is not necessary if the check result in step 2 indicates that Items for the specified years have not been stored in the active storage area. For details about the jssitemstoredbrotate command, see jssitemstoredbrotate (rotates Item storage databases) in Chapter 12. Commands.
-
Execute the jssitemexportEx command.
If Items for the specified years have been stored in the storage area for the switching destination, execute the jssitemexportEx command to output Item information to a CSV file. You can specify the start date and end date in the jssitemexportEx command to specify Items in the storage area for the switching destination. This step is necessary only if you want to delete stored Items from the storage area for the switching destination. For details about the jssitemexportEx command, see jssitemexportEx (exports extended Item information) in Chapter 12. Commands.
-
Execute the jssstoreitemdel.bat command.
Execute the jssstoreitemdel.bat command to delete stored Items from the storage area for the switching destination, only as needed. For details about the jssstoreitemdel.bat command, see jssstoreitemdel.bat (deletes stored Items) in Chapter 12. Commands.