Hi, Thanks for the replies. Just tested and it takes approx 20 minutes for the SQL to complete (approx 5.2 million files).
Workable, but I do not understand why the client just lists the archives directly. Maybe the archive info is also stored on the client side which makes is fast. Kind regards, Geert "ADSM: Dist Stor Manager" <[email protected]> wrote on 04/01/2007 17:45:50: > On Jan 4, 2007, at 11:30 AM, Alexander Verkooijen wrote: > > > Hi, > > > > Something like this should provide a list of all archives: > > > > select node_name,description from archives group by > > node_name,description > > > > But like you said it will probably take a very long > > time to complete. ... > > Listing all Archives (or Backups) is a *very* expensive "fishing > expedition". If you *must* do this from the server (rather than more > efficiently, from the client), then try to limit it to subsets that > you really need, where taking advantage of Keyed columns should > substantially speed the query. > > Do select * from syscat.columns where TABNAME='ARCHIVES' > > to see the table column definitions, where columns having > INDEX_KEYSEQ entries are keyed, and render more efficient searches in > a Select. > > Richard Sims
