Yeap, ....or BACKUP_END is null.... makes life more comfortable...
select node_name, sum((capacity * pct_util)/100/1024) "Total GB" from
filespaces where -
cont> (backup_end>'2005-08-28 00:00:00.000000' or BACKUP_END is null)
group by node_name
//Henrik
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
goc
Sent: den 6 oktober 2005 10:12
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: select from filespaces
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" <SHWL AT STATOIL DOT COM>
To: <ADSM-L AT VM.MARIST DOT 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.
-------------------------------------------------------------------
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.
|