Re: Select Statement
2001-09-28 15:29:58
>select sum(physical_mb)/1024 as GBytes from occupancy
GBYTES
--------------------
1294.32
1294.32
>select sum(num_files) as Files from occupancy
FILES
---------
1995091
1995091
But you may want to subtotal by backup vs archive, storage pool etc.
NODE_NAME, TYPE, FILESPACE_NAME, STGPOOL_NAME, NUM_FILES, PHYSICAL_MB,
LOGICAL_MB
> -----Original Message-----
> From: Joshua S. Bassi [mailto:jbassi AT IHWY DOT COM]
> Sent: Friday, September 28, 2001 6:01 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Select Statement
>
>
> Thanks for the responses. This query should not be per node
> but per storage
> pool. In a nutshell, I want to determine how much data TSM
> is managing for
> 5 TSM servers. Once I have this query figured out, I will
> use a script I
> created to login to all 5 RS6K SP TSM server nodes and find
> out the total
> storage each one has.
>
> Tonight we are making a drastic change to the number of
> versions maintained
> and after I run expiration, I am going to run the query again
> to see how
> much space we recovered.
>
>
> --
> Joshua S. Bassi
> Independent IT Consultant
> IBM Certified - AIX/HACMP, SAN, Shark
> Tivoli Certified Consultant- ADSM/TSM
> Cell (408)&(831) 332-4006
> jbassi AT ihwy DOT com
>
> -----Original Message-----
> From: Hervé CHIBOIS [mailto:herve.chibois AT orness DOT fr]
> Sent: Friday, September 28, 2001 11:35 AM
> To: jbassi AT IHWY DOT COM
> Subject: Re: Select Statement
>
>
> Hi Josh
>
> I need more precisions to give you the right macro :
>
> you want the total amount of data, for a particular NODE ? for night
> sessions (scheduled) ?
>
> Here are some output of personnal macros
>
> Node occupancy
> -----------------
> NODE_NAME PHYSICAL_MB
> NUM_FILES
> ------------------ ---------------------------------
> -----------
> DONALD 1358.59
> 38578
> PICSOU 1171.28
> 22590
> NESTOR 1091.81
> 79563
>
>
> Night sessions
> --------------
> NODE_NAME DATE ACTIVITY START
> END MEGABYTES
> FILES SUCCESSFUL
> ------------------ ---------- ---------- --------
> -------- --------- -
> -------- ------------------
> NESTOR 2001-09-28 BACKUP 09:49:37
> 11:50:39 346
> 16553 YES
> DONALD 2001-09-28 BACKUP 09:51:43
> 09:53:55 171
> 2333 YES
>
>
> ----- Original Message -----
> From: "Joshua S. Bassi" <jbassi AT IHWY DOT COM>
> To: <ADSM-L AT VM.MARIST DOT EDU>
> Sent: Friday, September 28, 2001 11:17 PM
> Subject: Select Statement
>
>
> > All,
> >
> > I am looking for a select statement that will enable me to
> determine the
> > total amount of
> > data backed up (disk and tape). I know I can use 'select *
> from stgpools'
> > and see 1) est_capacity_mb and 2) the pct_utilized. Is there an SQL
> > function where I can do the math and get the 1) capacity
> used for each
> > stgpool and 2) capacity used for all stgpools.
> >
> >
> >
> > --
> > Joshua S. Bassi
> > Independent IT Consultant
> > IBM Certified - AIX/HACMP, SAN, Shark
> > Tivoli Certified Consultant- ADSM/TSM
> > Cell (408)&(831) 332-4006
> > jbassi AT ihwy DOT com
> >
>
|
<Prev in Thread] |
Current Thread |
[Next in Thread> |
- Re: Select Statement, (continued)
- Re: Select Statement, Alan Davenport
- Re: Select Statement, Guan, Phillip
- Select Statement, Matthew Large
- Re: Select Statement, Alan Davenport
- Re: Select Statement, Ford, Phillip
- Re: Select Statement, PINNI, BALANAND (SBCSI)
- Select Statement, Joshua S. Bassi
- Re: Select Statement, Joshua S. Bassi
- Re: Select Statement,
Richard Cowen <=
|
|
|