Re: Fw: ADDING ADDITIONAL INSTANCE!

Datamas wrote: > > -----Original Message----- > From: Datamas <datamas@batelco.com.bh> > To: informix-list@iiug.org <informix-list@iiug.org> > Date: Sunday, October 25, 1998 10:19 AM > Subject: ADDING ADDITIONAL INSTANCE! > > >Hi all, > > > >Can any one tell me that how to add a second INSTANCE to > >Informix Online DSA version 6.x in HP-9000 in Unix with Raw partition, > >being a new DBA I want to know the A to Z procedure for this. Actually quite simple. Create a new ONCONFIG file, usually by copying the existing one to a new name. You MUST change the file/device for the ROOTPATH and/or ROOTOFFSET (and MIRRORPATH/MIRROROFFSET if you use it), the SERVERNUM, DBSERVERNAME, DBSERVERALIASES, MSGPATH (so each instance has its own logfile), LTAPEDEV if you intend to run ontape -c for both, DUMPDIR if you want to configure for core or shared memory dumps. In the sqlhosts file add the new DBSERVERNAME and DBSERVERALIASES with different service/port names than the existing instance. If the service names are new add them with unique port numbers to /etc/hosts. (OH! If you have moved the physical log to a dbspace other than root in the original instance {a good idea BTW} then change PHYSDBS back to the ROOTNAME value until the instance is online and you have created the additional dbspace to house it.) Now you are all set to set INFORMIXSERVER to the new DBSERVERNAME and ONCONFIG to the new onconfig filename and run oninit -i (TRIPLE CHECK THAT YOU ARE NOT POINTING TO YOUR EXISTING INSTANCE BEFORE YOU DO THIS!) Be VERY careful when adding new chunks/dbspaces that they do not overlap disk space used by the other instance. You can get my submission to the IIUG Software Repository, utils_ak, which contains a wrapper script to replace onspaces that checks for inter-instance overlap before running onspaces. It maintains its own, plain text, database of existing chunks to verify against and can create the database from the existing instance itself. It also protects against using multiple aliases for the same disk space which onspaces does not. That's it. Art S. Kagel