Hi all,

The following SQL gives me a wrong result for the column NB_VOLUMES :


tsm: TSM>select stgpool_name,maxscratch,est_capacity_mb,pct_utilized, -
cont> (select count(*) from volumes where
stgpool_name=stgpools.stgpool_name) as NB_VOLUMES -
cont> from stgpools -
cont> where devclass <> 'DISK' -
cont> order by stgpool_name

STGPOOL_NAME            MAXSCRATCH          EST_CAPACITY_MB     PCT_UTILIZED
NB_VOLUMES
------------------     -----------     --------------------     ------------
-----------
ARCH2004                        15                5722020.0              4.2
2
COP2004                         30               11444040.0              2.1
2
COPYPOOL                        50               19073400.0              4.2
2
POOLBAND                        10                3869329.7             11.2
2
POOLSTA                         15                5722020.0              6.9
2

tsm: TSM>select stgpool_name,count(*) from volumes group by stgpool_name

STGPOOL_NAME            Unnamed[2]
------------------     -----------
ARCH2004                         2
COP2004                          5
COPYPOOL                         8
POOLBAND                         2
POOLDISK                         4
POOLSTA                          4

I do not understand why. Did I miss something here ?

Any suggestion will be very appreciated.

Thanks in advance.