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 [EMAIL PROTECTED] Nyherji Hf Simi TEL: +354-569-7700 Borgartun 37 105 Iceland URL: http://www.nyherji.is -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Coviello, Paul Sent: 29. �g�st 2002 14:27 To: [EMAIL PROTECTED] 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
