why is this select statement not working? I want to query for nodes that is NOT enabled.
I can find couple doing Q N * F=D on smaller server under 100 nodes and see replication state: n/a or none
Select node_name from nodes where repl_state='enabled' or 'disabled' or 'none'
is it repl_state or replstate?
I have in my table as REPL_STATE
and per command, we user UPDATE NODE REPLSTATE=enabled
I can find couple doing Q N * F=D on smaller server under 100 nodes and see replication state: n/a or none
Select node_name from nodes where repl_state='enabled' or 'disabled' or 'none'
is it repl_state or replstate?
I have in my table as REPL_STATE
and per command, we user UPDATE NODE REPLSTATE=enabled