Hi Larry, I thing that my TSM Server do not have this DB record (version 5.2) , but I will try to help you or give you some ideas.
Try sommething similarlike this: select volume_name from volumeusage where stgpool_name='STORAGEPOOL' group by volume_name try to find where COLLOCG record are (maybe in nodedata table) See on TSM Server commnd line all the tables from db: h select select * from tables select * from columns ... Useful scripts can be made with TSm DB Best regards Tiago -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Larry Clark Sent: sábado, 14 de Março de 2009 22:13 To: [email protected] Subject: [ADSM-L] volumes in a collocation group? Hi, Would someone have a query that returns all the volumes in a particular collocation group (within a copypool)?
