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