DRM Info....

DRM

Information about drm volumes

tsm: SERVER1> SELECT drmedia.volume_name, volumes.stgpool_name, drmedia.state, drmedia.voltype, volumes.status, -

volumes.pct_utilized FROM drmedia, volumes WHERE drmedia.volume_name=volumes.volume_name ORDER BY drmedia.state

VOLUME_NAME STGPOOL_NAME STATE VOLTYPE STATUS PCT_UTILIZED

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

tape06 OFFSITE COURIERRETRIEVE CopyStgPool EMPTY 0.0

tape18 OFFSITE VAULT CopyStgPool FILLING 50.6

tape38 OFFSITE VAULT CopyStgPool FILLING 80.9

tape79 OFFSITE VAULT CopyStgPool FILLING 91.0

...

Information about drm volumes in the library

tsm: SERVER1> SELECT drmedia.volume_name, drmedia.state, drmedia.voltype FROM drmedia, libvolumes WHERE -

drmedia.volume_name=libvolumes.volume_name ORDER BY voltype

VOLUME_NAME STATE VOLTYPE

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

tape48 MOUNTABLE CopyStgPool

tape59 MOUNTABLE CopyStgPool

...

Information about drm volumes in the library (another way)

tsm: SERVER1> SELECT volume_name, state, voltype FROM drmedia WHERE -

volume_name IN ( SELECT volume_name FROM libvolumes ) ORDER BY voltype

VOLUME_NAME STATE VOLTYPE

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

tape48 MOUNTABLE CopyStgPool

tape59 MOUNTABLE CopyStgPool

...

Information about drm volumes in the library with state different from "MOUNTABLE"

tsm: SERVER1> SELECT drmedia.volume_name, drmedia.state, drmedia.voltype FROM drmedia, libvolumes WHERE -

drmedia.volume_name=libvolumes.volume_name AND drmedia.state<>'MOUNTABLE'

VOLUME_NAME STATE VOLTYPE

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

tape36 COURIER CopyStgPool

tape82 COURIER CopyStgPool

...

Drm volumes with tsm db backups

tsm: SERVER1> SELECT volume_name, state, upd_date, location, voltype FROM drmedia -

WHERE voltype='DBBackup' OR voltype='DBSnapshot'

VOLUME_NAME STATE UPD_DATE LOCATION VOLTYPE

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

tape10 VAULT 2008-03-05 Iron Mountain DBBackup

11:00:00.000000

tape15 VAULT 2008-03-04 Iron Mountain DBBackup

11:00:00.000000

tape45 VAULT 2008-03-03 Iron Mountain DBBackup

...