Use this procedure to access Sybase data sources if you
upgraded the instance and database or only the database.
About this task
If you upgraded only the database, follow all of the steps
in this procedure.
If you upgraded the instance
and database on UNIX systems, you must do step
1 to restore the interfaces file, and you might
need to do additional steps.
Restrictions
When
upgrading databases to version 10.1, Sybase wrappers are changed to
fenced on Linux and UNIX systems.
Procedure
- 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.
- 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.
- Verify that the upgrade was successful:
- Connect to the database.
- 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.