It may be worth your while to setup a server command script. We defined one as Q_TAPE
that runs the following commands. Now we get a fairly detailed look into our tape
situation by simply entering RUN Q_TAPE
select access as "Access (All Tapes)", count(*) as "# Tapes" from volumes where
devclass_name='3590' group by access
select status as "Status (Tapes in 3494)", count(*) as "# Tapes" from libvolumes group
by status
select stgpool_name as "StgPool Name", status as "Status", count(*) as "# Tapes" from
volumes where devclass_name='3590' group by stgpool_name, status
select stgpool_name as "Private StgPools", count(*) as "# Empty Tapes" from volumes
where status='EMPTY' and devclass_name='3590' group by stgpool_name
select volume_name as "Empty Tapes", stgpool_name as "StgPool" from volumes where
status='EMPTY' and devclass_name='3590'
select volume_name as "Scratch Tapes" from libvolumes where status='Scratch'
q vol dev=3590
Sample output:
Access (All Tapes) # Tapes
------------------ -----------
OFFSITE 62
READONLY 1
READWRITE 187
Status (Tapes in 3494) # Tapes
---------------------- -----------
Private 193
Scratch 13
StgPool Name Status # Tapes
------------------ ------------------ -----------
3590COL EMPTY 19
3590COL FILLING 86
3590COL FULL 52
DRM FILLING 12
DRM FULL 49
DRM PENDING 1
MAILTAPE FILLING 2
MAILTAPE FULL 20
ORATAPEAPPS FILLING 1
ORATAPEAPPS FULL 1
ORATAPEDB FILLING 1
ORATAPEDB FULL 1
ORATAPELOGS FILLING 1
WEEKLYTAPEDB FILLING 2
WEEKLYTAPEDB FULL 2
Private StgPools # Empty Tapes
------------------ -------------
3590COL 19
Empty Tapes StgPool
------------------ ------------------
300009 3590COL
300149 3590COL
300155 3590COL
300156 3590COL
300168 3590COL
300169 3590COL
300187 3590COL
300189 3590COL
300191 3590COL
300193 3590COL
300194 3590COL
300195 3590COL
300201 3590COL
300202 3590COL
300203 3590COL
300205 3590COL
300207 3590COL
300208 3590COL
300209 3590COL
Scratch Tapes
------------------
310010
310013
310016
310017
310018
310033
310037
310040
310042
310046
310093
310100
310154
Volume Name Storage Device Estimated Pct Volume
Pool Name Class Name Capacity Util Status
(MB)
------------------------ ----------- ---------- --------- ----- --------
300000 3590COL 3590 29,337.8 100.0 Full
300001 3590COL 3590 25,280.2 58.0 Full
300003 3590COL 3590 21,974.7 95.4 Filling
300004 3590COL 3590 61,919.1 68.3 Full
300005 3590COL 3590 26,768.9 80.9 Full
300006 3590COL 3590 10,000.0 37.4 Filling
300007 3590COL 3590 10,000.0 13.0 Filling
300008 3590COL 3590 26,142.4 89.2 Full
300009 3590COL 3590 0.0 0.0 Empty
300011 3590COL 3590 20,000.0 26.1 Filling
300012 3590COL 3590 27,162.4 73.4 Full
300013 3590COL 3590 143,697.2 100.0 Filling
etc, etc.
Steve Schaub
Haworth, Inc
email: [EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 02/23 11:13 AM >>>
What would the syntax be for a query to only show scratch volumes?
