ADSM-L

Re: differences in between version 4 and 5 in the SQL database

2002-09-18 12:42:43
Subject: Re: differences in between version 4 and 5 in the SQL database
From: Zlatko Krastev/ACIT <acit AT ATTGLOBAL DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 18 Sep 2002 19:35:11 +0300
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

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