Job Management Partner 1/Software Distribution Administrator's Guide Volume 2

[Contents][Glossary][Index][Back][Next]

5.4.2 Deleting unnecessary data

If you use the database for a long period of time, a massive amount of inventory and operational information will accumulate in the database. This affects not only the disk space that is used but also search and update processing, which can cause the response time of the database to decrease. We recommend that you periodically check the number of data items listed in this subsection by using CSV output (or some other means), and delete any unnecessary data. For details about the CSV output utility, see 9.1.1 Items eligible for output to a CSV-formatted file in the manual Administrator's Guide Volume 1. Also, we recommend that you reorganize the database after deleting any unnecessary data in order to prevent database fragmentation, which is caused by deleting data. For details on how to reorganize Embedded RDB that is used as the relational database, see 5.2.1 (2) Reorganizing the database. If you are using Microsoft SQL Server or Oracle software for the relational database, see the relevant RDBMS documentation for details on how to reorganize the database.

Organization of this subsection
(1) System configuration
(2) Inventory information
(3) Jobs
(4) Packages
(5) Software operation information
(6) Patches that are applied to client

(1) System configuration

You can output destination types by using the CSV output utility, and check the number of registered items. Also, you can perform the maintenance operation on the system configuration to delete unneeded hosts. For details on how to maintain the system configuration, see 2.10.4 Maintaining system configuration information in the manual Description and Planning Guide. For details on how to delete unneeded deletion history, see 9.6.4 Deleting deletion history in the manual Setup Guide.

(2) Inventory information

By using Database Manager, you can delete the inventory information for the unneeded hosts at once.

For details, see 2.2.8 (2) Notes on inventory information of hosts not in the system configuration in the manual Description and Planning Guide.

(3) Jobs

(4) Packages

You can output package types by using the CSV output utility, and check the number of registered items. Also, you may excute and delete jobs in the Package window. Also, commands enable you to excute and delete packages. For details on how to delete the jobs, see 2.4.4 Deleting cabinets and deleting packages (managing packages) in the manual Administrator's Guide Volume 1.

(5) Software operation information

(6) Patches that are applied to client

In the Software Update Management dialog box, you can check the number of registered pathes. For details on how to delete unneeded patches that have already been acquired, see 7.1.1 Acquiring patches in the manual Administrator's Guide Volume 1.