Tapes required by backup stgpool

Hi everybody, TSM 6.2 on AIX 5.3 Is there any way to determine the primary tapes needed by a "backup stgpool" command before launching it. Thanks in advance. Regards.

Storage Pool Occupancy for each node report

Hi all, I'm new in TSM SQL and I have a problem with the following statement : select stgpools.stgpool_name as "STORAGE POOL", - stgpools.est_capacity_mb, - occupancy.node_name, - sum(occupancy.Physical_Mb) as "OCCUPANCY (MB)", - cast(sum(occupancy.Phy

Storage Pools/Volumes SQL

Hi all, The following SQL gives me a wrong result for the column NB_VOLUMES : tsm: TSM>select stgpool_name,maxscratch,est_capacity_mb,pct_utilized, - cont> (select count(*) from volumes where stgpool_name=stgpools.stgpool_name) as NB_VOLUMES - cont> from stgpools - cont> where devclass <> 'DISK'