ADSM-L

differences in between version 4 and 5 in the SQL database

2002-09-18 12:17:11
Subject: differences in between version 4 and 5 in the SQL database
From: Pétur Eyþórsson <peddi AT ITN DOT IS>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 18 Sep 2002 16:08:00 -0000
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

<Prev in Thread] Current Thread [Next in Thread>