Change the name of Informix server

Hi, I would like to change the Informix server name of the Informix database with version 9.30.TC1 installed on Windows NT server. How can I do this? Thanks, Vasilis

vasilis.economides@ctl.com (Vasilis Economides) wrote in message news:<adefb3eb.0412030250.12310e98@posting.google.com>... > Hi, > > I would like to change the Informix server name of the Informix > database with version 9.30.TC1 installed on Windows NT server. > > How can I do this? > > Thanks, > > Vasilis Shutdown the database Server edit the ONCONFIG-File : DVSERVERNAME new_name edit the registry : under ...software/informix/sqlhosts is an entry with the name of the server, change it under maybe %INFORMIXDIR% is a file *.cmd with the environment, change the servername you have a service for this server, look at the propertys, if something has to be changed and don't forget the clients, edit the registry (sqlhosts), change the environment in setnet32 I hope thats all Ruediger

> Shutdown the database Server > edit the ONCONFIG-File : DVSERVERNAME new_name > edit the registry : under ...software/informix/sqlhosts is an entry > with the name of the server, change it > under maybe %INFORMIXDIR% is a file *.cmd with the environment, change > the servername > you have a service for this server, look at the propertys, if > something has to be changed > and don't forget the clients, edit the registry (sqlhosts), change the > environment in setnet32 > I hope thats all There is also the Registry key: HKEY_LOCAL_MACHINE/Software/Informix/Online/%INFORMIXSERVER% That would need to be renamed (ie saved, deleted, a new key created and restored), then there's the Registry value: HKEY_LOCAL_MACHINE/Software/Informix/Online/%INFORMIXSERVER%/Environment/INFORMIXSERVER The Windows Service for the server would also need to be renamed (ie deleted and recreated). Once you've made these changes manually, don't expect uninstall to work correctly, unless you also change the many references to the server name in the unisntall section of the registry. An easier way to rename an instance on Windows (depending on how much data you have) would be to create a new instance with the new name using the Instance Manager (instmgr.exe), export the data from the old instance, delete the old instance with Instance Manager, and import the data to the new one. In the next major version of IDS (10.0) the Instance Manager will have a rename instance feature so the above methods will no longer be necessary. Regards Guy Ruediger Papke wrote: > vasilis.economides@ctl.com (Vasilis Economides) wrote in message news:<adefb3eb.0412030250.12310e98@posting.google.com>... > >>Hi, >> >>I would like to change the Informix server name of the Informix >>database with version 9.30.TC1 installed on Windows NT server. >> >>How can I do this? >> >>Thanks, >> >>Vasilis > > > Shutdown the database Server > edit the ONCONFIG-File : DVSERVERNAME new_name > edit the registry : under ...software/informix/sqlhosts is an entry > with the name of the server, change it > under maybe %INFORMIXDIR% is a file *.cmd with the environment, change > the servername > you have a service for this server, look at the propertys, if > something has to be changed > and don't forget the clients, edit the registry (sqlhosts), change the > environment in setnet32 > I hope thats all > > Ruediger

There's a set of utilities for Informix on NT that used to be called "ntutils" that used to be downloadable from the IBM/Informix website. It renamed servers and a lot more. File name was ntils.zip. I did a quick search of the IBM website and didn't find it. If anybody else knows if this file is still downloadable, please post an URL. If you can't find it, send me an email and I'll email you a copy. Joe Lumbley