Re: How to rename Informix Instance name

Posted in 2003

The Big Potatoe — Mon, 23 Jun 2003 15:39:12 +0100 — source: Usenet: comp.databases.informix

Tsutomu Ogiwara wrote: > Hi Chavan. > > Try the following. > > 1. rename DBSERVERNAME in your ONCONFIG file. > 2. rename 1st entry in your sqlhosts file. > 3. rename INFORMIXSERVER variable. > 4. bounce your IDS. > > e.g) > 1. DBSERVERNAME tsutoo930uc3shm # Name of default database server > tsutoo930uc3 > 2. tsutoo930uc3shm onipcshm cspc08 sqlexec > tsutoo930uc3 > 3. setenv INFORMIXSERVER tsutoo930uc3shm > tsutoo930uc3 > 4. onmode -ky; oninit > > HTH. > > -- > Tsutomu Ogiwara from Tokyo Japan. > ICQ#:168106592 > > > > > > >>From: "Chavan Koya" <chavankoya189@hotmail.com> >>To: "Informix Mailing List" <informix-list@iiug.org> >>Subject: How to rename Informix Instance name >>Date: Sun, 22 Jun 2003 19:05:14 -0500 >> >>Hello All, >> Is it possible to rename existing Informix Instance name, if >>it is, How ? >> >>Thanks in advance. >> >>Chavan Koya > > > _________________________________________________________________ > MSN 8 with e-mail virus protection service: 2 months FREE* > http://join.msn.com/?page=features/virus > > sending to informix-list Err, not in that order ;) You will not be able to shutdown the instance because at that point you will have an invalid INFORMIXSERVER / DBSERVERNAME 1. Shutdown your instance. 2. Change your DBSERVERNAME in the $ONCONFIG. 3. Set up the correct sqlhosts entry. 4. Start your engine Squashed potatoe