We are running Sybase 11.9 on a Sun Solaris server. We are planning to change our networking and
IP address. From the Sybase and Sun end, what changes are required?
This should not be too difficult. As you know Sybase is built on client-server architecture, and in that respect, all you need to do is changing the IP address of the host (which I trust will be done by a Unix guy), and you as a Sybase DBA updating the required entry for that server in the "interfaces" files.
Before changing the IP address, I suggest that you shut down Sybase and the backup server and anything else Sybase-related on that host. After the change of the host's IP address first time, make sure that Sybase is not started automatically at the host start-up time via the entry in /ect/init.d.
Once the host is back and the new IP address is allocated, do the following on the command line:
/usr/sbin/ifconfig -a lo0: flags=849<UP,LOOPBACK,RUNNING,MULTICAST> mtu 8232 inet 127.0.0.1 netmask ff000000 hme0: flags=863<UP,BROADCAST,NOTRAILERS,RUNNING,MULTICAST> mtu 1500 inet 220.127.116.11 netmask ffffff80 broadcast 18.104.22.168 hme1: flags=863<UP,BROADCAST,NOTRAILERS,RUNNING,MULTICAST> mtu 1500 inet 22.214.171.124 netmask ffffff00 broadcast 126.96.36.199
For example, the above host has two IP addresses. Your best bet is not to use the IP address in the interfaces file but use the logical network name of the host. Use Sybase's "dsedit" facility under $SYBASE/bin to modify the Sybase name of the ASE, the backup server and so on with the new name/IP address. Also update the same on any other interfaces file that makes a reference to this host. If you are an experienced DBA just use vi to paste the new entry in the interfaces files. PC users should update their sql.ini file etc. Note that here you are only changing the IP address. The Port No will remain the same. Once all is OK on the host, then you can start Sybase. Should be fairly straightforward. Good luck.
For More Information
- Dozens more answers to tough SQL Server questions from Mich Talebzadeh are available here.
- The Best Sybase Web Links: tips, tutorials, scripts, and more.
- Ask the Experts yourself: Our SQL, database design, SQL Server, DB2, Sybase, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
This was first published in February 2004