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
