HSM database schema

[gorally]

Does anyone know what an HSM entry looks like in the TSM database. For regular backup or archive, they have the "type" to distinguish between the two. Anyone know how HSM activity look like from the SQL enquiry?

Thanks,

 

[alimirza]

The HSM table name is "SPACEMGFILES". To see all the cloumns in the table, you can issue

dsmadmc> select * from syscat.columns where tabname='SPACEMGFILES'