Hmm, I forgott ( )...
(STO-W03) Select Node_name, state, count(*) as "Number of trans.logs" from
backups where (node_name='STO-W09-TDP' and
filespace_name='STO-LN01.DOMLOGS') group by Node_name ,state order by
node_name,state
//Henrik
----- Forwarded by Henrik Wahlstedt on 2004-11-23 12:19 -----
Henrik
Wahlstedt To: "ADSM: Dist Stor Manager"
<[EMAIL PROTECTED]>
cc:
2004-11-23 Subject: Command routing
10:34
Hello,
I have defined a couple of TSM servers (TSM1, TSM2 etc) on our main TSM
server and I can route commands ex. TSM2:select xyz or TSM2:q se.
My problem is when I try to make a script with selects it wont route the
commands, what did I miss?
11/23/2004 10:31:25 ANR2017I Administrator XXX issued command: RUN
q_translog
11/23/2004 10:31:25 ANR2017I Administrator XXX issued command: Select
Node_name, state, count(*) as "Number of
trans.logs" from
backups where (node_name='STO-W09-TDP' and
filespace_name='STO-LN01.DOMLOGS') group by
Node_name
,state order by node_name,state
11/23/2004 10:31:25 ANR2034E SELECT: No match found using this
criteria.
11/23/2004 10:31:25 ANR1462I RUN: Command script Q_TRANSLOG completed
successfully.
tsm: DSM0>q scr q_translog f=d
Name: Q_TRANSLOG
Line Number: Description
Command: Query number of Domino trans.logs
Last Update by (administrator): XXX
Last Update Date/Time: 11/19/2004 14:07:03
Name: Q_TRANSLOG
Line Number: 1
Command: STO-W03: Select Node_name, state, count(*)
as "Number of trans.logs" from backups where (node_name='STO-W09-TDP' and
filespace_name='STO-LN01.DOMLOGS') group
by Node_name ,state order by node_name,state
Last Update by (administrator): XXX
Last Update Date/Time: 11/19/2004 14:07:03
tsm: DSM0>STO-W03: Select Node_name, state, count(*) as "Number of
trans.logs" from backups where (node_name='STO-W09-TDP' and filespace_name
='STO-LN0
1.DOMLOGS') group by Node_name ,state order by node_name,state
ANR1699I Resolved STO-W03 to 1 server(s) - issuing command SELECT
Node_name, state, count(*) as "Number of trans.logs" from backups where
(node_name=STO-W09-TDP and= filespace_name=STO-LN01.DOMLOGS )= group= by=
Node_name= ,state= order= by= node_name,state= against server(s).
ANR1687I Output for command 'SELECT Node_name, state, count(*) as "Number
of trans.logs" from backups where (NODE_NAME=STO-W09-TDP and=
FILESPACE_NAME=STO-LN01.DOMLOGS )= group= by= Node_name= ,state= order= by
= node_name,state= ' issued against server STO-W03 follows:
NODE_NAME STATE Number of trans.logs
------------------ ------------------ --------------------
STO-W09-TDP ACTIVE_VERSION 755
STO-W09-TDP INACTIVE_VERSION 2566
ANR1688I Output for command 'SELECT Node_name, state, count(*) as "Number
of trans.logs" from backups where (NODE_NAME=STO-W09-TDP and=
FILESPACE_NAME=STO-LN01.DOMLOGS )= group= by= Node_name= ,state= order= by
= node_name,state= ' issued against server STO-W03 completed.
ANR1694I Server STO-W03 processed command 'SELECT Node_name, state, count
(*) as "Number of trans.logs" from backups where (NODE_NAME=STO-W09-TDP and
=
FILESPACE_NAME=STO-LN01.DOMLOGS )= group= by= Node_name= ,state= order= by
= node_name,state= ' and completed successfully.
ANR1697I Command 'SELECT Node_name, state, count(*) as "Number of
trans.logs" from backups where (NODE_NAME=STO-W09-TDP and=
FILESPACE_NAME=STO-LN01.DOMLOGS )= group= by= Node_name= ,state= order= by
= node_name,state= ' processed by 1 server(s): 1 successful, 0 with
warnings, and 0 with errors.
tsm: DSM0>
//Henrik
-------------------------------------------------------------------
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.
