A small script to issue the appropriate "MOVE DATA" commands may be easier
to control than auto migration.
Foreach stgpool where device_class_name=DISK and stgpool_type=PRIMARY
foreach volume where pct_utilized > 50 and stgpool_name=<$stgpool>
move data <$volume_name> to <next_stgpool>
example: (on unix, grep for MOVE, munge out the extra spaces and send thru a
dsmadmc command.)
select 'MOVE DATA ', volume_name as
"--------------------------------------------------------", -
'STGPOOL=', nextstgpool, 'WAIT=YES' from volumes, stgpools -
where stgpools.stgpool_name=volumes.stgpool_name and
stgpools.stgpool_name in -
(select stgpool_name from volumes -
where volume_name in -
(select volume_name -
from volumes where pct_utilized>50 and stgpool_name
in -
(select stgpool_name from stgpools where
pooltype='PRIMARY' and devclass='DISK') -
) -
)
output:
Unnamed[1] --------------------------------------------------------
Unnamed[3] NEXTSTGPOOL Unnamed[5]
---------- --------------------------------------------------------
---------- ------------------ ----------
MOVE DATA /opt/tivoli/tsm/server/bin/sbkup00.dsm
STGPOOL= LTOPOOL WAIT=YES
MOVE DATA /tsmdata1/datavol3
STGPOOL= LTOPOOL WAIT=YES
MOVE DATA /usr/local/tsm/datavol01.dsm
STGPOOL= LTOPOOL WAIT=YES
MOVE DATA /usr/local/tsm/datavol02.dsm
STGPOOL= LTOPOOL WAIT=YES
> -----Original Message-----
> From: Jonathan Aberle [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 04, 2002 1:11 PM
> To: [EMAIL PROTECTED]
> Subject: Migration/storage pool backup ?'s
>
>
> Hello,
>
> I am experiencing some problems with migration and storage pool backups.
My situation is that I have a small disk storage pool that is primarily used
for oracle archive logs that archive at any time during the day. During
the hours of 6-12, we perform offsite copies of the tape and disk storage
pools.
> During this time, no tape drives are available for client backups so I
need to make sure that the disk storage pool is completely migrated to tape
prior to starting the offsite copies. Here is what I do:
