[Info-Ingres] RES: IMA usage 2 dbms processes
- From: "Leandro Pinto Fava" <leandro@xxxxxxxx>
- Date: Thu, 13 Sep 2007 13:48:12 -0300
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@xxxxxxxxxxxxxxxxxxxxxxxxx [mailto:info-ingres-
bounces@xxxxxxxxxxxxxxxxxxxxxxxxx] Em nome de Gareth Williams
Enviada em: quinta-feira, 13 de setembro de 2007 13:07
Para: Grant Croker
Cc: info-ingres@xxxxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx
[mailto:info-ingres-bounces@xxxxxxxxxxxxxxxxxxxxxxxxx] On Behalf Of
Grant Croker
Sent: 13 September 2007 16:47
To: Gareth Williams
Cc: info-ingres@xxxxxxxxxxxxxxxxxxxxxxxxx
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 databaseHi Gareth,
e.g.
select * from ima_server_sessions
<snipage>
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@xxxxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx
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.
.
- Prev by Date: Re: [Info-Ingres] IMA usage 2 dbms processes
- Next by Date: Re: [Info-Ingres] IMA usage 2 dbms processes
- Previous by thread: Re: [Info-Ingres] IMA usage 2 dbms processes
- Next by thread: [Info-Ingres] VDBA/Ingres upgrade on your PC
- Index(es):
Relevant Pages
|
|
