Determining Shared Memory Segments for an Informix instance

적용 가능한 인포믹스 버전 :  7.2, 7.3, 9.2, 9.3, 9.4, 10.0

Problem

Determine shared memory segment for a particular Informix instance - How to?

Solution

BEFORE YOU BEGIN This Korn-Shell script will help you to identify which segments are in use by which Informix® instance.  The output is similar to UNIX command ipcs –m, except the last columnDBSERVERNAME. The DBSERVERNAME representing the database server name. The value is equivalent to the ONCONFIG configuration file parameter DBSERVERNAME.  STEPS 1. Copy the file checkipc.txt to a work directory.  2. Change the name to checkipc 3. Execute the script using the following syntax: sh checkipc Sample Output The example shows that all the shared memory segments grouped by informix are in use by active Informix instances. There are 4 segments that belong totest940 instance, and 3 segments that belong to test731 instance. Shared Memory TYPE  ID        KEY        MODE OWNER    GROUP  DBSERVERNAME    m  582 0x52564801 --rw-rw----  root informix   test940    m   39 0x52564802 --rw-rw----  root informix   test940    m 2872 0x52564803 --rw-rw----  root informix   test940    m 5365 0x52564804 --rw-rw-rw-  root informix   test940    m 2866 0x52604801 --rw-rw----  root informix   test731    m 3219 0x52604802 --rw-rw----  root informix   test731    m    4 0x52604803 --rw-rw-rw-  root informix   test731

checkipc.txt

http://www-01.ibm.com/support/docview.wss?uid=swg21114995

checkipc.txt

0.0MB