Re: migration - when should it happen?
2002-08-29 12:05:16
to your second question here is your answer
select date(days(current_date)-1) as "DATE" , cast((cast(sum(summary.bytes)
as float) / 1024 / 1024) as decimal(10,2)) as MBytes , count(*) as
"CONNECTIONS" from summary where summary.activity='BACKUP' and start_time
>current_timestamp - 1 day
Kvedja/Regards
Petur Eythorsson
Taeknimadur/Technician
IBM Certified Specialist - AIX
Tivoli Storage Manager Certified Professional
Microsoft Certified System Engineer
peddi AT itn DOT is
Nyherji Hf Simi TEL: +354-569-7700
Borgartun 37 105 Iceland
URL: http://www.nyherji.is
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Coviello, Paul
Sent: 29. ágúst 2002 14:27
To: ADSM-L AT VM.MARIST DOT EDU
Subject: migration - when should it happen?
HI I have a 2 part question.
1. we currently have a controlled migration that happens at 10:00
am everyday. We have the following comand: update stgp backuppool
highmig=1 lowmig=0 migproc=3. We are getting complaints that the data
should stay on the disks the whole day for restorations. I was thinking
about pushing it out to 4:30. And then of course we have expiration and the
reclamations and the db backup. So what should be the order of these? We
have 30gb for our backuppool. which leads to the second question.
2. What command can I run to get the amount of data that was backed
up last night? in case we want to set it to 50 or something. I just
want to be able to control this so it does not effect the backups at night.
thanks
Paul
Paul J Coviello
Sr Systems Analyst
Catholic Medical Center
2456 Brown Ave
Manchester, NH 03103
603 663-5326
|
|
|