Volume Information

Volumes

Number of scratch volumes

tsm: SERVER1> SELECT COUNT(*) FROM libvolumes WHERE status='Scratch'

Unnamed[1]

-----------

18

Number of scratch volumes in library 3584

tsm: SERVER1> SELECT COUNT(*) FROM libvolumes WHERE status='Scratch' and library_name='3584'

Unnamed[1]

-----------

18

Number of scratch volumes for each library

tsm: SERVER1> SELECT library_name,COUNT(*) FROM libvolumes WHERE status='Scratch' GROUP BY library_name

LIBRARY_NAME Unnamed[2]

------------------ -----------

3584 18

Number of volumes per device class

tsm: SERVER1> SELECT devclass_name, COUNT(*) FROM volumes GROUP BY devclass_name

DEVCLASS_NAME Unnamed[2]

------------------ -----------

3584 133

DISK 6

Number of volumes per storage pool

tsm: SERVER1> SELECT stgpool_name,COUNT(*) FROM volumes GROUP BY stgpool_name

STGPOOL_NAME Unnamed[2]

------------------ -----------

AIX_ANUAL 4

AIX_ARCH1 2

AIX_ARCH2 2

AIX_DAILY 20

AIX_MONTHLY 4

AIX_NOLIMIT 1

NT_DAILY 41

NT_MONTHLY 22

Number of volumes unavailable

tsm: SERVER1> SELECT COUNT(*) FROM volumes WHERE access='UNAVAILABLE'

Unnamed[1]

-----------

0

Number of volumes in error state

tsm: SERVER1> SELECT COUNT(*) FROM volumes WHERE error_state='YES'

Unnamed[1]

-----------

1

Volumes with write or read errors in the library

tsm: SERVER1> SELECT volumes.volume_name, volumes.stgpool_name, volumes.pct_utilized, volumes.status, -

volumes.write_errors, volumes.read_errors FROM volumes, libvolumes WHERE -

volumes.volume_name=libvolumes.volume_name AND ( volumes.write_errors>0 OR volumes.read_errors>0 )

VOLUME_NAME STGPOOL_NAME PCT_UTILIZED STATUS WRITE_ERRORS READ_ERRORS

------------------ ------------------ ------------ ------------------ ------------ -----------

P10128 AIX_DAILY 27.1 FILLING 1 0

P10129 AIX_DAILY 8.2 FULL 2 0

P10135 NT_MONTHLY 22.3 FILLING 0 1

...

Number of volumes per library

tsm: SERVER1> SELECT library_name,COUNT(*) FROM libvolumes GROUP BY library_name

LIBRARY_NAME Unnamed[2]

------------------ -----------

3584 72

Full volumes with utilization (%) less than XX

tsm: SERVER1> SELECT volume_name,devclass_name,stgpool_name,pct_reclaim,pct_utilized FROM volumes -

WHERE status='FULL' AND pct_utilized < 10

VOLUME_NAME DEVCLASS_NAME STGPOOL_NAME PCT_RECLAIM PCT_UTILIZED

--------------- ------------------ ---------------- ----------- ------------

R00010L3 3584 NT_DAILY 94.9 5.2

R00015L3 3584 AIX_DDAILY 99.9 0.0

R00026L3 3584 NT_DAILY 94.2 6.0

R00028L3 3584 AIX_DAILY 99.9 0.0

...

Full volumes with reclaimable space (%) greater than XX

tsm: SERVER1> SELECT volume_name,devclass_name,stgpool_name,pct_reclaim,pct_utilized FROM volumes -

WHERE status='FULL' AND pct_reclaim >90

VOLUME_NAME DEVCLASS_NAME STGPOOL_NAME PCT_RECLAIM PCT_UTILIZED

--------------- ------------------ ---------------- ----------- ------------

R00010L3 3584 NT_DAILY 94.9 5.2

R00015L3 3584 AIX_DAILY 99.9 0.0

R00026L3 3584 NT_DAILY 94.2 6.0

R00028L3 3584 AIX_DAILY 99.9 0.0

...

Full volumes with reclaimable space (%) greater than XX in the library

tsm: SERVER1> SELECT volumes.volume_name, volumes.stgpool_name, volumes.pct_utilized, volumes.pct_reclaim, -

volumes.status, volumes.access FROM volumes, libvolumes WHERE volumes.volume_name=libvolumes.volume_name -

AND volumes.status='FULL' AND volumes.pct_reclaim>80 ORDER BY stgpool_name

VOLUME_NAME STGPOOL_NAME PCT_UTILIZED PCT_RECLAIM STATUS ACCESS

------------------ ------------------ ------------ ----------- ------------------ ------------------

256AFB NIGHTLY 12.4 87.5 FULL READWRITE

295AFB NIGHTLY 11.3 88.6 FULL READWRITE

...

Volumes in a specific storage pool with reclaimable space (%) greater than XX

tsm: SERVER1> SELECT volume_name,devclass_name,stgpool_name,pct_reclaim,pct_utilized FROM volumes -

WHERE pct_reclaim>80 AND stgpool_name='OFFSITE'

VOLUME_NAME DEVCLASS_NAME STGPOOL_NAME PCT_RECLAIM PCT_UTILIZED

------------------ ------------------ ------------------ ----------- ------------

tape11 LTO OFFSITE 99.9 0.0

tape84 LTO OFFSITE 85.0 15.0

tape86 LTO OFFSITE 90.3 9.6

tape90 LTO OFFSITE 90.3 9.6

...

Number of tapes per storage pool in the library

tsm: SERVER1> SELECT volumes.stgpool_name, count(*) FROM volumes, libvolumes WHERE -

volumes.volume_name=libvolumes.volume_name GROUP BY stgpool_name

STGPOOL_NAME Unnamed[2]

------------------ -----------

AIX_DAILY 338

AIX_ARCH1 22

...

Some information about volumes in the library

tsm: SERVER1> SELECT volume_name,devclass_name,stgpool_name,status,access,pct_utilized FROM volumes -

WHERE volume_name IN ( SELECT volume_name FROM libvolumes )

VOLUME_NAME DEVCLASS_NAME STGPOOL_NAME STATUS ACCESS PCT_UTILIZED

------------- ---------------- ---------------- ------------- ----------- ------------

R00001L3 3584 AIX_ARCH2 FILLING READWRITE 34.5

R00004L3 3584 NT_MONTHLY FULL READONLY 58.8

R00008L3 3584 NT_DAILY FULL READONLY 83.2

R00009L3 3584 AIX_ARCH1 FILLING READWRITE 10.5

...

Some information about volumes in the library - another way

tsm: SERVER1> SELECT volumes.volume_name, volumes.stgpool_name, volumes.pct_utilized, volumes.pct_reclaim, volumes.status, -

volumes.access FROM volumes, libvolumes WHERE volumes.volume_name=libvolumes.volume_name ORDER BY stgpool_name

VOLUME_NAME STGPOOL_NAME PCT_UTILIZED PCT_RECLAIM STATUS ACCESS

------------------ ------------------ ------------ ----------- ------------------ ------------------

290AFB AIX_DAILY 59.3 41.2 FILLING READWRITE

241AFB AIX_DAILY 59.8 40.1 FULL READWRITE

265AFB NT_MONTHLY 0.4 0.1 FILLING READWRITE

365AFB AIX_ARCH1 47.7 0.0 FILLING READWRITE

...