ADSM-L

Command routing

2004-11-23 06:21:33
Subject: Command routing
From: Henrik Wahlstedt <shwl AT STATOIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 23 Nov 2004 12:21:06 +0100
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" 
<ADSM-L AT VM.MARIST DOT EDU>
                                         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.

<Prev in Thread] Current Thread [Next in Thread>