Modifying data source configurations

Over time you might find the need to modify the data source configurations for your federated system. For example, if your data sources change, you might need to update server definitions, nicknames, and user mappings. You might also need to add or remove access to data sources from your federated system.

You can alter objects by issuing SQL statements from the Db2® command line. You can also use the SQL and XQuery editor in IBM® Data Studio to issue SQL scripts. For the supported Db2 data sources and the Oracle data source, you can use the Administration Explorer in IBM Data Studio that provides dialog boxes and wizards that guide you through the task of altering federated objects.