IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Administrator's Guide > Manage historical data > Conversion process for using delimited flat files
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
What to do when the short-term history file directory size reaches its limit
When the KHD_TOTAL_HIST_MAXSIZE and KHD_HISTSIZE_EVAL_INTERVAL environment variables have been set for the Tivoli Enterprise Monitoring Agent (or at the Tivoli Enterprise Monitoring Server if data collection occurs there), no more historical data samples are added to the short-term history files if that maximum directory size has been reached.
You must resolve the cause of the unchecked short-term history file growth before the saving of data samples to the history files can resume. When data is collected at the agent you can create a custom SQL query or a situation or both that reports when this condition occurs.
Here is an example of a custom SQL query that you can run:
SELECT ORIGINNODE, CATEGORY, SEVERITY, TABLE, TIMESTAMP, MESSAGE FROM O4SRV.KRAMESG WHERE ORIGINNODE = $NODE$
Parent topic:
Conversion process for using delimited flat files