Hi Josef,

Maybe you could make good use of one of those (undocumented) commands :

Show library : shows all libraries and drives and their characteristics,
including drive state
Show asq: shows mount point queue
Show asm : shows mounted (or mount in progress) volumes

Hope this helped !

Arnaud Brion

***********************************************************************
Panalpina Management Ltd., Basle, Switzerland, CIT Department
Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone:  +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: arnaud.brion AT panalpina DOT com
***********************************************************************




-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Jozef Zatko
Sent: Tuesday, 23 March, 2004 9:18
To: ADSM-L AT VM.MARIST DOT EDU
Subject: How to block tape drive?


Hello guys,
can somebody help me with following problem?
I need to backup Oracle database (many of them) using b/a TSM client by
putting Oracle into backup mode and backup all Oracle data files.
Because of activity on Oracle database, before putting Oracle database
into backup mode, I need to be sure that I have available tape drive for
backup (backup will be done LAN-free using TSM STA). My idea is to use
script, which will select empty (or available, ie. loaded but not used -
idle) drives from drives table using select command and then put one of
them to offline until I have Oracle in backup mode, and then put this
drive back to online just before backup starts. My problem is that from
drives table it is not possible to get enough information about state
and activity of the drive. There is only information whether drive is
loaded or not. Using "q mount" command I can get also information
whether drive is "in use" or "idle". Is it possible to get this
information also using some select command? Or any other ideas?

Many thanks

Ing. Jozef Zatko
Login a.s.
Dlha 2, Stupava
tel.: (421) (2) 60252618