5.12.3 Considering deletion of data from the Item management database
If user information and role information are deleted on the window, they are also deleted from the Item management database. However, if target systems, process work boards, and Item data (including attached files) are deleted on the window, they are not deleted from the Item management database. You need to separately execute the jssdelrec command to delete those kinds of information from the Item management database.
If you do not need to retain those kinds of information in the Item management database, we recommend that you execute the jssdelrec command to delete those kinds of information from the Item management database. This could be done, for example, at regular system reviews.
For details, see jssdelrec (deletes data from the Item management database) in Chapter 12. Commands.
- Notes:
-
-
If you execute the jssdelrec command to delete data, do it when JP1/Service Support - DB Server service is running but all other JP1/Service Support services are stopped.
Note that if you do not specify the -b option, you must execute the jssdelrec command in the state in which JP1/Service Support - Web Service service and JP1/Service Support service are stopped. If you specify the -b option, you can execute the jssdelrec command even in the state in which JP1/Service Support - Web Service or JP1/Service Support service is running.
-
If you execute the jssdelrec command to delete data, the corresponding data elements are all deleted, but their storage areas only become vacant space and cannot be reused until they are released. Increase of vacant space might cause a decrease in storage efficiency (increase of invalid areas) or in performance.
Therefore, after deleting data, make sure to execute the jssdbreclaim.bat command to release the remaining vacant space in the Item management database.
For details, see jssdbreclaim.bat (releases the free space in the Item management database) in Chapter 12. Commands.
-
If you delete unnecessary Items, also consider deletion of the related Items. If related Items are not deleted, when you check the associations between Items in the Status of related item window or by other ways, the associations will become uncertain.
For example, if Items are escalated with the escalation flow in the order of Item A, Item B, and then Item C, and then you execute the jssdelrec command to delete Item B only, the escalation destination Item ID for Item A and the escalation source Item ID for Item C will not be displayed (- is displayed) in the Status of related item window.
-
You can use the jssitemdeletion command to delete a large number of Items in a batch. By executing the jssitemdeletion command, you can place multiple Items into the status of waiting for deletion at the same time. For details on using the jssitemdeletion command to delete Items in a batch, see 11.2.2 Deleting Items from the Item management database.
-