I've always imagined that the dsmserv process send all the data regardless,
akin to >/dev/null. IE, the server carries on sending, but after pressing
'C' your not listening anymore.

I'd be interested to know what is really going on and why it needs to be.

Most of the time you can ctrl+c and log back in quicker.

Matt.
http://tsmwiki.com/



           Internet
           gooooc AT GMAIL DOT COM
                                                                                
                  To
                                                 ADSM-L
           Sent by: ADSM-L AT VM.MARIST DOT EDU                                 
                         cc

           28/06/2007 10:16                                                     
             Subject
                                                 Re: [ADSM-L] Waiting (and 
waiting) for TSM
                                                 prompt...
                 Please respond to
                ADSM-L AT VM.MARIST DOT EDU









the query processing stops but cleaning up temporary generated data
tables takes up the time is my guess

On 6/28/07, Michael Green <mishagreen AT gmail DOT com> wrote:
> 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
>



This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and
immediately notify the sender. Any use not in accord with
its purpose, any dissemination or disclosure, either whole
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message.
BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.

                ---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses
destinataires et sont confidentiels. Si vous recevez ce
message par erreur, merci de le detruire et d'en avertir
immediatement l'expediteur. Toute utilisation de ce
message non conforme a sa destination, toute diffusion
ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse. L'internet ne permettant pas
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce
message, dans l'hypothese ou il aurait ete modifie.