Hello,
add the -noconfirm option and that should take care of it, i.e,
# dsmadmc -server=andy -id=XXXXX -password=XXXXX -noconfirm <<EOD
...etc
Bye
Rejean Larivee
IBM Tivoli Storage Manager support
Eivind Birkeland
<[EMAIL PROTECTED]
> To
Sent by: "ADSM: ADSM-L@VM.MARIST.EDU
Dist Stor cc
Manager"
<[EMAIL PROTECTED] Subject
.EDU> Re: yasq (yet another sql question
. . . . )
01/19/2005 03:19
AM
Please respond to
"ADSM: Dist Stor
Manager"
Hi.
Think the problem is in TSM!
Se my examples:
FIRST I run the command against a smal TSM-server (andy), with OK result:
------------------------------------------------------------------------------------------------------------------
# dsmadmc -server=andy -id=XXXXX -password=XXXXX <<EOD
> select A.node_name, B.domain_name, -
> sum(A.num_files), -
> sum(A.physical_mb), -
> sum(A.logical_mb) -
> from occupancy A, nodes B where A.node_name = B.node_name group by
A.node_name, B.domain_name
> EOD
IBM Tivoli Storage Manager
Command Line Administrative Interface - Version 5, Release 2, Level 2.0
(c) Copyright by IBM Corporation and other(s) 1990, 2003. All Rights
Reserved.
Session established with server ANDY: AIX-RS/6000
Server Version 5, Release 1, Level 9.3
Server date/time: 19-01-2005 08:02:20 Last access: 19-01-2005 07:53:02
ANDY UNIX-BE 7609490 876766.53 872574.98
BELNDIMSS01 NT-BE 32582 8675.70 8250.80
:
:
TRAMPE UNIX-BE 147704 10894.72 10574.58
ANS8002I Highest return code was 0.
#
------------------------------------------------------------------------------------------------------------------
THEN I try the same command on a large TSM-server (andycap), with the same
error as you got.
BUT I sendt the output to a file (outfile) and the it is clear what is
happening.
The contents of the outfile is:
------------------------------------------------------------------------------------------------------------------
IBM Tivoli Storage Manager
Command Line Administrative Interface - Version 5, Release 2, Level 2.0
(c) Copyright by IBM Corporation and other(s) 1990, 2003. All Rights
Reserved.
Session established with server ANDYCAP: AIX-RS/6000
Server Version 5, Release 1, Level 9.3
Server date/time: 19-01-2005 08:09:38 Last access: 19-01-2005 08:03:36
ANR2963W This SQL query may produce a very large result table, or may
require a significant amount of time to compute.
Do you wish to proceed? (Yes (Y)/No (N)) The only valid responses are
characters from this set: [Y, N]
The character '#' stands for any decimal integer.The only valid responses
are characters from this set: [Y, N]
The character '#' stands for any decimal integer.The only valid responses
are characters from this set: [Y, N]
The character '#' stands for any decimal integer.The only valid responses
are characters from this set: [Y, N]
:
:
: (this goes on forever.........)
------------------------------------------------------------------------------------------------------------------
TSM think it is in an interactiv session and is asking you if you want to
execute this large select.
And due to no or wrong respons it gives the error-message and try once
more!!! Forever!
Try to give an other answer to the question in an interactiv session and
you get the same respons from TSM.
So, as I sad, the problem is TSM and bad handling of the "<<EOD" type of
input.
Put the sql-command on a file and use the "macro filename" instead.
"Prather, Wanda"
<[EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU
HUAPL.EDU> cc: (bcc: Eivind Birkeland)
Sent by: "ADSM: Subject: Re: yasq (yet
another sql question . . . . )
Dist Stor
Manager"
<[EMAIL PROTECTED]
T.EDU>
18.01.2005 17:47
Please respond
to "ADSM: Dist
Stor Manager"
I don't think it is an SQL question. The SELECT works just fine as is
when I run it as a TSM script.
I think your problem is something to do with extraneous characters,
character set, or with stdin on the host, not with TSM SQL.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Rhodes
Sent: Tuesday, January 18, 2005 11:35 AM
To: ADSM-L@VM.MARIST.EDU
Subject: yasq (yet another sql question . . . . )
Hi Everyone . . .
I'm trying to do a couple things . . . .
1) Trying to get a listing as follows, where the occupancy filespace
stats are sum'ed for each node, with the node domain thrown in:
like this: <node> <domain> <sum-files> <sum-physicalMB>
<sum-logicalMB>
Here is the command I'm trying . . . .
dsmadmc -id=admin -password=admin -tab <<EOD
select -
occupancy.node_name, -
nodes.domain_name, -
sum(occupancy.num_files), -
sum(occupancy.physical_mb), -
sum(occupancy.logical_mb) -
from occupancy, nodes -
where occupancy.node_name = nodes.node_name -
group by occupancy.node_name, nodes.domain_name
EOD
When I run this, I get a ZILLION of the following message, and
the cmd never finishes (or I'm impatient and don't wait long enough).
"The character '#' stands for any decimal integer.The only valid
responses are characters from this set: [Y, N]"
question -> What is the above message and what dumb thing am I doing
wrong?
2) I would like to generate a report that sum's files, physicalMB and
logicalMB
per domain.
like this: <domain> <sum-files> <sum-physicalMB> <sum-logicalMB>
question: Is there a cmd or a sql statement to do this?
I guess it would be very similar to the above sql, except without the
node_name, but
since I can't get that one right, I figure I'll need help with this one
also.
Thanks
Rick
-----------------------------------------
The information contained in this message is intended only for the
personal
and confidential use of the recipient(s) named above. If the reader of
this
message is not the intended recipient or an agent responsible for
delivering it to the intended recipient, you are hereby notified that
you
have received this document in error and that any review, dissemination,
distribution, or copying of this message is strictly prohibited. If you
have received this communication in error, please notify us immediately,
and delete the original message.
-------------------------------------------------------------------
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.
