[Info-Ingres] IMA usage 2 dbms processes

[John Dennis]

Gareth,

No ideas as to why ima is showing different servers to that from
iinamu. When I tested on both 2.6 and 2006r2 the servers returned from
your query always match those returned form iinamu. I do note however
that the ima query returns the recovery server ID as well as the DBMS.
That ID matches a "show iusvr" from iinamu.

John

On Sep 25, 11:22 pm, "Gareth Williams" <Gareth.Willi... at bromor-
tr.wales.nhs.uk> wrote:
> Anyone got any ideas?
>
> -----Original Message-----
> From: info-ingres-boun... at kettleriverconsulting.com [mailto:info-ingres-boun... at kettleriverconsulting.com] On Behalf Of Gareth Williams
> Sent: 21 September 2007 09:15
> To: info-ing... at kettleriverconsulting.com
> Subject: Re: [Info-Ingres] IMA usage 2 dbms processes
>
> I think I may have found the problem (for me)
>
> when I execute ima_set_vnode_domain and then "select SERVER FROM IMA_server_sessions group by server"
>
> I get...
>
> jupiter::/@57565
> jupiter::/@57569
>
> When I execute iinamu> show I get
>
> INGRES    *               57567
> INGRES    *               57569
>
> Different ID's!
>
> This suggests to me that one of the DBMS processes has "died" and someone has done a ingstart iidbms to get it back. It was then assigned a different number.
>
> How can I get IMA to reflect this other than restarting the whole installation?