Changing the wrapper for a data source

You can change the wrapper that you use to access a data source after you upgrade. You might change a wrapper when you want to upgrade for new wrapper functionality.

1. Run the db2look command to create the necessary DDL statements. For example:

   db2look -d database_name -wrapper wrapper_name -e -o federated.sql

   This command creates an output file named federated.sql that contains the DDL statements for all the federated objects of the wrapper that you specify.
2. Edit the SQL statement in the federated.sql file to specify the new wrapper information.
3. If the wrapper that you plan to drop accesses remote tables that you created by using transparent DDL, create nicknames again for the remote tables. You can add the SQL statements for these nicknames to the federated.sql file.
4. Drop the wrapper.
5. Register the new wrapper with the federated database.
6. Add the client paths to the db2dj.ini file:
   1. Edit the db2dj.ini file to include the client paths for the data source that you are using.
   2. For all wrappers except for the Sysbase CTLIB, ODBC, and JDBC wrappers, issue the djxlink script to create new libraries in the DB2 installation directories.
   3. Issue the db2stop command.
   4. Issue the db2iupdt command to update your instances.
   5. Issue the db2start command to restart the DB2 instance.
7. Issue the SQL statements in the federated.sql file to configure access to the data source. For example:

   db2 -tvf federated.sql 

8. Bind any application packages that were invalidated when you dropped the wrapper. Packages that can be invalidated contain static SQL that references nicknames that were dropped and recreated.
9. Recreate any federated views that were invalidated when you dropped the wrapper. Views that were invalidated are the views that reference nicknames that were dropped and recreated.