IRISTEMP - IRIS.DAT took up all the available disk space of almost 2 TB that leads to Production instance down.

After RCA the suspected cause was some SQL query but not confirmed as query result was received within a minute.

Currently we are monitoring the IRIS.DAT and it is continuously increasing and currently we set the MAX size for this DB,  but not sure what will happen once it hit the MAX SIZE ?

Any clue why the IRISTEMP DB is not flushing the data from IRIS.DAT as i believe it is being mostly used for system processes and is in increasing trend at  ~ 1GB/day?

When I tried to make change in DTL view then only i see following error whereas in XML mode no issue in compilation.

Any resolution and solution ? it looks like some missing xml parser configuration or Pulg ins ?

ensEPC.DataTransforms.dtEcgCEpc081518.dtl was saved locally but could not be saved remotely.