Hi Andy,
The problem with using the q replnode command is that it always returns RC 0,
even if a replnode does not exist. I'm trying to create a script which should
only execute a remove replnode when one exists, but if(rc_notfound), nor
if(error) is working...
Thanks for your help!
Kind regards,
Eric van Loon
Core Infra
-----Original Message-----
From: ADSM: Dist Stor Manager <ADSM-L@VM.MARIST.EDU> On Behalf Of Andrew Raibeck
Sent: donderdag 22 september 2022 17:09
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL query replnodes
Hi Eric,
I do not think there is any trivial way to use SELECT, as I suspect the output
is computed rather than merely copied from an internal table. Is there some
special reason why the QUERY REPLNODE command is inadequate? If you want a CSV
format, you could use the -DATAONLY=YES option and either the -COMMADELIMITED
or -TABDELIMITED options.
Example:
dsmadmc -id=youradminid -pa=topsecret -tabdelimited -dataonly=yes -outfile=qreplnode.csv
"query replnode *"
Regards,
Andy
Andrew Raibeck
IBM Spectrum Protect Level 3
IBM Systems, Storage
stor...@us.ibm.com
IBM
-----Original Message-----
From: ADSM: Dist Stor Manager <ADSM-L@VM.MARIST.EDU> On Behalf Of Griggs, James
F. (JMD) (CTR)
Sent: Thursday, 22 September, 2022 11:00
To: ADSM-L@VM.MARIST.EDU
Subject: [EXTERNAL] Re: SQL query replnodes
Seems to me you could use the following fields from the "NODES" table:
REPL_STATE
REPL_MODE
Repl_state indicates if replicate is "Enabled" for a node Repl_mode indicates
send or receive
Where "Send" is the source node
And where "Receive" is a destination replication node
Should both the repl_state and repl_node = "None" it is not being replicated
-----Original Message-----
From: ADSM: Dist Stor Manager <ADSM-L@VM.MARIST.EDU> On Behalf Of Loon, Eric
van (ITOP DI) - KLM
Sent: Thursday, September 22, 2022 8:47 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [EXTERNAL] Re: [ADSM-L] SQL query replnodes
Hi Dmitry,
That still doesn't show me if replnodes exist for a specific node...
Kind regards,
Eric van Loon
Air France/KLM Core Infra
-----Original Message-----
From: ADSM: Dist Stor Manager <ADSM-L@VM.MARIST.EDU> On Behalf Of Dmitry Dukhov
Sent: donderdag 22 september 2022 13:20
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL query replnodes
Hi all
Better to use
Select * from nodes where repl_state='NONE'
Repl_state can have three status: none, enabled, disabled
I think it's more correct
Dmitry Dukhov
https://secure-web.cisco.com/1FVp1eRVN3hmrsXBijThbYxYig_Am3-GHBF3mjMh8hqKP6S3yoYkvUfae1_-jOy0Sxo5BwNk-ou-jEi_ZriYGh9qdfx6xpSjF51t135bX0HU-h1GsFwtqSsflfrNsiLl66cZ36slTnOuKXW9FlbV_9yxA-AZgypRfb_k92r7TNh5gMZ0CH5C--mX3BQ4sTVjDPSyH1yyi65ZWoOpwAvQdc9WVYX2P4GVlnfL6J5BT4poAWcf-DcOi7qoNKJhAiBcU5IcuXscl4C7Z9U6ma_FV-lqvX1Cxbf_wzEURDWDPtbhhGq-l_18U1e61r-vxuzjUcbJ-9Ga3xn5ouJdmzumqyNSalY-vlbJD4Zl1rAhfu6s/https%3A%2F%2Fprotect2.fireeye.com%2Fv1%2Furl%3Fk%3D948d3f5d-cb1607ad-948a1bb8-ac1f6b01744c-e405eb27701fe333%26q%3D1%26e%3Df4eb6721-455e-4909-a32e-bf2a05bc2aca%26u%3Dhttps%253A%252F%252Fwww.tsmexplorer.copm%252F
On 21 Sep 2022, at 19:28, Rick Adamson <rickadam...@segrocers.com> wrote:
Eric,
Are you looking for something along these lines.....?
select node_name,repl_state,repl_mode from nodes where
repl_state='ENABLED' order by node_name
-Rick Adamson
-----Original Message-----
From: ADSM: Dist Stor Manager <ADSM-L@VM.MARIST.EDU> On Behalf Of
Oscar Kolsteren
Sent: Wednesday, September 21, 2022 11:04 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SQL query replnodes
* This email originated outside of the organization. Use caution when
opening attachments or clicking links. *
----------------------------------------------------------------------
Hey Eric,
Have a look in our data collector which is used to create our FREE IBM CSA
Health Check report.
If you don't have a copy left, let me know and I'll share one. In the script
are all the select statements we use.
Or just run a fresh collection and upload for me to create a new report.
Best Regards,
Oscar Kolsteren
Lead Storage Consultant, IBM Client Storage Assessment Team (UKI)
-----Original Message-----
From: ADSM: Dist Stor Manager <ADSM-L@VM.MARIST.EDU> On Behalf Of
Loon, Eric van (ITOP DI) - KLM
Sent: 21 September 2022 09:16
To: ADSM-L@VM.MARIST.EDU
Subject: [EXTERNAL] [ADSM-L] SQL query replnodes
Hi everybody,
I'm trying to find a way to list replnode(s) through a SQL query, does anybody know
where this information can be found? So something like QUERY RPELNODE
<NODENAME>, but than through a SQL query.
Thanks for any help in advance!
Kind regards,
Eric van Loon
Air France/KLM Core Infra
********************************************************
For information, services and offers, please visit our web site:
http://secure-web.cisco.com/1b1r9BIxXd0EggxnoUWneSbGXQDTQ9rDbZQjFhro8049je1QFQ7M9t9M6wM4x3qPzF4XBK7SlfJUc6XZevMpxH_ftDxbWoRW9pimZXtT3dGmFI9wMh6S81BEhqGmHIa7YhXNaVv5hxKFfwEnJvMKnzYTKXfTshCPN7s7CXNvAWDLzbBChXYFyQ1QZ9hb0kGCXD8Q8xsmhzNYvIIY5K_AR4iBARdqoqksMoocsChXdk6p9B813abTdlaHe9KRtEvFdjxMClF6vxEJ0-pW62tVBRhBt5fniiUKr3g8nU7jjId5ILOAN04rut7DK_XFAvM-ob95D7A0Yu5q2DPB5OAWrrv3hYeF8cFTbNSqvSpKhypE/http%3A%2F%2Fwww.klm.com
. This e-mail and any attachment may contain confidential and privileged
material intended for the addressee only. If you are not the addressee, you are
notified that no part of the e-mail or any attachment may be disclosed, copied
or distributed, and that any other action related to this e-mail or attachment
is strictly prohibited, and may be unlawful. If you have received this e-mail
by error, please notify the sender immediately by return e-mail, and delete
this message.
Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its
employees shall not be liable for the incorrect or incomplete transmission of
this e-mail or any attachments, nor responsible for any delay in receipt.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal
Dutch Airlines) is registered in Amstelveen, The Netherlands, with
registered number 33014286
********************************************************
Unless otherwise stated above:
IBM United Kingdom Limited
Registered in England and Wales with number 741598 Registered office:
PO Box 41, North Harbour, Portsmouth, Hants. PO6 3AU
**CONFIDENTIALITY NOTICE** This electronic message contains information from
Southeastern Grocers, Inc and is intended only for the use of the addressee.
This message may contain information that is privileged, confidential and/or
exempt from disclosure under applicable Law. This message may not be read,
used, distributed, forwarded, reproduced or stored by any other than the
intended recipient. If you are not the intended recipient, please delete and
notify the sender.
********************************************************
For information, services and offers, please visit our web site:
https://secure-web.cisco.com/1-CPpCwpAVoTfmVOBeo6CnC9w2hE3Z91C4U2a_gg6oWYtbymeIeQjMomWVzEvohWEp3zuFi8l1hDFurEhoFsdUfyoJFNQ3PzrMztp9uKX1SvQzfp-2KnjyqHnF6-KrSMtX2RiluoWxp5bLf6PVtzB0PHco-fNocnC3wuSIVV5K2nmqrf41axcji_kgtWGu-wCKqfIE708egEnbEiX6x73sylLTzX5vjA-zJsVaKaLtjgsWjeblAqc11EVJtPKQ2iszqag5ITKmqST7fk7TetwgnmGiM7F1Tmwe6RZpKfAQWgxdi9d5gb_-ww4OwEP54Tlvx7KCZDA2bVl5Ys8NvDHqgXWB-le7U3xCTYwuCvOG2c/https%3A%2F%2Fprotect2.fireeye.com%2Fv1%2Furl%3Fk%3D1cdd1bde-4346232e-1cda3f3b-ac1f6b01744c-bffc28cea02867c6%26q%3D1%26e%3Df4eb6721-455e-4909-a32e-bf2a05bc2aca%26u%3Dhttp%253A%252F%252Fwww.klm.com%252F
. This e-mail and any attachment may contain confidential and privileged
material intended for the addressee only. If you are not the addressee, you are
notified that no part of the e-mail or any attachment may be disclosed, copied
or distributed, and that any other action related to this e-mail or attachment
is strictly prohibited, and may be unlawful. If you have received this e-mail
by error, please notify the sender immediately by return e-mail, and delete
this message.
Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its
employees shall not be liable for the incorrect or incomplete transmission of
this e-mail or any attachments, nor responsible for any delay in receipt.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch
Airlines) is registered in Amstelveen, The Netherlands, with registered number
33014286
********************************************************
********************************************************
For information, services and offers, please visit our web site:
http://secure-web.cisco.com/1b1r9BIxXd0EggxnoUWneSbGXQDTQ9rDbZQjFhro8049je1QFQ7M9t9M6wM4x3qPzF4XBK7SlfJUc6XZevMpxH_ftDxbWoRW9pimZXtT3dGmFI9wMh6S81BEhqGmHIa7YhXNaVv5hxKFfwEnJvMKnzYTKXfTshCPN7s7CXNvAWDLzbBChXYFyQ1QZ9hb0kGCXD8Q8xsmhzNYvIIY5K_AR4iBARdqoqksMoocsChXdk6p9B813abTdlaHe9KRtEvFdjxMClF6vxEJ0-pW62tVBRhBt5fniiUKr3g8nU7jjId5ILOAN04rut7DK_XFAvM-ob95D7A0Yu5q2DPB5OAWrrv3hYeF8cFTbNSqvSpKhypE/http%3A%2F%2Fwww.klm.com
This e-mail and any attachment may contain confidential and privileged
material intended for the addressee only. If you are not the addressee, you are
notified that no part of the e-mail or any attachment may be disclosed, copied
or distributed, and that any other action related to this e-mail or attachment
is strictly prohibited, and may be unlawful. If you have received this e-mail
by error, please notify the sender immediately by return e-mail, and delete
this message.
Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its
employees shall not be liable for the incorrect or incomplete transmission of
this e-mail or any attachments, nor responsible for any delay in receipt.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch
Airlines) is registered in Amstelveen, The Netherlands, with registered number
33014286
********************************************************