Useful TSM SQL querries

Problem(Abstract)
In administering a TSM server, it may be necessary to run select commands to determine volume issues.

Resolving the problem
The following list of select statements are useful when troubleshooting problems with storage pool volumes.

1) To determine what volumes are unavailable:

select volume_name, access from volumes where access='UNAVAILABLE

Note: You can also run the query vol access=unavailable command

2) To examine how many volumes have more than 2 write errors:

select volume_name, write_errors from volumes where write_errors >2

3) To examine which volume have read errors:

select volume_name, read_errors from volumes where read_errors >0

4) To determine if volume(s) have an error state other than "NO":

select volume_name, error_state from volumes where error_state !='NO'