hehe yes of course Zlatko, how could I have been so stupid :-/
sorry guys. 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 Zlatko Krastev/ACIT Sent: 18. september 2002 16:35 To: [EMAIL PROTECTED] Subject: Re: differences in between version 4 and 5 in the SQL database Petur, check at which fix are you in v5.1. Maybe you missed it but there is a problem with summary table not filled. And you have to check why "sum(summary.bytes)" is more than 0 :-() Zlatko Krastev IT Consultant Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: differences in between version 4 and 5 in the SQL database Hello there friends :-) This has been buggin me the last week. There have been some changes in the database since it became version 5 I have a script that shows the total amount of data sent over last night. the output is like this in version 4.x and 3.x NODE NAME DOMAIN PLATFORM MBYTES CONECTIONS ------------------ ------------------ ---------------- --------- --- ----------- BAUG_CDB2 REKSTRAR DB2 12360.93 4 FINGRANDI REKSTRAR WinNT 8789.06 3 ok this is what happens when I run the command in version 5. NODE NAME DOMAIN PLATFORM MBYTES CONECTIONS ------------------ ------------------ ---------------- --------- --- ----------- URDUR VID WinNT 1909.65 1 PERLAN VID WinNT 1446.82 1 there is something wrong with this picture, I have around 40 clients on this site and they either don't show up or they show only one connection to the database, when I know that there has been more connections. this is the script I am using for this task. select summary.entity as "NODE NAME", nodes.domain_name as "DOMAIN", nodes.platform_name as "PLATFORM", cast((cast(sum(summary.bytes) as float) / 1024 / 1024) as decimal(10,2)) as MBYTES , count(*) as "CONECTIONS" from summary ,nodes where summary.entity=nodes.node_name and summary.activity='BACKUP' and start_time >current_timestamp - 1 day group by entity, domain_name, platform_name order by MBytes desc here it is again: select summary.entity as "NODE NAME", nodes.domain_name as "DOMAIN", nodes.platform_name as "PLATFORM", cast((cast(sum(summary.bytes) as float) / 1024 / 1024) as decimal(10,2)) as MBYTES , count(*) as "CONECTIONS" from summary ,nodes where summary.entity=nodes.node_name and summary.activity='BACKUP' and start_time >current_timestamp - 1 day group by entity, domain_name, platform_name order by MBytes desc Ok I know there are some great SQL guys out there, like Paul Seay and other SQL gurus. Can someone tell me why I am getting this so wrong? 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
