dbTalk Databases Forums  

IIMONITOR question

comp.databases.ingres comp.databases.ingres


Discuss IIMONITOR question in the comp.databases.ingres forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
David Greenberg
 
Posts: n/a

Default IIMONITOR question - 02-02-2009 , 03:47 AM






Hi

We use an old Ingres version on Alpha/VMS, II 2.0/0308.

When I'm in IIMONITOR and run the "show sessions" command, is there any
way I can identify my own session ID (in other words the session ID of
the IIMONITOR) ?

Thanks

David Greenberg

Reply With Quote
  #2  
Old   
Martin Bowes
 
Posts: n/a

Default Re: [Info-Ingres] IIMONITOR question - 02-02-2009 , 04:27 AM






Hi David,

I don't think you could do that reliably with just 'show
sessions'...although in most likelihood, the iimonitor session will be
the last session listed, but that's only on the initial connection..with
lots of 'ifs' thrown in.

You really need to run 'show user sessions formatted' and find the one
with:
Activity: (Monitor Session)

Martin Bowes.

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
David Greenberg
Sent: 02 February 2009 08:48
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: [Info-Ingres] IIMONITOR question

Hi

We use an old Ingres version on Alpha/VMS, II 2.0/0308.

When I'm in IIMONITOR and run the "show sessions" command, is there any
way I can identify my own session ID (in other words the session ID of
the IIMONITOR) ?

Thanks

David Greenberg
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://www.kettleriverconsulting.com...fo/info-ingres


Reply With Quote
  #3  
Old   
Michael Leo
 
Posts: n/a

Default Re: [Info-Ingres] IIMONITOR question - 02-02-2009 , 07:53 AM



David,

If you do a

"show sessions formatted"

you can see if a session is a "Monitor Session".

That is how I reliably do it.

Mike Leo

On Feb 2, 2009, at 2:47 AM, David Greenberg wrote:

Quote:
Hi

We use an old Ingres version on Alpha/VMS, II 2.0/0308.

When I'm in IIMONITOR and run the "show sessions" command, is there
any
way I can identify my own session ID (in other words the session ID of
the IIMONITOR) ?

Thanks

David Greenberg
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://www.kettleriverconsulting.com...fo/info-ingres


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.