hi, on the first tought i presume it has something to do with "where backup_end>'2005-08-28 00:00:00.000000' " part .. since in query without this condition the kb filespace is showing themself huh?
goran ----- Original Message ----- From: "Henrik Wahlstedt" <[EMAIL PROTECTED]> To: <ADSM-L@VM.MARIST.EDU> Sent: Thursday, October 06, 2005 10:01 AM Subject: select from filespaces 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.
