...And specifying the clause "where node_name=blah" IS VERY IMPORTANT,
because the archives (and backups) table are indexed on node_name (and also
filespace_name, but NOT on description...)

So I have found that if I have to search the entire backups (or archives)
table, it just will never complete.  BUT, if I pull a list of nodenames,
then write a host script that cycles through the list and does a query
against the table for EACH node name in succession, it works fine.  Using
the index is important when searching the hugest tables.

-----Original Message-----
From: Dwight Cook [mailto:cookde AT US.IBM DOT COM]
Sent: Thursday, May 15, 2003 8:25 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: How to quickly determine the descriptions of archives?


Do you use the "distinct" option...?  That might help speed things up a
bit...

      select distinct description from archives where node_name='blah'

Dwight





                      "Brazner, Bob"
                      <Bob.Brazner@JCI.        To:
ADSM-L AT VM.MARIST DOT EDU
                      COM>                     cc:
                      Sent by: "ADSM:          Subject:  How to quickly
determine the descriptions of archives?
                      Dist Stor
                      Manager"
                      <[email protected]
                      .EDU>


                      05/15/2003 06:18
                      PM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






How can I  *quickly* determine the descriptions of archives using the CLI?
I know the gui can do it quickly, but I'm forced to using the CLI as the
archives were taken under Netware.  I find doing an SQL query against the
ARCHIVES table takes forever.

Bob Brazner
Johnson Controls, Inc.
(414) 524-2570