I think I didn't express myself correctly. What I mean is that if I do select * from <any_big_table> and then I get the first chunk of output and then I do 'C' to cancel the query it takes literally ages for 'tsm>' to reappear.
Why? If I ordered the query to stop (by issuing 'C'), isn't it that the query processing stops (or should stop) immediately? and then should release me the prompt right away? However it takes VERY long time for the prompt to return. On 6/28/07, Henrik Wahlstedt <[EMAIL PROTECTED]> wrote:
Processing time. A cleaner way to stop the transactions is to do a cancel session from a second admin cmd-line. Ctrl+C if I remember your first post correctly is not the way to stop your query. //Henrik -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Michael Green Sent: den 28 juni 2007 10:45 To: [email protected] Subject: Re: Waiting (and waiting) for TSM prompt... On 6/28/07, Henrik Wahlstedt <[EMAIL PROTECTED]> wrote: > Hi, > > Well, the backups table is rather large.... Which you have noticed. > > To run selects efficiently against backups table you need at least to > specify node_name='XYZ' and filespace_name='\\XYZ\c$\'. >
-- Warm regards, Michael Green
