Re: Contents of a known archive

Only part of the tables are available to us for SELECT queries. The client
is talking to the server and latter using some hidden tables. That why
client list gets out faster. To get the result at the same speed you will
need to write a program and use TSM "verbs" which most probably you cannot
afford.
Sorry, I have no better answer.

Zlatko Krastev
IT Consultant






Roy Lake <RLake AT TANDB.CO DOT UK>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
23.09.2002 16:37
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Contents of a known archive


Guys,

I have been trawling through the archives here and I am unable to find
a suitable answer.

I have noted that when you use the WEB/DSM GUI it actually displays the
archive contents fairly quickly, so I suspect that there HAS to be a
quicker way of getting the result I need.

Basically, I want to know what filespaces are in a given archive. I
already know the archive name, so here is the select statement I am
using:-

select DISTINCT filespace_name from archives where
description='description' and node_name='nodename'

This actually DOES work fine, but it takes anything between 3-5 minutes
to get a result.

Anyone know of a quicker way of doing it? - anyone know how the WEB/DSM
gui does it so quickly?.

Kind Regards,

Roy Lake
RS/6000 & TSM Systems Administrator
P: +44 (0)20 8526 8853 (or Helpdesk number 0870 607 6777, +44 (0)20
8526 8888)
Internet E-Mail: rlake AT tandb.co DOT uk
URL: www.tibbett-britten.com

This e-mail message has been scanned using Sophos Sweep http://www.sophos.com

**********************************************************************
-------  IMPORTANT INFORMATION ---------
This message is intended only for the use of the Person(s) ('the
intended recipient') to whom it was addressed. It may contain
information which is privileged & confidential within the meaning
of applicable law. Accordingly any dissemination, distribution,
copying, or other use of this message, or any of its contents,
by any person other than the intended recipient may constitute
a breach of civil or criminal law and is strictly prohibited.

If you are NOT the intended recipient please contact the sender
and dispose of this email as soon as possible. If in doubt please
contact European IT on 0870 607 6777 (+44 20 85 26 88 88).
This message has been sent via the Public Internet.
**********************************************************************