Accessing Sybase data sources after upgrading

Use this procedure to access Sybase data sources if you upgraded the instance and database or only the database.

1. Ensure that the Sybase default interfaces file includes an entry for the server that you specify to connect to the Sybase wrapper. The default file on Windows is %SYBASE%\ini\sql.ini. The default file on UNIX and Linux is $SYBASE/interface.
   Optional: If you do not have write authority on the file or do not want to use the file, you can restore the copy of the interfaces file that you made before upgrading. You can save this restored file in the $instancehome/sqllib directory where instancehome is the home directory of the instance owner.
2. Ensure that the Sybase environment variables are specified in the db2dj.ini file. See Setting the Sybase environment variables for information on how to set the Sybase environment variables.
3. Verify that the upgrade was successful:
   1. Connect to the database.
   2. Issue SELECT, INSERT, UPDATE, and DELETE statements on the nicknames to verify that you can view and modify the data. You can also open a passthrough session to the remote database, and issue a SELECT statement on a remote table.