Re: Report Writing Tools, or Business Intelligence, and the TSMer

2010-11-13 Thread Nick Laflamme
On Nov 12, 2010, at 1:02 AM, Roger Deschner wrote: > I've been using SPSS for this purpose for some time, I love Roger's sense of humor. He knows I used to install SPSS and SAS under VM in academia, where PhD candidates in several disciplines learn how to use SPSS or SAS to crunch numbers in pu

Re: Elapse time format incorrect in V6

2010-11-13 Thread Maurice van 't Loo
substr(cast(end_time-start_time as varchar(17)),3,8) as elapsed, - Replace this part with: end_time-start_time as elapsed, - so you can see what part of the output you need to cut. Regards, Maurice van 't Loo TSM Freelancer 2010/11/13 Robert Ouzen : > Hi > > I try to figure how to calculate t

Re: De-dup ratio's

2010-11-13 Thread Maurice van 't Loo
Heey David, Dedup ratio's depend very much on type of data and how many copies of DB backups you save. Like if you have a very big database filled with plain text only and save 30 uncompressed full backup versions of it, the dedup ratio shall be around 30:1 But for a media server filled with uniq

Elapse time format incorrect in V6

2010-11-13 Thread Robert Ouzen
Hi I try to figure how to calculate the elapse time of my backups in version6 , my old script V5 give me the correct output in the V6 the format is incorrect. The script below: Select substr( entity,1,15) as nodename, - date(start_time) as "Date (D/M/Y)", - time(start_time) as time, -

Re: De-dup ratio's

2010-11-13 Thread Amos ADSM
Jim, My DD is Configured as VTL, also my PT is configured as VTL, with Clariion (Sata Disks), with the PT i managed to reach 150 MBs, while with th DD (670) i managed to reach 740 MBs ( Read and write), while in backup i get 450 MBs (From one TSM server, and another 350 MBs from the second), and