Total data stored and tapes used per node in one storage pool
This select will show NODE_NAME, TOTAL_MB that is amount of data stored in TSM for this node, TAPES that is the amount of tapes that contain data of this node located in the specified storage pool, and AVG MB/tape that is the average of MB by tape (TOTAL_MB divided by number of tapes with node data). It’s sorted by worst data distribution.
select vu.node_name, ao.total_mb, count(distinct vu.volume_name) as tapes, ao.total_mb/count(distinct vu.volume_name) as "AVG MB/tape" from volumeusage vu, auditocc ao where vu.stgpool_name='TAPEPOOL' and vu.node_name=ao.node_name group by vu.node_name, ao.total_mb order by 4
This select will show NODE_NAME, TOTAL_MB that is amount of data stored in TSM for this node, TAPES that is the amount of tapes that contain data of this node located in the specified storage pool, and AVG MB/tape that is the average of MB by tape (TOTAL_MB divided by number of tapes with node data). It’s sorted by worst data distribution.
select vu.node_name, ao.total_mb, count(distinct vu.volume_name) as tapes, ao.total_mb/count(distinct vu.volume_name) as "AVG MB/tape" from volumeusage vu, auditocc ao where vu.stgpool_name='TAPEPOOL' and vu.node_name=ao.node_name group by vu.node_name, ao.total_mb order by 4
This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.
Related Post
Redefining TSM Library and Drives for Aix OS
Sometimes there are specific errors, such as:
ANR0523W Transaction failed - error on output stor- System state restore fails with ANS1079E
Problem(Abstract)
A system state restore fails with this message: ANS1079E No file specification
- TSM commands needed to move tapes in and out of library
Regular TSM commands I use to manipulate tapepool volumes in and out of library when slots are ful
- ANS1025E Session rejected: Authentication failure
RUNASSERVICE is set to YES, thus forcing a previous client command process to continue running, a