SQL command for listing volumes which were not in drm and libv

[akilap]

Hi..
Wishes.. I would like to know.. is there any SQL command for listing out the volumes which were not in drm,libv and vol.. given a list of volumes in a file..

 

[toxy13]

show slots [libraryname]

Status=allocated means tape is used (drm/vol/libv)
Status=full means tape is in the library bur not used for anything!

 

[akilap]

I wont be able to check via tht command.. since mine is 3494 library.. when i issue tht cmd.. im getting the below error message..

ANS8000I Server command: 'show slots 3494XX'
PVR slot information for library 3494XX.
Library not SCSI.

I have some list of volumes in a file.. i just want to check whether any volume in tht file is not in drm & libv & vol.. if any i want to list out those volumes alone..

 

[toxy13]

I wont be able to check via tht command.. since mine is 3494 library.. when i issue tht cmd.. im getting the below error message..

ANS8000I Server command: 'show slots 3494XX'
PVR slot information for library 3494XX.
Library not SCSI.

I have some list of volumes in a file.. i just want to check whether any volume in tht file is not in drm & libv & vol.. if any i want to list out those volumes alone..

yes right, the command only works with scsi libraries ....

ok, you want an output from all tapes which are in the libray but checked in, defined and so on?

please check the quicks facts from richard sims for your 3494 library, i think you can query it with:

3494, list all tapes 'mtlib -l /dev/lmcp0 -qI'
(or use options -vqI for verbosity, for
more descriptive output)

there are many more informations about ;-)

 

[akilap]

Thanks for your reply.. I have scripts for checkin and checkout list generation and for checkin and checkout,,, but some tapes were not returning onsite from offsite.. not sure where the problem resides.. so i will ask the list from offsite data centre.. and compare with drm,libv and vol.. the volumes which were not in drm,libv,vol .. i will call thm onsite manually.. so for tht i m in need of a sql command..

 

[umur]

when I issue "show slots libname" I see some tapes who doesn't have their barcodes:

Slot 17, status Allocated, element number 1042, barcode not present, barcode value <>, devT=LTO, mediaT=417, elemT=ANY

However, when I check element number 1042 from library, I see a volume that has a barcode and it's used by TSM. What does this mean? Should I re-label them?

Thanks

 

[toxy13]

umur: how akilap says: it's not a scsi library ... sh slots doesn't work