Backup image select statement

[naga49]

Hi

I want to pull data of image backups of AIX filesystems information from TSM database using select statement.

Can somebody help me with select statement

Thanks
Suresh

 

[marclant]

You can use:

select * from backups where type='IMAGE'

If you also want to see the data and extents, then use:

select * from backups where type like 'IMAGE%'