ADSM-L

After upgrade to 5.1.6.0 I get different results from SQL query

2003-05-06 09:42:27
Subject: After upgrade to 5.1.6.0 I get different results from SQL query
From: Niklas Lundstrom <niklas.lundstrom AT FORENINGSSPARBANKEN DOT SE>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 6 May 2003 09:47:42 +0200
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>
  • After upgrade to 5.1.6.0 I get different results from SQL query, Niklas Lundstrom <=