5.12.4 Considering reorganization of the Item management database
Repetition of addition, update, and deletion of data in the Item management database in daily operations disarranges the data and indexes in the Item management database, which causes a decrease in storage efficiency (increase of invalid areas) or in performance.
In such case, maintain the database according to the following methods:
-
Execute the jssdbreclaim.bat command.
Regularly use this command to resolve decrease in storage efficiency (increase of invalid areas).
The jssdbreclaim.bat command can be executed while the database is running.
-
Execute the jssdbrorg.bat command.
Use this command to resolve decreases in storage efficiency (increase of invalid areas) and in performance during maintenance operations. Note that the jssdbrorg.bat command can be used only while the database operation is stopped because this command places a heavy load on the Item management database.
For details, see jssdbreclaim.bat (releases the free space in the Item management database) and jssdbrorg.bat (reorganizes the Item management database) in Chapter 11. Commands.
- Note:
-
If you execute the jssdbrorg.bat command, do it when JP1/Service Support - DB Server is running but all other JP1/IM - Service Support services are stopped. In this case, JP1/Service Support - Web Service, JP1/Service Support, and JP1/Service Support - Task Service must be stopped.