Understood Eric, will ask around for an equivalent "select" command structure
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 16:21 To: ADSM-L@VM.MARIST.EDU Subject: [EXTERNAL] Re: [ADSM-L] SQL query replnodes Hi Oscar, The only statement related to replication in the script is a select * from REPLICATIONVIEW with ur, which is not really what I'm looking for. I'm hoping to find a SQL query with basically the same output as a q replnode <nodename>. By the way, for us, this is definitely not the best time to rerun the CSA Health Check Report: we're still debugging quite a few replication issues with support. If we receive stable code again from IBM, maybe I will give it another try. Kind regards, Eric van Loon Core Infra -----Original Message----- From: ADSM: Dist Stor Manager <ADSM-L@VM.MARIST.EDU> On Behalf Of Oscar Kolsteren Sent: woensdag 21 september 2022 17:04 To: ADSM-L@VM.MARIST.EDU Subject: Re: SQL query replnodes 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://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 ******************************************************** 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 ******************************************************** 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 ******************************************************** 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
