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:[email protected]] On Behalf Of
leandro benatti
Sent: dinsdag 24 mei 2011 15:57
To: [email protected]
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 [email protected] via Backup Central.
|Forward SPAM to [email protected].
+----------------------------------------------------------------------
