Informics 2 instances - single package

[Karthik S S]

We have a requirement to configure two Informix instances in a single package in MC/SG Extended cluster setup. I went through the ECM toolkit and found that it monitors for "oninit" process and restarts it. In Informix, each instance is associated with an "oninit" process. In a single instance setup when we manually kill oninit process the instance restarts again as configured. What is the reaction in a two instance setup with both the instance having the same process name "oninit"? How can I achieve individual instance restart in case of a process kill ?


Pl. help

Thanks,
Karthik S S

[Sridhar Bhaskarla]

Hi Karthik,

I don't know about ECM but I worked on Oracle toolkit. They are basically designed for a single instance (for ex., in oracle toolkit script, the place where you define oracle instance is SID_NAME which cannot take more than one SID.

So, I am afraid you may have to modify the script to suit to your requirements. You can use the base template but will need to modify the cases like fault, monitor, start,halt etc., depending on how the script is written to include manipulation of two instances.

-Sri

[Luk Vandenbussche · Accepted solution]

Hello Karthik,

You must create two oninit processes

oninit_inst1
oninit_inst2

This can be done in informix.

we implemented it for two informix packages on a cluster.
I don't have access to the server now.
But here you find the informix.sh script

[V.Tamilvanan]

Hi Karthick,
You must install the Informix binaries in 2 different Informix directory for 2 different instances. Then rename the oninit binary of each with different name. Ex: oninit_inst1, oninint_inst2. Replace the oninit with either oninit_inst1/oninit_inst2 on the monitoring script according to your requirement.

I hope this addresses your problem.

[Karthik S S]

Hi Luk,

But how do I create two on_init processes?? Do you mean I need to link the binary with two different names?. Even if I do so the target binary is only one which inturn will affect both the instances if restarted right? Or do I have to install Informix binaries on two different locations?. Kindly clarify.

Thanks
Karthik S S

[Luk Vandenbussche]

Karthik,

I think you have to create link. But I an not sure. We configured it on the cluster of a customer almost 3 years ago. I don't have access to this server from my current location.

good luck

[V.Tamilvanan]

Hi Karthick,
Yes.As I told earlier itself u need to install informix binaries in two different location and rename the oninit binary file in each location with different name.
Note:- We are running around 6 instances of informix on a single sytem like this.

Hope this helps.

[Umapathy S]

Karthik,
As Tamil said, you need to copy the oninit binary and rename it to oninit-instance name.

As also the onconfig file is copied and replicated for each instance.

Umapathy

[Karthik S S]

Hi Tamil/Umapathy,

Thanks for your answers. But you said you have 6 instances running on a single system. Does that mean you have installed the binaries at 6 different locations?? ( I dont think so ). Well may be in my requirement I need to have the binaries separately as I am configuring two instances with in a single MC Service Guard Package as individual services.

Is it not possible to only copy the oninit binary to onint_inst1 and oninit_inst2 (not linking it but physically copy it to two files) and define onconfig for these two binaries? rather than installing the whole informix binares at two different locations. I am not very familar with Informix. Pl. clarify.

Thanks,
Karthik S s

[Umapathy S]

Karthik,

There is no need to put in different locations unless there is a specific need. For us it resides in $INFORMIXDIR/bin/oninit_instance_name>

The installation for IDS was done only once. Just copy the oninit binary and copy onconfig.std and change accordingly for that instance.

HTH,
Umapathy

[Umapathy S]

And remember to set ONCONFIG env correct. This is where most of the mistakes happen when supporting more than one instance.