[Info-Ingres] IMA usage 2 dbms processes

[Gareth Williams]

One thing...
 
I seem to get 2 server IDs...
 
jupiter::/@57565                                                
jupiter::/@57569                                               

So I can see the DBMS processes as in write behind/recovery etc. but only the user sessions from one of them

 
Thanks
 
Gareth
 
________________________________

From: info-ingres-bounces at kettleriverconsulting.com [mailto:info-ingres-bounces at kettleriverconsulting.com] On Behalf Of Gareth Williams
Sent: 17 September 2007 09:31
To: info-ingres at kettleriverconsulting.com
Subject: Re: [Info-Ingres] IMA usage 2 dbms processes


ok,
 
so should this work...?
 
    isql imadb
    execute procedure ima_set_vnode_domain;
    select count(*) from ima_server_sessions;
 
It's still only bringing back half of what I expect. I've also tried the full update statement.
 
Thanks
 
Gareth
 


________________________________

From: info-ingres-bounces at kettleriverconsulting.com [mailto:info-ingres-bounces at kettleriverconsulting.com] On Behalf Of John Smedley
Sent: 13 September 2007 18:35
To: info-ingres at kettleriverconsulting.com
Cc: Gareth Williams
Subject: Re: [Info-Ingres] IMA usage 2 dbms processes



The following SQL update extends the domain from the MIB server to all servers in the local instance of Ingres: 

UPDATE ima_mib_objects 

SET value = DBMSINFO('IMA_VNODE') 

WHERE classid = 'exp.gwf.gwm.session.control.add_vnode' 

AND instance = '0' 

AND server = DBMSINFO('IMA_SERVER');

Or use the DBP on IMADB: ima_set_vnode_domain 


To extend the domain to a remote VNODE called "GRFR6": 

UPDATE ima_mib_objects 

SET value = 'GRFR6' 

WHERE classid = 'exp.gwf.gwm.session.control.add_vnode' 

AND instance = '0' 

AND server = DBMSINFO('IMA_SERVER');


To remove the 'GRFR6' VNODE from the MIB server domain:

 

UPDATE ima_mib_objects 

SET value = 'GRFR6' 

WHERE classid = 'exp.gwf.gwm.session.control.del_vnode' 

AND instance = '0' 

AND server = DBMSINFO('IMA_SERVER');

Cheers

John Smedley

________________________________________

From: info-ingres-bounces at kettleriverconsulting.com [mailto:info-ingres-bounces at kettleriverconsulting.com] On Behalf Of Gareth Williams

Sent: 13 September 2007 16:22

To: info-ingres at kettleriverconsulting.com

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

I'm calling simple commands via ODBC to the imadb database

 

e.g.

 

select * from ima_server_sessions

 

I've preceded this with... (all on the same session)

 

ExecuteSQL("SET SESSION AUTHORIZATION '$ingres'", cnn)

ExecuteSQL("SET SESSION WITH DESCRIPTION='Monitor2007';", cnn)

ExecuteSQL("EXECUTE PROCEDURE ima_set_server_domain ", cnn)

ExecuteSQL("EXECUTE PROCEDURE ima_set_vnode_domain ", cnn)

 

I have 2 dbms processes, bit I'm not getting back user sessions on the second DBMS process.

 

Can someone let me know what I'm missing

 

Thanks

 

Gareth

 

Cymraeg:- 

Mae'r neges hon yn gyfrinachol.Os nad chi yw'r derbynnydd y bwriedid y neges ar ei gyfer, byddwch mor garedig â rhoi gwybod i'r anfonydd yn ddioed. 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 o hebiaeth 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.

 

Cymraeg:- 
Mae'r neges hon yn gyfrinachol.Os nad chi yw'r derbynnydd y bwriedid y neges ar ei gyfer, byddwch mor garedig â rhoi gwybod i'r anfonydd yn ddioed. 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 o hebiaeth 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 <http://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 <http://www.bromor-tr.wales.nhs.uk/> .

 


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.kettleriverconsulting.com/mailman/private/info-ingres/attachments/20070917/b25128aa/attachment-0001.html