Re: ODBC/QZDASOINIT Messages

[fbocch2595@xxxxxxx]

Hi Walden, if the file is left open it will cause abends in nightly batch jobs 
which are trying to recreate the file.  
Frank
  
 
-----Original Message-----
From: WaldenL@xxxxxxxxxxxxxxx
To: midrange-l@xxxxxxxxxxxx
Sent: Fri, 9 Mar 2007 3:16 PM
Subject: RE: ODBC/QZDASOINIT Messages


> No, the same job but no open files.  It's the only odbc job running on
the iSeries.  

It's also very dependant on how the connection is made, and maintained.
I believe the default is to lazy-close the connection, so it's possible
the connection was still open the first time, but actually closed the
second time. Also, if you're using connection pooling it's possible the
connection wasn't closed at all the first time. Finally, SQL may have
kept the files open the first time for performance reasons, but decided
it didn't need to do that the second time. 

Not to ask a silly question, but other than morbid curiosity, why do you
care that the files were left open? The way the query is implemented,
and even how the connection works are subject to change at any time if
IBM cares to change the code, and probably even is effected by the
general load on the system, and available memory, disk performance, etc.

-Walden