Hi guys!
I have some weird output from one of my SQL statements. Here it's is:
select count(*) from libvolumes where status='Private'
Unnamed[1]
3698
Ok, so 3698 private volumes on this server. Now, how many contain data:
select count(*) from libvolumes where status='Priva
Hi,
Select with last_use = ‘Data’ is not correct. If you checkout and when
checkin tapes the parameter last_use can be lost.
If you want to check private tapes without the data, try to use select
like this:
select volume_name from libvolumes where status='Private' and last_use
is NULL and volume_n
Eric van Loon
AF/KLM Storage Engineering
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Efim
Sent: vrijdag 21 november 2014 13:41
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Weird SQL output
Hi,
Select with last_use = ‘Data’ is not correct. If you checkout and wh
kis/home/wiki/Tivoli%20Storage%20Manager
"ADSM: Dist Stor Manager" wrote on 2014-11-21
08:02:09:
> From: "Loon, EJ van (ITOPT3) - KLM"
> To: ADSM-L@VM.MARIST.EDU
> Date: 2014-11-21 08:03
> Subject: Re: Weird SQL output
> Sent by: "ADSM: Dist Stor Manager&q
%20Storage%20Manager
- Forwarded by Andrew Raibeck/Hartford/IBM on 2014-11-21 08:13 -
Andrew Raibeck/Hartford/IBM wrote on 2014-11-21 08:12:33:
> From: Andrew Raibeck/Hartford/IBM
> To: "ADSM: Dist Stor Manager"
> Date: 2014-11-21 08:12
> Subject: Re: Weird SQL o
es contain the backupset volumes.
> Kind regards,
> Eric van Loon
> AF/KLM Storage Engineering
>
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Efim
> Sent: vrijdag 21 november 2014 13:41
> To: ADSM-L@VM.MARIST.EDU
>
ARIST.EDU] On Behalf Of Efim
Sent: vrijdag 21 november 2014 17:41
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Weird SQL output
Erik,
I can't believe that you're never checkin private tapes.
After checked in last_use is NULL. It is not an issue. It just tell that nobody
use this tape after it