× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



While I'm not a db2-400 gear-head, I would expect this to be a simply
matter of db optimization (caching) enabling the results to be returned
without locking the file.

Joe Hayes
Fiserv Property and Casualty Solutions
direct: 319.398.1831
cell: 319.573.8877
800: 800.928.9926
Joe.hayes@xxxxxxxxxx
 
This email may contain confidential and privileged material for the sole
use of the intended recipient(s). Any review, use, distribution or
disclosure by others is strictly prohibited. If you are not the intended
recipient (or authorized to receive for the recipient), please contact
the sender by reply email and delete all copies of this message.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary Monnier
Sent: Friday, March 09, 2007 1:39 PM
To: Midrange Systems Technical Discussion
Subject: RE: ODBC/QZDASOINIT Messages

Frank,

Could be several things.  Client closed the cursor(s), number of uses
was exceeded and an new job started, exit program closed the cursor(s)
(RCLRSC for example), etc.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of fbocch2595@xxxxxxx
Sent: Friday, March 09, 2007 10:57 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: ODBC/QZDASOINIT Messages


Another question on these jobs.  
 
When I run the select statement (using winsql) and I get the results on
my screen I wrkjob qzdasoinit and I see open files (via option 14 from
wrkjob).  Then, when I run the very same select statement again I don't
see any open files.  I'm waiting for IBM to get back to me on this but
does anyone know why the job would display files then when the same
statement is run again, no open files? 
 
Thanks, Frank 
 
 


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.