
234 DB2 II and WPS Synergy
B.2.3.1 Altering the Oracle server definitions and options
You may modify a server definition when you:
Upgrade a data source to a new version, for example:
alter server ORACLESERVER version 9
Want to modify the server options
Server options are set to values that persist over successive connections to
the data source. The values are stored in the federated system catalog. The
following example activates (add), sets and deactivates (drop) a server
option:
alter server ORACLESERVER options (add IO_RATIO ‘2.0)
alter server ORACLESERVER option (set IO_RATIO ‘3.0’)
alter server ORACLESERVER option (drop IO_RATIO)
To temporar ...