ADSM-L

Re: select from filespaces

2005-10-06 05:05:20
Subject: Re: select from filespaces
From: Henrik Wahlstedt <SHWL AT STATOIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 6 Oct 2005 11:05:01 +0200
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.

<Prev in Thread] Current Thread [Next in Thread>