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


//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:05
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Waiting (and waiting) for TSM prompt...

Can anyone please explain
why does it take so long for the 'tsm>' prompt to reappear after

tsm: LANCELOT>select  *  from backups

??

And what happens after I loose my patience and do

>Output to screen cancelled.  Please wait for the 'tsm>' prompt.
>
>^C
>ANS8035E Interrupted by user.
>
>ANS8002I Highest return code was 14.


--
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.