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
