ODBC connection causing DBI file grow

[ntszarek]

Hi everyone

It happened today that while connecting to the database and querying tables on our progress server the .dbi several files were created. Each of them was about 3GB large and because of it we nearly ran out of space. Is there any way to prevent these file growth (i.e to not be larger than x mb?). Or maybe there's a possibility to change their location (to be created on another server)?

Thanks in advance

 

[Rob Fitzpatrick]

A DBI file is created by a SQL server to store query results during a query. I don't know if you can prevent it but you can change its location by specifying the -T <directory> (temp directory) parameter on your SQL broker, so at least these files won't fill up your database partition.