#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
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...@jeffersonhospital.org> wrote:
> -Joni Moyer wrote: -
>
> >I have a situation where
Joni,
It isn't elegant, and it won't produce a report format, but it should
narrow your search down a lot and make a query of the Contents Table a lot
lighter:
You could try initiating restores of the data to see what tapes are
called for. Just check the actlog.
Then you could do a select aga
-Joni Moyer wrote: -
>I have a situation where someone wants to know what tapes particular
>people's backup data is on for our TDP for Mail backups for the time
>period from 7/08 - 1/09. The TSM client names are LNBRTZM3*5YR and
>the mail filesystem location is: mailx and the .nsf file na
Hi Everyone,
I have a situation where someone wants to know what tapes particular people's
backup data is on for our TDP for Mail backups for the time period from 7/08 -
1/09. The TSM client names are LNBRTZM3*5YR and the mail filesystem location
is: mailx and the .nsf file names we are lookin
t; backed up in over 5 days, but that's another battle.
>
> Thanks again!
>
>
> Joni Moyer
> Highmark
> Storage Systems, Senior Systems Programmer
> Phone Number: (717)302-9966
> Fax: (717) 302-9826
> [EMAIL PROTECTED]
> *
-9966
Fax: (717) 302-9826
[EMAIL PROTECTED]
"Andrew Raibeck" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager"
10/05/2006 01:03 PM
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: Se
Highmark
> Storage Systems, Senior Systems Programmer
> Phone Number: (717)302-9966
> Fax: (717) 302-9826
> [EMAIL PROTECTED]
>
>
>
>
> "Andrew Carlson" <[EMAIL PROTECTED]>
> Sent by: "ADSM: Dist Stor Manager"
al Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Joni Moyer
Sent: Thursday, October 05, 2006 2:00 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Select Statement Syntax
Hello Everyone,
I have been trying to figure out how to have the syntax of the below
output so
t by: "ADSM: Dist Stor Manager"
10/05/2006 10:45 AM
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: Select Statement Syntax
I went through this same problem. Never got a satisfactory answer,
totally. It behaves differently depen
Subject: Re: [ADSM-L] Select Statement Syntax to view the schedule
Hi All,
I am able to see the node info using the following command
TSM>Select * from nodes
However, the same doesn't work as
TSM>Select * from schedules
Can anybody let me know the right command for getting info abou
Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Gopinathan, Srinath
Sent: Thursday, 05 October, 2006 16:33
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Select Statement Syntax to view the schedule
Hi All,
I am able to see the node info using the following command
TSM>Select * from nodes
Howe
Try
select tabname, remarks from tables
to get information about available tables you can query. You should see
some table names that might be suitable.
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Int
I went through this same problem. Never got a satisfactory answer,
totally. It behaves differently depending on if you do it from a terminal,
or disconnected, like from cron. Also it depends on the setting of
sqldisplaymode. Try the command `set sqldisplaymode wide` and see if that
makes it lo
On Oct 5, 2006, at 9:00 AM, Joni Moyer wrote:
Hello Everyone,
I have been trying to figure out how to have the syntax of the below
output so that it will all go on 1 line, but so far I have been very
unsuccessful.
...
Joni -
Explore the capabilities of SQL in order to use it effectively, and
#x27;
Regards,
Rama
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Joni Moyer
Sent: Thursday, October 05, 2006 9:00 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Select Statement Syntax
Hello Everyone,
I have been trying to figure out how to have the syntax
st Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Joni Moyer
Sent: 05 October 2006 14:00
To: ADSM-L@VM.MARIST.EDU
Subject: [SPAM: 4.000] [ADSM-L] Select Statement Syntax
Hello Everyone,
I have been trying to figure out how to have the syntax of the below
output so that it will all go on 1 lin
Use:
select node_name as "NODE_NAME ",
filespace_name as "FILESPACE_NAME", ...
padding the quoted titles with enough blank spaces to achieve what you
want.
Alternatively, consider using a Windows spreadsheet or database program to
access the TSM
19 78
e-mail: [EMAIL PROTECTED]
**
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Joni Moyer
Sent: Thursday, 05 October, 2006 15:00
To: ADSM-L@VM.MARIST.EDU
Subject: Select Statement Syntax
Hello Everyone,
I have been trying to figure out how to have
Hi All,
I am able to see the node info using the following command
TSM>Select * from nodes
However, the same doesn't work as
TSM>Select * from schedules
Can anybody let me know the right command for getting info about
schedules using select statement
Regards,
Srinath G
This e-mail has been s
Joni Moyer said the following on 10/5/06 9:00 AM:
Hello Everyone,
I have been trying to figure out how to have the syntax of the below
output so that it will all go on 1 line, but so far I have been very
unsuccessful.
Here is the statement I am issuing:
select node_name,filespace_name,backup_s
Hello Everyone,
I have been trying to figure out how to have the syntax of the below
output so that it will all go on 1 line, but so far I have been very
unsuccessful.
Here is the statement I am issuing:
select node_name,filespace_name,backup_start,backup_end from filespaces
where node_name like
Hi Joni,
The timestamp format is:
'-mm-dd hh:mm:ss.nn'
where:
= year
mm = month
dd = day
hh = hours
mm = minutes
ss = seconds (optional)
nn = fraction of a second (optional)
When referring to a timestamp, put it in single quotes and use the above
format, i.
Hello Everyone!
I have this script that I run once/day, but we are moving servers and
I would like to run this every 15 min. and have a starting point of
Friday, 8/19 at noon. How would I change the start_date and
start_time parameters so that it would look at my specific
This command looks very familiar.
Here's ya go. try this
select with duration
select left(entity,10) as node_name, date(start_time) as date,-
cast(activity as varchar(8)) as activity, time(start_time) as start, -
time(end_time) as end,cast(bytes/1024/1024 as decimal(6,0)) as mb, -
cast(substr(c
Hello Everyone!
I have the following select statement and I was wondering how to go about
getting the duration of the backup? I know that it would be the end_time -
start_time, but my syntax must be wrong because it just won't work. Any
help would be appreciated!
select left(entity,10) as node_
Joni,
Using a calculated timestamp value in a query against the events table does
not work as you would expect. It boils down to an issue with when TSM
constructs the events table to run the query against. The default for "q
event" and "SELECT xxx,yyy,zzz from EVENTS..." is for the current day
'LDS%')
Bil Boyer
DSS, Inc.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of
Joni Moyer
Sent: Friday, October 03, 2003 10:04 AM
To: [EMAIL PROTECTED]
Subject: select statement syntax
Hello everyone!
I have tried this select statement many times
anager" <[EMAIL PROTECTED]>
10/03/2003 07:04
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject:select statement syntax
Hello everyone!
I have tried this select statement many times with no success. I thought
that t
Hello everyone!
I have tried this select statement many times with no success. I thought
that this statement had previously worked, but now I'm having problems
again... I am looking for all nodes that begin with HM and PA for the past
day. Does anyone have any suggestions? This is on a mainfra
37 matches
Mail list logo
