Question DBI file contents

[Rob Fitzpatrick]

Is anything written to the client's DBI file other than the temp-table overflow, i.e. the data that doesn't fit in the temp-table buffers?

I ask because I just saw a client (started with -Bt 40000) that has a 100 MB DBI file; -tmpbsize is not specified. So by my math, the client has created 256 MB of temp-table data, of which 156 MB is memory-resident. I just want to be sure that the above is correct before I talk to development.

 

[TomBascom]

The (temp) table schema has to go somewhere. If a lot of temp-tables get created that could add up. Which might happen unexpectedly if something is recursing in an unforeseen manner. Or being passed by value rather than by reference.

 

[Rob Fitzpatrick]

Hmm. I didn't think of that but it makes sense that TT schema would go in the DBI file along with the data. That would be a lot of schema...

I guess at this point all I can do is report it to development and suggest that they add -yx to the client so they can somewhat narrow down which programs to look at.