Re: Interference among instances

Kristopher Sarpolis, responding to my problem, wrote: > Check your sqlhosts file and make sure that ALL service names are > unique. Even the ones for shared memory connections. I recall the > documentation saying that they are not used for shared memory > connections but if you make two the same you get screwy things like > you are experiencing.. > > Example: > > shm1 onipcshm myhost unused # Wrong! > net1 onsoctcp myhost net_svc1> > shm2 onipcshm myhost unused # Wrong! > net2 onsoctcp myhost net_svc2 Thaks much, Kris! You hit that one on the head, sorta... Both service names for the share-memory-connections were "dummy". I added prefixes (prefices? ;-) and changed these dummy service names as below: bcbgshm onipcshm fb01 bcbg_dummy bcbgsoc onsoctcp fb01 bsoc bctestshm onipcshm fb01 bctest_dummy bctestsoc onsoctcp fb01 bctest_svc and it changed the circumstance. This is where the "sorta" comes in: After starting my test instance, the bctestshm server, I go back to the production window (running the bcbgshm server). Now the 761 error does not happen. It goes directly to the 25588 error. As before, the 25588 problem persists [on bcbgshm] even after I have knocked down the bctestshm server. I had to bounce the bcbgshm server again. Fortunately, I was able to - Yesterday, I couldn't get rid of one zombie shared memory segment. BTW, in case it is relevant, here is the tail end of /etc/services: bsoc 2500/tcp # Informix communication port bctest_svc 2501/tcp # Informix test bed communication port And no, these numbers do not conflict with any other service. So, I still need solutions, ideas, bugs, workarounds. HELP! -- -- Jake (Never yelled "CROWDED THEATER!" during a fire) +------------------------------------------------------------+ | The expedient performance of a task with excessive concern | | regarding its duration-to-completion engenders a virtual | | certainty of diminished benefit therefrom. | | -- Benjamin Franklin (but he said it in 3 words) | +------------------------------------------------------------+