11.2.13 Storing Items in the Item storage database
Closed Items registered in the Item management database in the specified period can be stored in the Item storage database. At this time, Items to be stored in the Item storage database are moved from the Item management database to the Item storage database. You must be careful because moved Items cannot return to the Item management database.
To store Items from the Item management database to 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
Do not stop JP1/Service Support - DB Server service.
-
-
From the Start menu, select Programs, JP1_Service Support, and then JP1_SS Command Prompt.
-
Execute the jssdbbackup.bat command.
Execute the jssdbbackup.bat command to back up the Item management database and Item storage database. Specify the-maint option as an argument. For details about the jssdbbackup.bat command, see jssdbbackup.bat (backs up databases) in Chapter 12. Commands.
-
Execute the jssitemstore command.
Execute the jssitemstore command to save the closed Items (in the Item management database) in the Item storage database. Specify the command so that Items registered in one year are stored. For details about the jssitemstore command, see jssitemstore (stores Items) in Chapter 12. Commands.
-
Execute the jssdbrorg.bat command.
When you execute the jssitemstore command, the Items stored in the Item storage database are deleted from the Item management database. Therefore, execute the jssdbrorg.bat command to reorganize the Item management database. For details about the jssdbrorg.bat command, see jssdbrorg.bat (reorganizes the Item management database) in Chapter 12. Commands.