Error writing to t5*xins files after running for several days
The problem: In a high performance environment (more
than 300 transactions per minute), you might encounter errors for
the Web Response Time agent
if the following conditions are also true:
- The T5TXINS and T5SUBTXINS tables are being written to the data warehouse.
- All instance data is being saved.
- The operating system enforces a 2 gigabyte limit on file sizes.
The solution: To resolve this problem, configure the agent to keep only 1 hour of data instead of the typical 24 hours worth of data. Add the following additional setting to the t5.ini file (ITM_HOME/config/t5.ini):
KHD_HISTRETENTION= 1
In addition to this change, ensure that there is sufficient disk space for storing the large amount of resulting data in the warehouse database.