ADSM-L

Re: [ADSM-L] Select works in 5.5 but not in 6.x

2011-05-25 10:10:51
Subject: Re: [ADSM-L] Select works in 5.5 but not in 6.x
From: Richard van Denzel <RDenzel AT SLTN DOT NL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 25 May 2011 15:19:46 +0200
It appears to be working on AIX 6.1 and TSM Server 6.2.2.30

tsm: TSM_TSSC>select ENTITY,cast(float(sum(bytes))/1024/1024/1024 as
decimal(14,
2)) from summary where (start_time between '2011-04-23 00:00:00' and
'2011-05-22
 23:59:59') and (summary.activity='BACKUP' or
summary.activity='ARCHIVE') group
by ENTITY

    ENTITY: AIX6
Unnamed[2]: 1.12

    ENTITY: OPENPOWER710
Unnamed[2]: 0.56

    ENTITY: SVCMAN
Unnamed[2]: 2.87

    ENTITY: TPCMAN
Unnamed[2]: 12.66

    ENTITY: TSM1
Unnamed[2]: 4.47

    ENTITY: TSSC_DC
Unnamed[2]: 6.08

    ENTITY: WKS00531
Unnamed[2]: 21.38


tsm: TSM_TSSC>

Met vriendelijke groet, 
Richard van Denzel

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
leandro benatti
Sent: dinsdag 24 mei 2011 15:57
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Select works in 5.5 but not in 6.x

Hi all,

Try use the command line:

select ENTITY,cast(float(sum(bytes))/1024/1024/1024 as decimal(14,2))
from summary where (start_time between '2011-04-23 00:00:00' and
'2011-05-22 23:59:59') and (summary.activity='BACKUP' or
summary.activity='ARCHIVE') group by ENTITY

+----------------------------------------------------------------------
|This was sent by leandro.benatti AT tivit.com DOT br via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------

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