On Jan 6, 2006, at 3:10 AM, De Keyser Bart wrote:

...
Within the retrieve module of the Backup-Archive Gui, you can view a
list of all available archives.. so it should be possible to generate
this list with a select, no?? ...

Yes, but fishing expeditions are very expensive in the TSM database,
no matter how they are conducted. You need to restrict your search to
limited areas so as to go after a reasonable number of items in each
request.

You can pursue the Select per the TSM doc, the TSM 5.1 Technical
Guide redbook appendix on SQL, and the available fields reported via
'SELECT * FROM SYSCAT.COLUMNS'. In your case, do: SELECT * FROM
SYSCAT.COLUMNS WHERE TABNAME='ARCHIVES' to see the column names you
can operate on.

  Richard Sims