ADSM-L

Re: After upgrade to 5.1.6.0 I get different results from SQL que ry

2003-05-06 09:25:53
Subject: Re: After upgrade to 5.1.6.0 I get different results from SQL que ry
From: Niklas Lundstrom <niklas.lundstrom AT FORENINGSSPARBANKEN DOT SE>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 6 May 2003 12:33:16 +0200
OK, but in 5.1.6.0 I don't get any data at all in the bytes column, only 0, 

-----Original Message-----
From: Lambelet,Rene,VEVEY,GL-CSC [mailto:Rene.Lambelet AT NESTLE DOT COM] 
Sent: den 6 maj 2003 09:56
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: After upgrade to 5.1.6.0 I get different results from SQL que
ry


Hi, rel 4.2 had incorrect data in the summary table,

                René LAMBELET
                NESTEC  SA
                GLOBE - Global Business Excellence
                Central Support Center
                Information Technology
                Av. Nestlé 55  CH-1800 Vevey (Switzerland) 
                tél +41 (0)21 924 35 43   fax +41 (0)21 703 30 17   local
K4-404
                mailto:rene.lambelet AT nestle DOT com


-----Original Message-----
From: Niklas Lundstrom [mailto:niklas.lundstrom AT FORENINGSSPARBANKEN DOT SE]
Sent: Tuesday,6. May 2003 09:48
To: ADSM-L AT VM.MARIST DOT EDU
Subject: After upgrade to 5.1.6.0 I get different results from SQL query


After an upgrade to 5.1.6.0 from 4.2.0.0 the result from: 
select entity,sum(bytes) from summary where (activity='BACKUP' or
activity='ARCHIVE') and cast((current_timestamp-end_time)hours as
decimal)<24 group by entity is different, most nodes shows 0 bytes, when I
ran 4.2.0.0 no nodes showed 0 bytes.
 
ENTITY                                        Unnamed[2]
------------------     ---------------------------------
DP4ARS                                                 0
DP4CD1                                                 0
DP4EIPA                                                32490179
DP4ELVATST                                         561057
DP4ELVAWEB1                                     41399091
DP4INST                                                0
DP4LEVAWEB1                                     23354107
DP4LEVAWEB2                                     24777341
DP4MSTR                                              0
DP4MSTRWEB                                      38215277
DP4NICE                                                0
DP4OLF                                                 2078924907
 
I am running 5.1.6.0 on Z-os 1.3
 
 
 
 
Mvh
Niklas Lundström
Föreningssparbanken IT
08-58595164
 

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