[Info-Ingres] RES: IMA usage 2 dbms processes

[Leandro Pinto Fava]

Hi Gareth,

I remember I used statements like these to expand the domains to get info about more than one DBMS:

select dbmsinfo('ima_server') as :vl_curPlace;
execute procedure ima_expand_domain (entry = :vl_place);

See Ingres 2006 System Administrator Guide at page 270:
"Extending the Domain in the Local Instance"

HTH.

Leandro Fava
SINF-UNISC http://www.unisc.br
Fone: +55 51 3717 7636

> -----Mensagem original-----
> De: info-ingres-bounces at kettleriverconsulting.com [mailto:info-ingres-
> bounces at kettleriverconsulting.com] Em nome de Gareth Williams
> Enviada em: quinta-feira, 13 de setembro de 2007 13:07
> Para: Grant Croker
> Cc: info-ingres at kettleriverconsulting.com
> Assunto: Re: [Info-Ingres] IMA usage 2 dbms processes
> 
> Sorry, perhaps I'm not making myself clear...
> 
> I'm not getting anything even in ima_server_sessions for sessions
> attached to the second DBMS.
> 
> Cheers
> 
> Gareth
> 
> 
> 
> -----Original Message-----
> From: info-ingres-bounces at kettleriverconsulting.com
> [mailto:info-ingres-bounces at kettleriverconsulting.com] On Behalf Of
> Grant Croker
> Sent: 13 September 2007 16:47
> To: Gareth Williams
> Cc: info-ingres at kettleriverconsulting.com
> Subject: Re: [Info-Ingres] IMA usage 2 dbms processes
> 
> On 13/09/07 17:22, Gareth Williams wrote:
> > I'm calling simple commands via ODBC to the imadb database
> >
> > e.g.
> >
> > select * from ima_server_sessions
> > <snipage>
> >
> Hi Gareth,
> 
> you need to join ima_server_sessions with ima_server_sessions_desc to
> get the description info. For example:
> 
> select
>     iss.server,iss.session_id,
>     iss.effective_user,
>     issd.session_desc
> from
>     ima_server_sessions iss,
>     ima_server_sessions_desc issd
> where
>     iss.server= issd.server and
>     iss.session_id=issd.session_id
> 
> regards
> 
> grant
> 
> 
> > _______________________________________________
> > Info-Ingres mailing list
> > Info-Ingres at kettleriverconsulting.com
> > http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
> >
> 
> 
> --
> Grant Croker - Software Engineer - http://ingres.com There are many
> rhymes about magpies, but none of them is very reliable because they are
> not the ones the magpies know themselves.
>         -- (Terry Pratchett, Carpe Jugulum)
> 
> _______________________________________________
> Info-Ingres mailing list
> Info-Ingres at kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
> Cymraeg:-
> Mae'r neges hon yn gyfrinachol nad chi yw'r derbynnydd y bwriedid y neges
> ar ei gyfer, byddwch mor garedig â rhoi gwybod
> i'r anfonydd yn ddi-oed. Dylid ystyried un rhywd datganiadau neu sylwadau
> a wneir uchod yn rhai personol,ac nid o angen rhaid yn rhai o
> eiddo Ymddiriedolaeth GIG Bro Morgannwg, nac unrhyw ran gyfansoddol ohoni
> na chorff cysylltiedig.
> 
> Cofiwch fod yn ymwybodol ei bod yn bosibl y bydd disgwyl i Ymddiriedolaeth
> GIG Bro Morgannwg roi cyhoeddusrwydd i gynnwys unrhyw ebost neu
> ohebiaeth a dderbynnir, yn unol ag amodau'r Ddeddf Rhyddid Gwybodaeth
> 2000. I gael mwy o wybodaeth am Ryddid Gwybodaeth, cofiwch gyfeirio
> at wefan Ymddiriedolaeth GIG Bro Morgannwg ar www.bromor-tr.wales.nhs.uk
> 
> English:-
> This message is confidential. If you are not the intended recipient of the
> message then please notify the sender immediately.
> Any of the statements or comments made above should be regarded as
> personal and not necessarily those of Bro Morgannwg NHS Trust, any
> constituent part or connected body.
> 
> Please be aware that, under the terms of the Freedom of Information Act
> 2000, Bro Morgannwg NHS Trust may be required to make public the
> content of any emails or correspondence received. For further information
> on Freedom of Information, please refer to the Bro Morgannwg NHS
> Trust website at www.bromor-tr.wales.nhs.uk.