5.2.1 How to check the database usage
You can check the database usage from generated messages and on the Database Details screen of the Web GUI (Management Portal).
- Organization of this subsection
(1) When the database auto-increment function is used
Each time the database has too little remaining free space and is automatically expanded, the KFPH22024-W message is output to the Windows event log or syslog. If the KFPH22024-W message is output repeatedly, reconfigure the database and check whether the data increment value (job definition information and job execution registration information) is appropriate.
(2) When the database auto-increment function is not used
The KFPH00211-I message is output to the Windows event log or syslog when the usage rate reaches 80%, 90%, or 100%. Therefore, periodically check the Windows event log or syslog.
When the usage rate is 80%, you can avoid problems by reorganizing the database. However, when the usage rate reaches 90% or 100%, simply reorganizing the database will not eliminate the problems. Instead, you will need to delete data (job definition information and job execution registration information) or expand the database.
- Cautionary note
-
If the backup enhancement function is enabled, see also 5.2.5(5) Considerations before using the backup enhancement function in the JP1/Automatic Job Management System 3 System Design (Configuration) Guide.
(3) When the Web GUI (Management Portal) is used
If you are using the Web GUI (Management Portal), you can check the database usage on the Database Details screen. On this screen, alerts are displayed for the databases with low free space. Periodically check the database usage from the Web GUI (Management Portal) and maintain or reorganize databases as necessary.
To use the Web GUI (Management Portal), you must set it up on both the manager host and agent host. For details about how to set up, see 6.7 Settings related to the Web GUI in the JP1/Automatic Job Management System 3 Configuration Guide (in Windows) or 15.8 Settings related to the Web GUI in the JP1/Automatic Job Management System 3 Configuration Guide (in UNIX).
For details on Database Details screen operations, see 16.2.14 Database Details screen in the JP1/Automatic Job Management System 3 Operator's Guide.