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: [EMAIL PROTECTED] 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. **********************************************************************
