RE: Multiple Residency & Shared Memory

I could be mistaken, but I thought what Mark was trying to say was that you couldnt identify the shared memory by the user who started the database. On AIX 4.3.2 with 7.3 he looks to be correct. I can not speak for other Operating systems Here is what I see on my box. Operating system. AIX $ oslevel 4.3.2.0 $ ps -ef | grep oni informix 10694 1 0 Jun 04 - 64:27 oninit informix 10856 10694 0 Jun 04 - 0:18 oninit informix 11094 10694 0 Jun 04 - 0:05 oninit informix 11352 10694 0 Jun 04 - 0:33 oninit informix 11610 10694 0 Jun 04 - 7:52 oninit informix 11868 10694 0 Jun 04 - 0:00 oninit informix 12126 10694 0 Jun 04 - 5:31 oninit informix 12384 10694 0 Jun 04 - 3:01 oninit informix 12642 10694 0 Jun 04 - 1:36 oninit informix 12900 10694 0 Jun 04 - 1:05 oninit informix 13158 10694 0 Jun 04 - 0:39 oninit informix 13416 10694 0 Jun 04 - 0:29 oninit informix 13674 10694 0 Jun 04 - 0:18 oninit informix 13932 10694 0 Jun 04 - 0:16 oninit drinfx 14824 1 0 Jun 04 - 0:25 oninit drinfx 14984 14824 0 Jun 04 - 0:19 oninit informix 15222 10694 0 Jun 04 - 0:22 oninit drinfx 15480 14824 0 Jun 04 - 0:05 oninit drinfx 15738 14824 0 Jun 04 - 0:04 oninit drinfx 15996 14824 0 Jun 04 - 0:05 oninit drinfx 16254 14824 0 Jun 04 - 0:00 oninit drinfx 16512 14824 0 Jun 04 - 0:05 oninit drinfx 16770 14824 0 Jun 04 - 0:04 oninit drinfx 18060 14824 0 Jun 04 - 0:21 oninit $ ipcsIPC status from /dev/mem as of Mon Jun 5 08:28:28 CDT 2000 T ID KEY MODE OWNER GROUP Message Queues: q 0 0x4107001c -Rrw-rw---- root printq q 1 0x001d8828 -Rrw-rw-rw- root dsadmin q 2 0x001cd3b0 -Rrw-rw-rw- root dsadmin q 3 0x001c0570 -Rrw-rw-rw- root dsadmin q 4 0x001d2680 -Rrw-rw-rw- root dsadmin q 5 0x001a9190 -Rrw-rw-rw- root dsadmin Shared Memory: m 1 0x52574801 --rw-rw---- root informix m 2 0x52574802 --rw-rw---- root informix m 3 0x52574803 --rw-rw-rw- root informix m 5 0x526a4801 --rw-rw---- root informix m 6 0x526a4802 --rw-rw---- root informix m 7 0x526a4803 --rw-rw-rw- root informix m 8 0x0d050177 --rw-rw-rw- root system Semaphores: s 131072 00000000 --ra-ra---- root informix s 1 0x620500d0 --ra-r--r-- root system s 2 00000000 --ra-ra-ra- root informix s 3 00000000 --ra-ra-ra- root informix s 4 00000000 --ra-ra---- root informix s 5 00000000 --ra-ra-ra- root informix s 6 0x01050057 --ra------- root system Am I missing something? Will >===== Original Message From "jim lowry" <lowryjim@hotmail.com> ===== >> > >> > Guess each has their own way... 8-) >> >>I guess you mean each database vendor. That is true. > >Each company vendor or user. > >> >> > A database (not engine) may be started >> > by a user other than Informix depending >> > on the application, how it was designed >> > and what it was designed to do. >> >>An Informix database can be opened by any user who has privileges, that >>is true. > >With out expanding.. yes > >> >> > With a rather large company (lets say the mouse) >> > and limited resources (dba's that have been >> > around longer then 6 months) it is easier >> > to remove shared mem by owner. And that way >> > you would not need to be calculating an instances >> > shared memory. >> >>That might be the case, but Informix databases allocate shared memory >>owned by root (or informix in older versions), NOT by users. So you >>cannot use that method of identification. > >when a used "db_owner_1" starts a database, you can follow >it when using "ipcs" Anyone can be setup to be the owner of >a database. > >> >>If you have multiple Informix database servers, then the only way to >>identify shared memory is by calculating the addresses per server. If >>you have one Informix database server, but multiple databases, then they >>all share the same shared memory anyway. > >wrong > > >> >> > Many factors go into how databases are started >> > and how shared mem is cleared. >> >>Yes, and you seem to have them confused. When you open an Informix >>database no shared memory is allocated. The segments allocated to the >>server are shared by all users. This is possibly where it gets it's name >>from. ;-) > >Beg to differ but the one who appears confused is you. It is people >who are unable to think outside the box that believe there is >only one way to do things. > >For a given project, I was forced to run 4 databases using 4 different >names owned by 4 different id's. Ver 7.23 on a 6000 Sun box with >750 gig, 12 cpus and 8 gig of mem. But I'm sure your databases are >just as big if not bigger. > >> >>I am concerned that the novices (Informix DBA's that have been around >>less than 6 months :) on the list may be confused by your comments. Art >>has explained it, I have explained it, if you don't believe us, then you >>can browse the manuals for free. > >Please excuse my concern, but maybe you should... > >have a great day. ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------