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$\'.
>
>

Thanks Henrik!

You are right stating that the table is big, but still why does it take
so long for the prompt to reappear? I mean what prevents it from
dropping the table lookup right away and giving me back the prompt?
--
Warm regards,
Michael Green


-------------------------------------------------------------------
The information contained in this message may be CONFIDENTIAL and is
intended for the addressee only. Any unauthorised use, dissemination of the
information or copying of this message is prohibited. If you are not the
addressee, please notify the sender immediately by return e-mail and delete
this message.
Thank you.