DB Dummy|Sharing Experience on Oracle & Informix Databases …

Home|rss|OUR STRENGTH

September 19 2014

How to check from Informix server if connections came from shared memory

from onstat -g ath output
grep for sm_read

informix@xxxxxxx: onstat -g ath | grep sm_read
23519 5d7ce028 5aa622d0 1 cond wait sm_read 8cpu sqlexec

To trace back the session
grep the 3rd column with onstat -u
informix@devlx005: onstat -u | grep 5aa622d0
5aa622d0 Y–P— 21045 informix 6 5bc6bd48 0 1 0 0

Session ID = 21045

Posted by ghsun25 in Informix Database
No Comments Read more
Search :
  • Recent Posts

    • Intercepting your record with triggles
    • How to check from Informix server if connections came from shared memory
    • Informix Archecker – point in time restore/recover table (Scenario 2)
    • Undefined subroutine &main::read_file called at crspatch.pm line 86. while running ./rootcrs.pl
    • HAIP is up on some nodes but not on all RAC nodes
  • Sponsors

  • Categories

    • Database General
    • Informix Database
    • Operating System
    • Oracle Database
    • Raspberry Pi
    • Ubuntu
    • UNIX / Linux
    • Utilities
  • Archives

    • October 2014
    • September 2014
    • August 2014
    • July 2014
    • June 2014
    • February 2014
    • January 2014
    • December 2013
    • October 2013
    • September 2013
    • June 2013
    • February 2013
    • November 2011
    • October 2011
    • March 2011
    • January 2011
    • September 2010
    • August 2010
    • July 2010
    • June 2010
    • May 2010
  • Meta

    • Log in
© All Rights Reserved. DB Dummy