EDU
Subject: Re: SQL query replnodes
Bonjour Eric,
If you find the node in the REPLICATIONVIEW table, it means it has replicated
at least once, which means it would also show up in Q REPLNODE.
Now, what I can't test at the moment is that once you do a REMOVE REPLNODE,
does it clea
T.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 f
2 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
Kind regards,
Eric van Loon
Core Infra
-Original Message-
From: ADSM: Dist Stor Manager 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 suspec
= nodes.node_name
order by filespaces.node_name, filespaces.filespace_name
Hope this helps.
Regards,
Joerg Pohlmann
-Original Message-
From: ADSM: Dist Stor Manager On Behalf Of Loon, Eric
van (ITOP DI) - KLM
Sent: Thursday, September 22, 2022 05:47
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-
--Original Message-
From: ADSM: Dist Stor Manager 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
R
stern
IBM
-Original Message-
From: ADSM: Dist Stor Manager On Behalf Of Loon, Eric
van (ITOP DI) - KLM
Sent: Thursday, September 22, 2022 09: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 e
nation replication node
Should both the repl_state and repl_node = "None" it is not being replicated
-Original Message-
From: ADSM: Dist Stor Manager On Behalf Of Loon, Eric
van (ITOP DI) - KLM
Sent: Thursday, September 22, 2022 8:47 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [EXT
t: 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://www.tsmexplorer.copm
> On 21 Sep 2022, at 19:28, Rick Adamson wrote:
>
lsteren
> 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. *
>
> --
just checking for the repl_state won't always do.
Thanks for your help!
Kind regards,
Eric van Loon
Core Infra
-Original Message-
From: ADSM: Dist Stor Manager On Behalf Of Rick Adamson
Sent: woensdag 21 september 2022 19:29
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL query replnodes
M
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 quer
r 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 i
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 on
new report.
Best Regards,
Oscar Kolsteren
Lead Storage Consultant, IBM Client Storage Assessment Team (UKI)
-Original Message-
From: ADSM: Dist Stor Manager 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]
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
, but than through a SQL query.
Thanks for any help in advance!
Kind regards,
Eric van Loon
Air France/KLM Core Infra
*
16 matches
Mail list logo