Hi Rick, I'm using the command in a Spectrum Protect server script, so return codes are the only option...
Kind regards, Eric van Loon Core Infra -----Original Message----- From: ADSM: Dist Stor Manager <ADSM-L@VM.MARIST.EDU> On Behalf Of Rick Saylor Sent: maandag 26 september 2022 14:45 To: ADSM-L@VM.MARIST.EDU Subject: Re: SQL query replnodes Hi Eric, I had the same issue with the q replnode always returning a RC 0. I worked around it by assuming the node was replicated UNLESS either ANR2726E or ANR1701E was found in the q replnode output. I know it is not the most elegant approach but it worked for me. As always you'll need to verify this will work in your environment. Rick Saylor Austin Community College On 9/26/22 06:15, Loon, Eric van (ITOP DI) - KLM wrote: > 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-GHBF3mjMh8 > hqKP6S3yoYkvUfae1_-jOy0Sxo5BwNk-ou-jEi_ZriYGh9qdfx6xpSjF51t135bX0HU-h1 > GsFwtqSsflfrNsiLl66cZ36slTnOuKXW9FlbV_9yxA-AZgypRfb_k92r7TNh5gMZ0CH5C- > -mX3BQ4sTVjDPSyH1yyi65ZWoOpwAvQdc9WVYX2P4GVlnfL6J5BT4poAWcf-DcOi7qoNKJ > hAiBcU5IcuXscl4C7Z9U6ma_FV-lqvX1Cxbf_wzEURDWDPtbhhGq-l_18U1e61r-vxuzjU > cbJ-9Ga3xn5ouJdmzumqyNSalY-vlbJD4Zl1rAhfu6s/https%3A%2F%2Fprotect2.fir > eeye.com%2Fv1%2Furl%3Fk%3D948d3f5d-cb1607ad-948a1bb8-ac1f6b01744c-e405 > eb27701fe333%26q%3D1%26e%3Df4eb6721-455e-4909-a32e-bf2a05bc2aca%26u%3D > https%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 > ******************************************************** > ******************************************************** For information, services and offers, please visit our web site: http://www.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 ********************************************************
