Rename "demo_on" db server and create new db server?

All:

We use Informix where I work and I have built a virtual Debian server
to become more acquainted with the database. My question is how do I
rename the "demo_on" server and also create a new db server on the
same box.

I have read through the documentation but have not found what I'm
looking for. Also, I have tried to rename "demo_on" db server that
was created when installing the software. Changes where made to the
following files.

- onconfig
MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror
DBSERVERNAME demo_on

- sqlhosts
demo_on onipcshm vm-debian-4 demo_on

- environment variables
INFORMIXSERVER=demo_on

After making the changes and restarting the processes, the db server
will not start until everything is placed back to original state.

Thank you,
Christopher

the changes you have to make are:

in $INFORMIXDIR/etc/$ONCONFIG:

change
DBSERVERNAME demo_on
to
DBSERVERNAME yournewserver

$INFORMIXDIR/etc/$INFORMIXSQLHOSTS when set or $INFORMIXDIR/etc/
sqlhosts

change
demo_on onipcshm vm-debian-4 demo_on

to

yournewserver onipcshm vm-debian-4 demo_on

you could change it also to

yournewserver onipcshm vm-debian-4 yournewserver



- environment variables
change
INFORMIXSERVER=demo_on
to
INFORMIXSERVER= yournewserver

do not change rootpath or mirror!!! because these are real devices or
files unless you want to reintialize.
the values of these are also in the reserved pages which reside in
rootpath and mirror.

This should do it, if it does not start it with oninit -v to see why
it does not start and post the logfile
(onstat -m ) or have a look in $INFORMIXDIR/etc/$ONCONFIG

MSGPATH

Superboer.


On 5 mrt, 16:31, epsilon wrote:
> All:
>
> We use Informix where I work and I have built a virtual Debian server
> to become more acquainted with the database.  My question is how do I
> rename the "demo_on" server and also create a new db server on the
> same box.
>
> I have read through the documentation but have not found what I'm
> looking for.  Also, I have tried to rename "demo_on" db server that
> was created when installing the software.  Changes where made to the
> following files.
>
> - onconfig
>     MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror
>     DBSERVERNAME demo_on
>
> - sqlhosts
>     demo_on onipcshm        vm-debian-4     demo_on
>
> - environment variables
>     INFORMIXSERVER=demo_on
>
> After making the changes and restarting the processes, the db server
> will not start until everything is placed back to original state.
>
> Thank you,
> Christopher