Re: After upgrade to 5.1.6.0 I get different results from SQL que ry
2003-05-06 09:25:53
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
|
|
|