[Info-ingres] select * from remotecmdl

[Karl and Betty Schendel]

> On Nov 18, 2019, at 7:25 AM, nikosv <nikos.vaggalis at gmail.com> wrote:
> 
> In IPM I see an entry of: 
> 
> │a6b1c100│ingres       │batch │imadb       │BIOR  │CLF│select * from remotecmdl
> 
> What is that???I don't remember seeing that before

That's the queue query from the remote command server.  The query itself
is normal, but I'm not entirely sure why it would be visible; it should
run and then go idle.

> 
> htop also shows many instances of 
> /opt/Ingres/IngresK1/ingres/bin/iidbms dbms (default) K1
> and 
> /opt/Ingres/IngresK1/ingres/bin/iidbms recovery (dmfrcp) K1
> 
> should I be worried?

If they are different threads under the same parent process, it's OK.
It's also OK to have multiple parent "iidbms dbms" as long as it
was configured that way.

If you have multiple parent process "iidbms recovery" then it's likely
that a shutdown got hosed in some way, and I'd suggest shutting
down the installation, cleaning up all rogue processes manually if
necessary (don't forget dmfacp), cleaning shared memory, and
restarting.