
Appendix B. Configuring data sources in DB2 Information Integrator 239
(set remote_authid ‘Administrator’)
alter user mapping for Administrator server ORACLESERVER options
(set remote_password ‘newpass’)
User mappings may also be altered through the DB2 Control Center.
B.2.5 Create the Oracle nickname
Once the Oracle wrapper, the server definition, and the user mapping are
complete, one needs to test the connection to the data source.
After successfully testing the connection to the data source (not shown here),
one may create nicknames for the database objects on the data source.
One may choose to define data mappings and function mappings durin ...