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.