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" <ADSM-L AT VM.MARIST DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
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
peddi AT itn DOT is
Nyherji Hf Simi TEL: +354-569-7700
Borgartun 37 105 Iceland
URL: http://www.nyherji.is
|