6.2.1 How to check the database usage
You can use output messages to check database usage.
- 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.