?
"Sharp, Neil
(London)" To: [EMAIL PROTECTED]
SharpNei@EXCHANGE.cc:
UK.ML.COM Subject: Re: How to find out what
tape's a c
Andy Raibeck:
Either way, I'm pretty sure that DISTINCT is supposed to
account for distinct rows in their entirety, and not just certain columns.
I'll have to look into this.
That's what I thought too. My guess would be something to do with the SQL
interface not being direct to the database
Andy Raibeck
Andrew_Raibeck@TTo: [EMAIL PROTECTED]
IVOLI.COM cc:
Sent by: "ADSM: Subject: Re: How to find out what
tape's a client data are on ?
Dist
Thanks for the suggestion
-Original Message-
From: Bernhard Unold [SMTP:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 1:21 PM
To: [EMAIL PROTECTED]
Subject: Re: How to find out what tape's a client data are on ?
I can't help with Sql, but i wonder, why do you need tapes
PROTECTED]
SharpNei@EXCHANGE.cc:
UK.ML.COM Subject: Re: How to find out what
tape's a client data are on ?
Sent
esley R" [EMAIL PROTECTED]@VM.MARIST.EDU on 03/02/2001
11:16:27 AM
Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
Sent by: "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: Re: How to find out what tape's a client data a
Neil
(London)" To: [EMAIL PROTECTED]
SharpNei@EXCHANGE.cc:
UK.ML.COM Subject: Re: How to find
out what tape's a client data are on ?
Sent by: "ADSM:
Di
I have a frustrating situation whereby if I perform a client restore it may
call a tape from off-site. This tape is then recalled (usually 4 hours) and
then placed in the library. The restore then continues but then stalls again
requesting another tape. What I need to find out up front are all
you can try :
dsmadmc -id=YOURNAME -pass=YOURPASS -outfile \
"select distinct(volume_name) \
from volumeusage \
where node_name='YOURNODE'"
hth
A 12:43 01/03/2001 -, vous avez crit :
I have a frustrating situation whereby if I perform a client restore it may
call a tape from off-site.
[EMAIL PROTECTED]
http://www.irislink.com
Tel: +32 (0)10 48 75 10 - Fax: +32 (0)10 48 75 40
-Original Message-
From: Sharp, Neil (London) [mailto:[EMAIL PROTECTED]]
Sent: jeudi 1 mars 2001 13:44
To: [EMAIL PROTECTED]
Subject: How to find out what tape's a client data are on ?
I have
Thanks for your help. It has answered my question.
Neil
-Original Message-
From: Ruddy STOUDER [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 12:47 PM
To: [EMAIL PROTECTED]
Subject: Re: How to find out what tape's a client data are on ?
Here is the SQL script
L PROTECTED]
cc:
Subject: Re: How to find out what tape's a client data are on ?
Thanks for your help. It has answered my question.
Neil
-Original Message-
From: Ruddy STOUDER [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 12:47 PM
To: [EMAIL PROTECTED]
Subject: R
Try the nodename in UPPERCASE... It cut/pasted fine on my box. (4.1.1.2)
-Original Message-
From: Shekhar Dhotre [mailto:[EMAIL PROTECTED]]
Sent: 01 March 2001 16:40
To: [EMAIL PROTECTED]
Subject: Re: How to find out what tape's a client data are on ?
I am trying same command
AM
Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
Sent by: "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: Re: How to find out what tape's a client data are on ?
Thanks for your help. It has answered my question.
Neil
--
Use upper-case within the single quotes for the node_name.
[EMAIL PROTECTED] on 01-Mar-2001 11:39
Please respond to [EMAIL PROTECTED]
To: ADSM-L
cc:(bcc: Kent J Monthei/CIS/PHRD/SB_PLC)
Subject: Re: How to find out what tape's a client data are on ?
I am trying same command
Shekhar,
Remember that the node name is case sensitive and is all caps.
-Original Message-
From: Shekhar Dhotre [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 11:40 AM
To: [EMAIL PROTECTED]
Subject: Re: How to find out what tape's a client data are on ?
I am trying same
5:39 PM
Subject: Re: How to find out what tape's a client data are on ?
I am trying same command for the One of my AIX Box , that is getting
backed up
regularly .
I am not getting any output .. IS anything wrong here ..
tsm: TSMselect volume_name,node_name from volumeusage where
node_name
ROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 5:39 PM
Subject: Re: How to find out what tape's a client data are on ?
I am trying same command for the One of my AIX Box , that is getting
backed up
regularly .
I am not getting any output .. IS anything wrong here ..
tsm: TSMselect v
ot; [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: Re: How to find out what tape's a client data are on ?
Shekhar,
Remember that the node name is case sensitive and is all caps.
-Original Message-
From: Shekhar Dhotre [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 11:40 AM
uot;ADSM: Dist Stor Manager" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: Re: How to find out what tape's a client data are on ?
Thanks .Worked .. .. i was thinking that TSM is not case sensitive
application
.. hmm..
Glen Churchfield [EMAIL PROTECTED]@VM.MARIST.EDU o
To: [EMAIL PROTECTED]
IVOLI.COM cc:
Sent by: "ADSM: Subject: Re: How to find out what
tape's a client data are on ?
Dist Stor
Manager"
[EMAIL
MAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: Re: How to find out what tape's a client data are on ?
The most probable mistake is that the node name should be in capital
letters.
You have to write exactly what TSM has in its database.
Do a query nodes to find out
Regards
Maria
---
CTED]
To: [EMAIL PROTECTED]
cc:
Subject: Re: How to find out what tape's a client data are on ?
Yes, all tapes are in this query. To further define list add in the "where"
clause the stgpool_name you want or don't want.
David B. Longo
System Administrator
Health First, Inc.
3300 F
Stor Manager" [EMAIL PROTECTED]
Sent by: "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: Re: How to find out what tape's a client data are on ?
Yes, all tapes are in this query. To further define list add in the "where"
clause the
PM
Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
Sent by: "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: Re: How to find out what tape's a client data are on ?
Your select statement is incorrect. It should be:
select v
MEDRS1
MED506 MEDRS1
David Longo [EMAIL PROTECTED]@VM.MARIST.EDU on 03/01/2001 04:28:55
PM
Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
Sent by: "ADSM: Dist Stor Manager" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subje
Just out of curiosity, since I've only casually been following
this thread, was there a specific reason for the "group by"
clause?
I think what is desired is simplly an "order by" clause, e.g.
Well, I'm really confused now.
I came up with my own version of the query:
select distinct
27 matches
Mail list logo