I have about 100 tapes. My tape library holds only 10 tapes.
How do you decide which tapes to load into the library? What strategy do
you use?
Here is what I came up with.
For simplicity, all my tapes are in a single pool. I'm guessing I want
the tapes with the oldest LastWritten value. Something like this:
SELECT mediaid, volumename, slot, volstatus, lastwritten
FROM media
WHERE mediatype = 'DLT'
AND volstatus in ('Append', 'Full')
ORDER BY volstatus, lastwritten ASC
LIMIT 20;
That gives me:
mediaid | volumename | slot | volstatus | lastwritten
---------+----------------+------+-----------+---------------------
268 | DGG441 | 8 | Append |
269 | DGG471 | 9 | Append |
270 | DGG465 | 10 | Append |
267 | DGG457 | 7 | Append |
263 | DGG443 | 3 | Append |
266 | DGG442 | 6 | Append |
265 | DGG469 | 5 | Append |
264 | DGG467 | 4 | Append |
262 | DGG472 | 1 | Append |
100 | DLT7000-001111 | 0 | Full | 2008-12-07 14:03:20
101 | DLT7000-JYN220 | 0 | Full | 2008-12-17 08:16:41
102 | DLT7000-JYN221 | 0 | Full | 2009-01-04 07:12:47
103 | DLT7000-JYN231 | 0 | Full | 2009-01-10 07:22:38
105 | DLT7000-JYN225 | 0 | Full | 2009-02-01 08:44:52
107 | DLT7000-JYN232 | 0 | Full | 2009-03-01 14:44:50
108 | DLT7000-JYN233 | 0 | Full | 2009-03-24 13:16:00
109 | DLT7000-JYN234 | 0 | Full | 2009-04-05 09:49:51
110 | DLT7000-JYN236 | 0 | Full | 2009-04-16 12:20:04
117 | DLT7000-JYN245 | 0 | Full | 2009-06-13 06:11:52
119 | DLT7000-JYN247 | 0 | Full | 2009-06-23 06:28:06
--
Dan Langille -- http://langille.org/
------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
