To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.
Course Of The Month
8 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Informix shutdown and startup script for RHEL cluster suite
Posted on 2008-06-24
Good day. Can you give us a sample shutdown and start up script for Informix database that is running on a RHEL 4 cluster suite so that if one node fails, the informix database will start automatically on the other node during failover.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
3
10 Comments
oninit starts informix
onmode -kui halts after comiting transaction
informix does transaction replication which is by a grade smarter than "RHEL start automatically"
onmode -kui halts after comiting transaction
informix does transaction replication which is by a grade smarter than "RHEL start automatically"
Hi,
It will help, but I'm looking for the startup script in which the other node will automatically starts the informix database. Either graceful shutdown or transferring the Cluster Suite services
Thanks in advance
It will help, but I'm looking for the startup script in which the other node will automatically starts the informix database. Either graceful shutdown or transferring the Cluster Suite services
Thanks in advance
Informix is pretty much self-contained.
http://www.redbooks.ibm.com/abstracts/sg247488.html?Open
It moved tape libraries and clustered years before mainstream systems got close to that.
Facilities vary between inetd-launched SE, multithreaded IDS and distributed RedBrick.
Let me suggest it co-exists pretty well with whatever cluster software you ever install, but will survive without it
http://www.redbooks.ibm.com/abstracts/sg247488.html?Open
It moved tape libraries and clustered years before mainstream systems got close to that.
Facilities vary between inetd-launched SE, multithreaded IDS and distributed RedBrick.
Let me suggest it co-exists pretty well with whatever cluster software you ever install, but will survive without it
what i'm looking is a script that will start informix automatically on other node when you transfer the service.
This is the senario,
-transfer the cluster service (for ex. INFORMIX) using "clusvcadm" to other node.
-Once the INFORMIX service was transferred to the other node the Informix database will automatically start.
This is the senario,
-transfer the cluster service (for ex. INFORMIX) using "clusvcadm" to other node.
-Once the INFORMIX service was transferred to the other node the Informix database will automatically start.
It seems you do not get idea from Informix documentation.
Do you have shared storage? Shared IP address? It is different command lines to oninit and onmode. I cannot guess your Informix and cluster setup,
Do you have shared storage? Shared IP address? It is different command lines to oninit and onmode. I cannot guess your Informix and cluster setup,
Then it is quite easy without Informix replication and master/slave coordination.
Do you intend to use raw 2G partitions for informix or one ext2 partition for all data files on shared storage? First gives higher performance but second is somewhat easier to maintain.
You should be absolutely sure storage is avaliable before starting informix using oninit.
Shutdown script is onmode -kuy
Both scripts set LD_PRELOAD or LD_LIBRARY_PATH and runs informix commands as "informix" user.
How to set up informix?
1) Hope you have informix install leaflet - basically install it on both systems in same directory and same numeric user/group ID.
2) create directory with symlinks to informix dbspaces on shared disk (data files)
3) initialize root dbspace with oninit -i on node accessing storage filesystem. (2G-4K is maximum 128MB is minimum)
4a) make sure you use ONSOCTCP x,200 connectors only.(get book named "informix Unleashed" from internet on gory SHM details)
4) now test failover scripts.
Take a note that database has to be checked when you lose storage cable and database state is somewhat incionsistent, under noraml conditions eg for system kernel update scripts will be fine. Not to mention fsck before mounting shared storage etc - this situation has to be checked before running production cluster.
5) add databases on "master" server, fail over to see they get on other side and test common client apps to handle failover.
If you have Informix DBA nearby these instructions are sufficient, otherwise I will spend more time instructing you how to install and initialize informix
Do you intend to use raw 2G partitions for informix or one ext2 partition for all data files on shared storage? First gives higher performance but second is somewhat easier to maintain.
You should be absolutely sure storage is avaliable before starting informix using oninit.
Shutdown script is onmode -kuy
Both scripts set LD_PRELOAD or LD_LIBRARY_PATH and runs informix commands as "informix" user.
How to set up informix?
1) Hope you have informix install leaflet - basically install it on both systems in same directory and same numeric user/group ID.
2) create directory with symlinks to informix dbspaces on shared disk (data files)
3) initialize root dbspace with oninit -i on node accessing storage filesystem. (2G-4K is maximum 128MB is minimum)
4a) make sure you use ONSOCTCP x,200 connectors only.(get book named "informix Unleashed" from internet on gory SHM details)
4) now test failover scripts.
Take a note that database has to be checked when you lose storage cable and database state is somewhat incionsistent, under noraml conditions eg for system kernel update scripts will be fine. Not to mention fsck before mounting shared storage etc - this situation has to be checked before running production cluster.
5) add databases on "master" server, fail over to see they get on other side and test common client apps to handle failover.
If you have Informix DBA nearby these instructions are sufficient, otherwise I will spend more time instructing you how to install and initialize informix
Attached init script.
informix.redhat.txt
informix.redhat.txt
Featured Post
Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Learn how to navigate the file tree with the shell.
Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Suggested Courses
Course of the Month8 days, 11 hours left to enroll
734 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.