Tape location

[madunix]

I run the following sql statement
tsm: TSM1_SITEA_SERVER1>select volume_name from libvolumes where (volume_name not in (select volume_name from volumes where access<> 'offsite')) and LAST_USE is NULL and status<>'Scratch'

VOLUME_NAME
------------------
SDC009L3

tsm: TSM1_SITEA_SERVER1>

I listed the tapes inside library, it says this tape is private, actually i checked all my pools cant find the tape in any one of them.
(SDC009L3 Private 4,101 LTO LTO-3)


how can i find out which task/vol/stogepool belong to this Tape?

Thanks

 

[THE_WIPET]

is it a db backup?

q volh type=dbb

what is the result of
q vol?
q drm?
q cont XXXXXX?

 

[chad_small]

Check the volhist table for the tape.

Select * from volhistory where volume_name='<volname>'

If its not in the volume history or volumes table then it might not have been labeled correctly and TSM marked it private.

 

[madunix]

I ll check it tomorrow when i get back to office

 

[madunix]

q vol=
SDC000L3 Filling
SDC001L3 Full
SDC004L3 Filling
SDC005L3 Full
SDC006L3 Filling
SDC007L3 Filling
SDC008L3 Full
SDC011L3 Full
SDC013L3 Full
SDC014L3 Full
SDC015L3 Full
SDC016L3 Full
SDC017L3 Filling
SDC018L3 Filling
SDC020L3 Filling
SDC021L3 Filling
SDC022L3 Full
SDC055L3 Filling



q drm=
SDC017L3 Vault 02/01/2009 16:33:44
SDC019L3 Mountable 02/25/2009 07:00:20 SDC3582-LIB



Select * from volhistory where volume_name='SDC009L3'

DATE_TIME: 2008-11-24 18:53:46.000000
UNIQUE: 0
YPE: STGDELETE
BACKUP_SERIES:
BACKUP_OPERATION:
VOLUME_SEQ:
DEVCLASS: SDC-DEV-CLASS
VOLUME_NAME: SDC009L3
LOCATION:
COMMAND:

DATE_TIME: 2008-11-24 19:16:14.000000
UNIQUE: 0
TYPE: STGNEW
BACKUP_SERIES:
BACKUP_OPERATION:
VOLUME_SEQ:
DEVCLASS: SDC-DEV-CLASS
VOLUME_NAME: SDC009L3
LOCATION:
COMMAND:

DATE_TIME: 2008-11-24 19:34:25.000000
UNIQUE: 0
TYPE: STGDELETE
BACKUP_SERIES:
BACKUP_OPERATION:
VOLUME_SEQ:
DEVCLASS: SDC-DEV-CLASS
VOLUME_NAME: SDC009L3
LOCATION:
COMMAND:

DATE_TIME: 2008-12-15 12:22:17.000000
UNIQUE: 0
TYPE: STGNEW
BACKUP_SERIES:
BACKUP_OPERATION:
VOLUME_SEQ:
DEVCLASS: SDC-DEV-CLASS
VOLUME_NAME: SDC009L3
LOCATION:
COMMAND:

DATE_TIME: 2008-12-15 14:24:33.000000
UNIQUE: 0
TYPE: STGDELETE
BACKUP_SERIES:
BACKUP_OPERATION:
VOLUME_SEQ:
DEVCLASS: SDC-DEV-CLASS
VOLUME_NAME: SDC009L3
LOCATION:
COMMAND:

 

[rore]

Hi,
tape has not properly returned to scratch. Tape has no valid data.
Just do:
upd libvolume <your library name> SDC009L3 status=scratch

Hope this helps,
Rudy

 

[madunix]

Resolved.
yes rore absolute, moved correctly to scratch with upd....