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 <SHWL AT statoil DOT com> 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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Michael Green
Sent: den 28 juni 2007 10:45
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Waiting (and waiting) for TSM prompt...

On 6/28/07, Henrik Wahlstedt <SHWL AT statoil DOT com> 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