|
Jim I can recall getting rid of this behaviour at one stage by loading the latest database group PTF. It was explained to me that there was some optimization of the saving of the query access plan in the query definition object in the latest PTF's. The files in question causing the problem were all logicals files over a monster of a file if thats any help to you. Depending on when you last upgraded your OS, and what cume and group cume level you are on this may seem a rather useless answer but it did do the job in my case :) I can't even remember what release it was - V4R3, V4R4 or V4R5. Hope this helps regards Evan Harris >Good morning. On occasion, without pattern or otherwise noticeable reason, >exiting a query can take upwards of 20 minutes (even before it actually >submits the query for processing). Our system admin is as perplexed as I am >on this one. Anyone have any experience or insight with this? > > >Much appreciated, >Jim >_______________________________________________ >This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list >To post a message email: MIDRANGE-L@midrange.com >To subscribe, unsubscribe, or change list options, >visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l >or email: MIDRANGE-L-request@midrange.com >Before posting, please take a moment to review the archives >at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
