umbers listed above. Thank you.
**
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Anders
Räntilä
Sent: Monday, December 11, 2017 10:30 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Select statement for deduplication & co
Hi
This is simple math
select
stgpool_name,DEDUP_SPACE_SAVED_MB/(DEDUP_SPACE_SAVED_MB+COMP_SPACE_SAVED_MB+(EST_CAPACITY_MB*PCT_UTILIZED/100))*100||'%'
as "Dedup savings" from stgpools
select
stgpool_name,COMP_SPACE_SAVED_MB/(COMP_SPACE_SAVED_MB+(EST_CAPACITY_MB*PCT_UTILIZED/100))*100||'%'
Hi All,
Simple question : did any of you succeeded in building a query that would
provide accurate statistics on deduplication and compression factors for the
new TSM directory-based pools ?
I would simply get following :
Stgpool name, space that would be used without dedup & compression, dedu
Hi all,
I tried to sum up the size of archive / backup sizes using the backup/archives
table joined with backup_objects/archive_objects, but the results are not
plausible.
My queries:
SELECT CAST(FLOAT(SUM(bo.bfsize))/1024/1024/1024 as DEC(14,1)) as size_gb FROM
backups b, backup_objects bo
s Prof. Sr.
TSM Delivery Architect
IBM Cloud
(918) 493-4678
From: Efim
To: ADSM-L@VM.MARIST.EDU
Date: 04/11/2016 08:20 AM
Subject:Re: Select statement for client occupancy by management
class...???
Sent by:"ADSM: Dist Stor Manager"
Do you use different s
es anyone have a select statement for client occupancy by management
> class (so I don't have to recreate the wheel)?
>
>
> Dwight E. Cook
> Technical Services Prof. Sr.
> TSM Delivery Architect
> IBM Cloud
> (918) 493-4678
Does anyone have a select statement for client occupancy by management
class (so I don't have to recreate the wheel)?
Dwight E. Cook
Technical Services Prof. Sr.
TSM Delivery Architect
IBM Cloud
(918) 493-4678
AND BACKUP_DATE < '2015-02-01' AND FILESPACE_NAME NOT LIKE '%$%' GROUP
BY NODE_NAME
Bruce Kamp
TSM Administrator
(817) 568-7331
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Hanover, Cameron
Sent: Tuesday, Marc
This probably isn't completely right, but it might be a start:
select node_name,hl_name,min(backup_date) from backups group by
node_name,hl_name
--
Cameron Hanover
chano...@umich.edu
"Let's get dangerous."
--Darkwing Duck
On Mar 9, 2015, at 3:42 PM, Kamp, Bruce (Ext) wrote:
> I am found a co
Bruce,
You could do a group by node_name at the end of your select statement.
Best Regards,
_
email: ron.delaw...@us.ibm.com
Storage Services Offerings
From: "Kamp, Bruce (Ext)"
To: ADSM-L@VM.MARIST.EDU
Date: 03/0
I am found a couple TDP SQL nodes that aren't inactivating there backups so TSM
isn't expiring them...
What I am trying to find is the oldest backup date for each server with a name
like _TDP.
I can get this:
Node Name HL_NAME
B
d to write a select statement that
> will produce a bunch of message found in the actlog. The problem I am
> having is grabbing the data from the last 24 hours.. I will schedule this
> to produce an email each day.. Any thoughts on how to construct this
>
> Thank you
>
> SEL
] On Behalf Of Rick
Saylor
Sent: Tuesday, June 24, 2014 3:19 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select Statement Help
James,
What version of TSM? Your select statement will work in TSM 6.3 if you change
"start_time" to "date_time". Please note that I did not ver
James,
What version of TSM? Your select statement will work in TSM 6.3 if
you change "start_time" to "date_time". Please note that I did not
verify the output, only that I got output.
Rick
At 01:39 PM 6/24/2014, you wrote:
Hello Everyone -
I am attempting miserably I
Hello Everyone -
I am attempting miserably I might add to write a select statement that will
produce a bunch of message found in the actlog. The problem I am having is
grabbing the data from the last 24 hours.. I will schedule this to produce an
email each day.. Any thoughts on how to
st Stor Manager"
Subject: [ADSM-L] Select statement to find data archived total
Hi Everyone,
I was asked to find how much space would be saved if there were no data
retentions for archived data for more than 3 years. I currently have archive
management classes that go as high as 14 years.
Hi Everyone,
I was asked to find how much space would be saved if there were no data
retentions for archived data for more than 3 years. I currently have archive
management classes that go as high as 14 years. Is there a way to figure out
how much space is utilized per client that has data ar
#x27;s taking quite a while. I'm not even sure it will return a result
at this point in time.
Thanks again!
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del
Hoobler
Sent: Friday, February 10, 2012 9:11 AM
To: ADSM-L@VM.MARIST.EDU
Subje
2012
08:35:02 AM:
> From: "Moyer, Joni M"
> To: ADSM-L@vm.marist.edu
> Date: 02/10/2012 08:37 AM
> Subject: Re: Help! Select statement syntax for legal reasons
> Sent by: "ADSM: Dist Stor Manager"
>
> Thanks Del!
>
> If I were looking for lidb88n
en
'06/30/2008' and '02/01/2009' and ll_name='/mail/lidb88n.nsf.*'?
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del
Hoobler
Sent: Friday, February 10, 2012 8:26 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Help! Se
ks,
Del
Del Hoobler
Tivoli Storage Manager Development
IBM Corporation
"ADSM: Dist Stor Manager" wrote on 02/09/2012
03:44:49 PM:
> From: Xav Paice
> To: ADSM-L@vm.marist.edu
> Date: 02/09/2012 03:48 PM
> Subject: Re: Help! Select statement syntax for
t; Any thoughts/ideas?
>
> Thanks!
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf
> Of George Huebschman
> Sent: Thursday, February 09, 2012 2:02 PM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: Help! Select statement syntax for
2 2:02 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Help! Select statement syntax for legal reasons
I agree with Thom, the data gets spread everywhere and moved often by
reclamation. You can only tell them where it was when you ran the report.
On Thu, Feb 9, 2012 at 1:35 PM, Thomas Denier <
thomas.den..
Hi,
Please check this link
https://www-304.ibm.com/support/docview.wss?uid=swg21114873
Regards,
Ajay Patel
From: George Huebschman
To: ADSM-L@vm.marist.edu,
Date: 02/09/2012 12:10 PM
Subject:Re: [ADSM-L] Help! Select statement syntax for legal
reasons
Sent by:"
My suspicion is that the legal request is a lawyer's pro forma procedure
written in the 1980s for collecting evidentiary information in a data
processing environment: "Obtain a list of the tapes upon which the data
resides". It's likely that they don't actually care what tapes are involved:
th
are
> >looking for are the training*.nsf and we need to know what tapes the
> >data is on.
> >
> >
> >LNBRTZM335YR, mail1\training.nsf
> >
> >LNBRTZM355YR, mail2\training2.nsf
> >
> >Does anyone know what the syntax of this select statement woul
ata is on.
>
>
> LNBRTZM335YR, mail1\training.nsf
>
> LNBRTZM355YR, mail2\training2.nsf
>
> Does anyone know what the syntax of this select statement would be to find
> this information? Any help is greatly appreciated as I was told I need
> this information by EOD and I'm n
and the .nsf file names we are
>looking for are the training*.nsf and we need to know what tapes the
>data is on.
>
>
>LNBRTZM335YR, mail1\training.nsf
>
>LNBRTZM355YR, mail2\training2.nsf
>
>Does anyone know what the syntax of this select statement would be to
>find thi
e are looking for are the training*.nsf and
we need to know what tapes the data is on.
LNBRTZM335YR, mail1\training.nsf
LNBRTZM355YR, mail2\training2.nsf
Does anyone know what the syntax of this select statement would be to find this
information? Any help is greatly appreciated as I was told I need
Carefully consider extending the retention on the Summary table, as the amount
of data can be large, taxing your database. What I prefer to do is keep a
smallish Summary table, given that the need to query old data is rare, where I
keep 30 days of Activity Log data in the database and older day
James,
set summaryretention xx
Merry Christmas
Bob.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lepre,
James
Sent: Thursday, December 22, 2011 10:05 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select Statement
Does anyone know how
Does anyone know how to take this select command which produces only one month
of data and allow it to go back say 1 year if possible. I have tried to figure
it out but nothing works
select date(start_time) as "Start Date",time(start_time) as "Start
Time",date(end_time) as "End Date",time(end_t
7;
ANS8001I Return code 3.
tsm: TSMCORE>
tsm: TSMCORE>
On 11/15/2010 8:48 AM, Steven Langdale wrote:
How about:
select VOLUME_NAME,ACCESS from volumes where access='READONLY' or
status='FILLING'
Steven
Timothy Hughes
Sent by: "ADSM: Dist Stor Manager"
ann
250-585-3711
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Guido Martínez
Sent: Monday, November 15, 2010 09:35
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] select statement to display readonly and filling tapes
Perhaps this would al
[mailto:ads...@vm.marist.edu] On Behalf Of
Guido Martínez
Sent: Monday, November 15, 2010 09:35
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] select statement to display readonly and filling tapes
Perhaps this would also work:
Select VOLUME_NAME from VOLUMES where status='FILLING' and
SS from volumes where access='READONLY' or
>> status='FILLING'
>>
>> Steven
>>
>>
>>
>>
>> Timothy Hughes
>> Sent by: "ADSM: Dist Stor Manager"
>> 15/11/2010 13:39
>> Please respond to
>> "ADSM: Dist S
-Timothy Hughes wrote: -
>I tried that command failed, and also I want to select the
>"readonly"
>tapes that say "filling" also. So I replaced the "or" with "and".
>this
>command failed also
>
>tsm: >select VOLUME_NAME,ACCESS from volumes where access='READONLY'
>or
>status='FILLING'
27;, STATUS
from media where VOLUME_NAME='FILLING'
Keith M Williams/Dubuque/IBM
Unix System Administrator, IBM Dubuque
ITDelivery, Global Technology Services
kwill...@us.ibm.com
From:
Timothy Hughes
To:
ADSM-L@vm.marist.edu
Date:
11/15/2010 07:40 AM
Subject:
select statement to displ
:
Timothy Hughes
To:
ADSM-L@vm.marist.edu
Date:
11/15/2010 07:40 AM
Subject:
select statement to display readonly and filling tapes
Sent by:
"ADSM: Dist Stor Manager"
Hi
I am trying to add "filling" tapes to this select statement and I am
having no luck does anyone have a select
According to Timothy Hughes:
> thanks steve!
>
> I tried that command failed, and also I want to select the "readonly"
> tapes that say "filling" also. So I replaced the "or" with "and". this
> command failed also
>
> tsm: >select VOLUME_NAME,ACCESS from volumes where access='READONLY' or
> status
='READONLY' or
status='FILLING'
Steven
Timothy Hughes
Sent by: "ADSM: Dist Stor Manager"
15/11/2010 13:39
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
Subject
[ADSM-L] select statement to display readonly and filling tapes
ngdale wrote:
How about:
select VOLUME_NAME,ACCESS from volumes where access='READONLY' or
status='FILLING'
Steven
Timothy Hughes
Sent by: "ADSM: Dist Stor Manager"
15/11/2010 13:39
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
How about:
select VOLUME_NAME,ACCESS from volumes where access='READONLY' or
status='FILLING'
Steven
Timothy Hughes
Sent by: "ADSM: Dist Stor Manager"
15/11/2010 13:39
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
Subj
Hi
I am trying to add "filling" tapes to this select statement and I am
having no luck does anyone have a select statement that shows this?
I already have most of the statement below i just need to add "filling"
to the statement
select VOLUME_NAME,ACCESS from volumes whe
Hi there guys,
After much searching and figuring out how to do select statements on TSM 6.2
This is what I have come up with for backups.
You can manipulate it to suit you.
SELECT substr(char(start_time),1,19) AS
START_TIME,timestampdiff(4,char(timestamp(end_time) - (start_time))) AS
ELAPTIME_
" vm.marist.edu> wrote on 06/23/2010
> 11:37:40 AM:
>
>
> > [image removed]
> >
> > Re: Getting backup duration in TSM 6.2 select statement
> >
> > Prather, Wanda
> >
> > to:
> >
> > ADSM-L
> >
> > 06/23/2010 11:38 AM
That worked like a charm! Thanks so much!
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Sheridan, Peter T.
Sent: Tuesday, June 29, 2010 1:49 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Select statement to only list backups with particular event
Here is a select statement that I use to get all of this info for the
last 24 hours:
select * from events where status!='Completed' and status!='Future' and
status!='Pending' and status!='Started' and scheduled_start >=
'2010-01-01'
n progress or has been started.
>
> Any suggestions/ideas are appreciated! This one has me stumped!
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
> Richard Sims
> Sent: Tuesday, June 29, 2010 12:09 PM
> To: ADSM-L@VM.
The only way to see status=Started jobs is if you perform a query while they
are under way: if you really wanted that, a cron job capture would take care of
it. Running a query after all scheduled backups have finished will report
final status of Completed (or Missed or Failed), which is probab
e 29, 2010 12:09 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Select statement to only list backups with particular event status
The EVENTS table has been an oddball in TSM, as I note in ADSM QuickFacts,
because of the way it was engineered. Using relative timestamp references
traditionally doesn&#x
us values; but things
change over numerous releases.
Richard Sims
On Jun 29, 2010, at 11:05 AM, Moyer, Joni M wrote:
> Hello everyone,
>
> I am trying to create a select statement that will list all backups for
> clients in the domain: windows & hmig that started after yesterda
Hello everyone,
I am trying to create a select statement that will list all backups for clients
in the domain: windows & hmig that started after yesterday at 6PM until today
at the current date/time that had a status of: Missed, In Progress, Fail%,
Started.
I tried the below select state
Dist Stor Manager" wrote on 06/23/2010
11:37:40 AM:
> [image removed]
>
> Re: Getting backup duration in TSM 6.2 select statement
>
> Prather, Wanda
>
> to:
>
> ADSM-L
>
> 06/23/2010 11:38 AM
>
> Sent by:
>
> "ADSM: Dist Stor Manager"
owers
Sent: Monday, June 21, 2010 3:00 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Getting backup duration in TSM 6.2 select statement
I must be missing something. It used to be that we could use the
following select statement to get event durations from the summary
table.
select event, (end
I must be missing something. It used to be that we could use the
following select statement to get event durations from the summary
table.
select event, (end_time - start_time) seconds from summary.
I am keeping this simple for illustrative purposes.
I verified that this works as expected in
Thank you Wanda!
That was where I messed it up.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Wanda
Prather
Sent: Friday, February 12, 2010 10:51 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Syntax of select statement
Well, for one thing, * is
Well, for one thing, * is not a wildcard in a select statement, it's %, and
you need LIKE, not =
where filespace_name LIKE '/root_vdm_4/HMCH1015_E%'
On Fri, Feb 12, 2010 at 10:36 AM, Moyer, Joni M wrote:
> Hello everyone,
>
> I would like to find all tapes that are
Hello everyone,
I would like to find all tapes that are within the storage pool TAPE_NDMP that
are associated with datamover NAS_SERVER_2_5YR and the filespace name of
/root_vdm_4/HMCH1015_E_bkup. I ran the following select statement, but it is
not returning any volumes. Any suggestions
select statement
You could try replacing "date(backup_end) <= current_date -2 days" with
"cast((current_timestamp-backup_end)days as decimal)<2" - Margaret Clark
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Moye
dnesday, August 05, 2009 6:27 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Syntax of select statement
Hi Everyone,
I'm having some issues getting a script to output into an email as I would like
it to and I'm not quite seeing what I am doing wrong. I am running the
fol
Hi Everyone,
I'm having some issues getting a script to output into an email as I would like
it to and I'm not quite seeing what I am doing wrong. I am running the
following:
select node_name as "Server ", filespace_name as "Possible failed
File System ", substr(char(backup_start
-Joni Moyer wrote: -
>I was trying: select * from archives where node_name='FJSU101' and
>owner='appb2b' and filespace_id=11 and date(archive_date) >
>04/31/2009 as a starting point, but I'm still having no luck. Any
>suggestions are greatly appreciated
I would expect the output fro
Hey Everyone,
I've been trying to get the proper output of archived data for a particular
node, but I keep getting hung up on the archive_date parameter and was
wondering if anyone could help out?
I am trying to get information on all archived data for the following:
node_name=fjsu101
owner=ap
ote]-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L < at > VM.MARIST.EDU] On Behalf
Of Remco Post
Sent: Tuesday, February 24, 2009 2:55 PM
To: ADSM-L < at > VM.MARIST.EDU
Subject: Re: [ADSM-L] Select Statement
Interesting question.
Why would you want to know? I
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select Statement
-Timothy Conway wrote: -
>Ok, here. Do a stgpool backup, disable sessions and do another stgpool
>backup to eliminate and prevent new data. While sessions are still
>disabled, mark the volume in question destroyed, and do
-Timothy Conway wrote: -
>Ok, here. Do a stgpool backup, disable sessions and do another
>stgpool backup to eliminate and prevent new data. While sessions
>are still disabled, mark the volume in question destroyed, and do
>a stgpool backup preview. That should tell you every primary
>vo
: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Huebschman, George J.
Sent: Tuesday, February 24, 2009 2:39 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select Statement
I too am confused, not that that is so unusual. I am not sure I
understand what you are saying.
Ther
M: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Lepre,
James
Sent: Tuesday, February 24, 2009 1:49 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select Statement
Hello Everyone,
Is there a select statement or preview to see which tapes will be needed to
reclaim an offsite vo
@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select Statement
Hmm. I'm confused. IF you don't have a copy pool then the volume
required for reclamation is the volume, or volumes that are set to be
reclaimed.
A good way to find out which volumes need reclamation is:
select volume_name as TA
: Re: [ADSM-L] Select Statement
Hmm. I'm confused. IF you don't have a copy pool then the volume
required for reclamation is the volume, or volumes that are set to be
reclaimed.
A good way to find out which volumes need reclamation is:
select volume_name as TAPEPOOL_VOL,est_capa
tor Manager [mailto:ads...@vm.marist.edu] On Behalf
> Of Lepre, James
> Sent: Tuesday, February 24, 2009 3:01 PM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] Select Statement
>
> Well The reason I am asking is that we do not have a copypool setup
for
> our offsite tapepool since
; From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf
> Of Remco Post
> Sent: Tuesday, February 24, 2009 2:55 PM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] Select Statement
>
> Interesting question.
>
> Why would you want to know? I hope your primary
: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Remco Post
Sent: Tuesday, February 24, 2009 3:55 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select Statement
Interesting question.
Why would you want to know? I hope your primary volumes are all on-line?
On Feb 24, 2009, at 21:48
Interesting question.
Why would you want to know? I hope your primary volumes are all on-line?
On Feb 24, 2009, at 21:48 , Lepre, James wrote:
Hello Everyone,
Is there a select statement or preview to see which tapes will be
needed to reclaim an offsite volume.
Thank you
James
Hello Everyone,
Is there a select statement or preview to see which tapes will be
needed to reclaim an offsite volume.
Thank you
James
---
Confidentiality Notice: The information in this e-mail and any
hodes"
Sent by: "ADSM: Dist Stor Manager"
12/30/2008 07:20 AM
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: Select statement to output backup & archive summary per domain
Here is what I use for this info . . . from our morn
Sent by: "ADSM: ADSM-L@VM.MARIST.EDU
Dist Stor cc
Manager"
Select statement to output backup &
archive summary per dom
...@highmark.com]
Skickat: den 29 december 2008 21:13
Till: ADSM-L@VM.MARIST.EDU
Ämne: Select statement to output backup & archive summary per domain
Hi Everyone,
I am trying to figure out how to configure a script that will output the
total GB backed up and total GB archived per domain within a 24
Hi Everyone,
I am trying to figure out how to configure a script that will output the
total GB backed up and total GB archived per domain within a 24 hour time
period. I already have something similar, but it totals all of the data
together and I would like to break it down more by the domain the
OM> To
> Sent by: "ADSM: ADSM-L@VM.MARIST.EDU
> Dist Stor cc
> Manager"
> <[EMAIL PROTECTED] Subject
> .EDU> Re: [ADSM-L] select statement
>
>
Manager"
<[EMAIL PROTECTED] Subject
.EDU> Re: [AD
Hi Avy,
We've seen this when the node has a duplicate file space name. For
example, if a Windows client had a non-unicode file space that was not
converted to Unicode, but instead created a new Unicode file space might
cause this.
While you could construct a SELECT statement to ide
Hi Andrew,
Thank you for pointing me to take a look at the act logs, there sure
is a lot more than the error ANR2956E. The following link does not exactly
tell me the problem as my server version is 5.4.3.0 and I am just running a
select statement. I might submit a PMR to look further into
D]
> ARVEYNORMAN.COM> To
> Sent by: "ADSM: ADSM-L@VM.MARIST.EDU
> Dist Stor cc
> Manager"
> <[EMAIL PROTECTED] Subject
> .EDU> Re: [ADSM-L] select statement
Dist Stor cc
Manager"
<[EMAIL PROTECTED] Subject
.EDU>
mailto:[EMAIL PROTECTED] On Behalf Of
Avy Wong
Sent: Friday, 29 August 2008 5:36 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] select statement
Hello,
The following is a select statement to provide "a total data
stored and tapes used per node in all storage pools".
I have broken down the
Hello,
The following is a select statement to provide "a total data stored
and tapes used per node in all storage pools".
I have broken down the sql and double checked the tables and column names
are all there. Can anyone see where the hangs ups are?
select vu.node_name, ao.total
On Aug 13, 2008, at 8:53 AM, Tim Brown wrote:
Is it possible to query TSM with a select statement that will detail
out
a particular
filespace. If so does any one have one.
Say a filespace \\NODE1\D$ for node NODE1. This particular drive has 5
folders
Can TSM show the percentage of storage for
n
Sent: Wednesday, August 13, 2008 8:54 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] select statement to detail a filespace
Is it possible to query TSM with a select statement that will detail out
a particular
filespace. If so does any one have one.
Say a filespace \\NODE1\D$ for node NODE1.
Is it possible to query TSM with a select statement that will detail out
a particular
filespace. If so does any one have one.
Say a filespace \\NODE1\D$ for node NODE1. This particular drive has 5
folders
Can TSM show the percentage of storage for each or the number of files
active or inactive
03, 2008 4:48 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] select statement for active sessions based on policy
domain
Is there a select statement that would show only
client sessions for a particular donmain.
The domain field doesnt appear in the results of a q session or q
session f=
/products/support/IBMTivoliStorageManager.html
The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.
"ADSM: Dist Stor Manager" wrote on 06/03/2008
01:48:15 PM:
> Is there a select statement that w
Is there a select statement that would show only
client sessions for a particular donmain.
The domain field doesnt appear in the results of a q session or q
session f=d
Tim Brown
Systems Specialist - Project Leader
Central Hudson Gas & Electric
284 South Ave
Poughkeepsie, NY 12601
Email: [E
What about something along these lines - I can never get the math to work
right on SELECT statements (I'd just run two, and do the math myself...)
(select count(*) from volhistory where type='STGNEW') - (select count(*)
from volhistory where usage='STGDELETE') [that's a minus sign between the
two
> To
> ADSM-L
> Sent by: ADSM-L@VM.MARIST.EDU
> cc
>
> 04/01/2008
> 18:12
> Subject
> [ADSM-L] Select statement
>
>
L@VM.MARIST.EDU
cc
04/01/2008 18:12
Subject
[ADSM-L] Select statement
Pl
Good idea, thanks
Ricardo Ribeiro
Storage Administrator
623-217-4139
- Original Message -
From: ADSM: Dist Stor Manager
To: ADSM-L@VM.MARIST.EDU
Sent: Fri Jan 04 16:38:41 2008
Subject: Re: [ADSM-L] Select statement
You could also look at volhistory where use(?)='STGNEW'
You could also look at volhistory where use(?)='STGNEW' and date =desired range.
From: ADSM: Dist Stor Manager on behalf of Ribeiro, Ricardo
Sent: Fri 1/4/2008 2:51 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select statement
Thank you!
---
Thank you!
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Sims
Sent: Friday, January 04, 2008 12:47 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select statement
On Jan 4, 2008, at 1:12 PM, Ribeiro, Ricardo wrote:
> Hello,
>
1 - 100 of 448 matches
Mail list logo
