Hi,
I got this odd reslut when I do a select from filespaces on a Win2k TSM
server, 5.2.2.5.
select node_name, sum((capacity * pct_util)/100/(1024) as "Total GB"
from filespaces where backup_end>'2005-08-28 00:00:00.000000' group by
node_name
NODE_NAME Total GB
------------------ ---------------------------------
KBH-DB01 7.42
select node_name,filespace_name, (capacity * pct_util)/100/1024 as
"Total GB" from filespaces where backup_end>'2005-08-28 00:00:00.000000'
NODE_NAME FILESPACE_NAME
Total GB
------------------ ------------------
---------------------------------
KBH-DB01 /
2.24
KBH-DB01 /boot
0.02
KBH-DB01 /dbarch
0.26
KBH-DB01 /dump
1.84
KBH-DB01 /prog
3.06
select node_name, filespace_name, capacity, pct_util from filespaces
NODE_NAME FILESPACE_NAME CAPACITY
PCT_UTIL
------------------ ------------------ --------------------
--------------------
KBH-DB01 / 62124.3
3.7
KBH-DB01 /boot 192.9
12.9
KBH-DB01 /db 68353.1
74.7
KBH-DB01 /dbarch 16734.1
1.6
KBH-DB01 /dump 8533.9
22.1
KBH-DB01 /prog 34527.1
9.1
And usning a calulator......
2299
-
51059
268
1886
3142
=58564
Why doesnt TSM also use KBH-DB01/db in its calculation.
Any thoughts?
//Henrik
-------------------------------------------------------------------
The information contained in this message may be CONFIDENTIAL and is
intended for the addressee only. Any unauthorised use, dissemination of the
information or copying of this message is prohibited. If you are not the
addressee, please notify the sender immediately by return e-mail and delete
this message.
Thank you.
|