Hitachi

JP1 Version 12 JP1/Service Support Configuration and Administration Guide


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:

For details, see jssdbreclaim.bat (releases the free space in the Item management database) and jssdbrorg.bat (reorganizes the Item management database) in Chapter 12. Commands.

Note:

If you execute the jssdbrorg.bat command, do it when JP1/Service Support - DB Server Service is running but all other JP1/Service Support services are stopped. In this case, JP1/Service Support - Web Service, JP1/Service Support Service, and JP1/Service Support - Task Service must be stopped.