Hello Mark !
That command works well, but I need the tapes where only the backupactive
data is on.
Oli
"Stapleton, Mark"
<[EMAIL PROTECTED]
ERBEE.COM> An
Gesendet von: [EMAIL PROTECTED]
"ADSM: Dist Stor Kopie
Manager"
<[EMAIL PROTECTED] Thema
.EDU> Re: Export Nodes which Tape di I
need
06.05.2004 15:03
Bitte antworten
zu
"ADSM: Dist Stor
Manager"
<[EMAIL PROTECTED]
.EDU>
Kundennr.:
>From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf
Of
>Oliver Martin
>>I have more tapes than my library has slots and that is why I must
>checkin libv during the process export node, filedata=backupactive, I
do >>every weekend. When I do an preview export node I there is no
option which
>>tells me which tapes the export needs for completition.
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Stapleton, Mark
>select distinct volume_name from volumeusage where
>node_name='DESIRED_NODE'
>
>(The node name must be in single quotes and capitalized.)
Let me correct that command:
select distinct volume_name from volumeusage where
node_name='DESIRED_NODE' and stgpool_name='PRIMARY_TAPE_STORAGE_POOL'
This way, you'll only see the volume names from the primary (in-library)
storage pool.
--
Mark Stapleton
